Oracle 19C commands

ALTER PLUGGABLE DATABASE PDB01,PDB02 close immediate;
ALTER PLUGGABLE DATABASE PDB01,PDB02 OPEN READ WRITE;

SQL> col value format a60
SQL> select * from V$DIAG_INFO ;

INST_ID NAME VALUE CON_ID
———- —————————— ———————————————————— ———-
1 Diag Enabled TRUE 0
1 ADR Base /u01/app/logs/oracle 0
1 ADR Home /u01/app/logs/oracle/diag/rdbms/CDB_a/CDB 0
1 Diag Trace /u01/app/logs/oracle/diag/rdbms/CDB_a/CDB/trace 0
1 Diag Alert /u01/app/logs/oracle/diag/rdbms/CDB_a/CDB/alert 0
1 Diag Incident /u01/app/logs/oracle/diag/rdbms/CDB_a/CDB/incident 0
1 Diag Cdump /u01/app/admin/oracle/admin/CDB_A/cdump 0
1 Health Monitor /u01/app/logs/oracle/diag/rdbms/CDB_a/CDB/hm 0
1 Default Trace File /u01/app/logs/oracle/diag/rdbms/CDB_a/CDB/trace/CX 0
1STAGE_ora_25506.trc

1 Active Problem Count 0 0
1 Active Incident Count 0 0
1 ORACLE_HOME /u01/app/product/db/19.0 0

SQL> show parameter back

NAME TYPE VALUE
———————————— ———– ——————————
background_core_dump string partial
background_dump_dest string /u01/app/product/db/19.0/rdbms/log

Leave a Reply

Your email address will not be published. Required fields are marked *