Container Database (CDB)

How to Connect a PDB Directly by OS Authentication

by Ed Chen
December 23, 2020December 28, 2020

OS Authentication We usually connect to the database by / AS SYSDBA without providing any password for maintenance works, such as startup, shutdown and backup.… Read More »

How to Export a PDB without Password

by Ed Chen
December 23, 2020December 18, 2020

Export PDB If we want to export data from a Pluggable Database (PDB) using expdp as sysdba by OS Authentication, we will get errors like… Read More »

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, 2020February 18, 2021

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 Auto Open PDB When Startup CDB

by Ed Chen
August 15, 2020January 20, 2021

By default, the pluggable databases (PDB) are at MOUNT state after you startup the database. SQL> conn / as sysdba Connected. SQL> show pdbs … Read More »

How to Start Oracle Database

by Ed Chen
September 28, 2019February 16, 2021

Start Oracle Database To start an Oracle database, you have to know which database you want to start. This includes at least two things, Oracle… Read More »

How to Clone Remote PDB

by Ed Chen
October 21, 2015December 27, 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, 2015January 19, 2021

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, 2015January 19, 2021

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 »