/hub/pp1/26ai/grid/bin/crsctl start crs
su - oracleexport ORACLE_BASE=/hub/pp1/oracleexport ORACLE_HOME=/hub/pp1/oracle/product/26ai/dbcd /hub/pp1/oracle/adminllexport LANG=C./HUB3C01_1.shecho $?
cd /hub/pp1/oracle/diag/rdbms/hub3c01/HUB3C01_1/trace/grep ORA- alert_HUB3C01_1.log
export ORACLE_BASE=/hub/pp1/oracleexport ORACLE_HOME=/hub/pp1/oracle/product/26ai/dbORACLE_SID=HUB3C01_1; export ORACLE_SIDPATH=$ORACLE_HOME/bin:$PATH; export PATHexport NLS_LANG=AMERICAN_Japan.AL32UTF8
sqlplus / as sysdba
show pdbs;
-- CDBの状態確認COLUMN name FORMAT A20COLUMN open_mode FORMAT A15COLUMN cdb FORMAT A5
SELECT name, open_mode, cdbFROM v$database;
-- PDBの状態確認COLUMN con_id FORMAT 999COLUMN name FORMAT A30COLUMN open_mode FORMAT A15
SELECT con_id, name, open_modeFROM v$pdbsORDER BY con_id;
-- Database Componentsの状態確認set lines 500 pages 10000COLUMN con_id FORMAT 999COLUMN comp_id FORMAT A15COLUMN comp_name FORMAT A40COLUMN version FORMAT A15COLUMN status FORMAT A10
SELECT con_id, comp_id, comp_name, version, statusFROM cdb_registryORDER BY con_id, comp_id;