Oracle 19c

The Problem We were trying to run a RMAN script (running the duplicate database) from a Oracle 12c environment onto a 19c environment. The script worked perfectly fine on the 12c databases but was giving below error when run on a 19c database: RUN { allocate auxiliary channel d1 device type disk maxpiecesize 20G; allocate […]

Question: How to get PDB Datafile information when PDB in different Mode? Case 1 – PDB in mounted Mode PDB Status: SQL> select pdb_id, pdb_name, con_uid,status from dba_pdbs; PDB_ID PDB_NAME CON_UID STATUS ———- ————– ———- ————- 3 [PDB12C] 515133920 NORMAL 2 PDB$SEED 4105546291 NORMAL SQL> select con_id, name, open_mode, restricted from v$pdbs; CON_ID NAME OPEN_MODE […]

When Oracle Net server tracing is invoked using sqlnet.ora (see example below) tracing on the affected server processes will continue throughout the process lifetime. If tracing needs to be stopped without stopping the server process the following method can be used. Example: static server tracing using sqlnet.ora trace_level_server = 16 trace_directory_server = /tmp diag_adr_enabled = […]