Container Database (CDB)

Oracle Enterprise Manager Database Express 19c - A Dialog from XDB ask for Credential

How to Remove EM Express XDB Credential Dialog

by Ed Chen
November 11, 2020November 12, 2020

You may surprisingly see a credential dialog from XDB like the feature image when you tried to login Oracle Enterprise Manager Database Express (EM Express).… Read More »

How to Resolve ORA-15173: entry 'pdbseed' does not exist in directory

by Ed Chen
November 4, 2020November 6, 2020

Saw errors when creating a 19c RAC database by DBCA like the following. [oracle@primary01 ~]$ vi $ORACLE_BASE/cfgtoollogs/dbca/ORCLCDB/trace.log_2020-10-13_19-42-05PM ... ORA-19504: failed to create file "+DATA01/ORCLCDB/pdbseed/sysaux01.dbf" ORA-17502:… Read More »

How to Build 19c RAC - 4 of 4 - Creating a RAC Database

by Ed Chen
October 28, 2020November 11, 2020

After Oracle database 19c software has been installed, we can now create a RAC database by Database Configuration Assistant (DBCA). [oracle@primary01 ~]$ dbca We would… Read More »

How to Clone Remote PDB

by Ed Chen
October 21, 2015November 4, 2020

Clone Remote PDB The step 1, and 2 are same as How to Clone a PDB From Another PDB in Same CDB, so we skip… Read More »

How to Clone Local PDB

by Ed Chen
October 20, 2015November 4, 2020

Clone Local PDB This time, we'd like to clone a PDB for testing purpose in the same CDB on DB level. [oracle@test1 ~]$ sqlplus /… Read More »

How to Unplug and Plug a PDB in Different Hosts

by Ed Chen
October 19, 2015July 22, 2020

The step 1, 2, 3 are same as How to Unplug and Plug a PDB in Same Host, so we skip those steps and directly go… Read More »

How to Unplug and Plug a PDB in Same Host

by Ed Chen
October 18, 2015July 22, 2020

First of all, check the status of the target PDB to unplug.SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ----------... 4 FINANCE_PDB… Read More »

Which Container Am I Using? Where Am I?

by Ed Chen
October 17, 2015November 4, 2020

You may find out there're too many PDB to make you manage them well, waste time to execute useless statements, or get lost in container… Read More »