How to Switch Service Name to Another PDB
In this case, we have two PDBs in a container and a general service name needs to be be switched between them back and forth.… Read More »How to Switch Service Name to Another PDB
Container Database (CDB)
How Oracle Enable PDB Restricted Mode
We can enable the restricted mode of a PDB either in CDB or PDB. In CDB Enabling the restricted mode of a PDB in the… Read More »How Oracle Enable PDB Restricted Mode
How to Resolve ORA-65011: Pluggable database does not exist
ORA-65011 Tried to open a pluggable database (PDB), but it failed with ORA-65011. SQL> alter pluggable database ORCLPDB1 open; alter pluggable database ORCLPDB1 open *… Read More »How to Resolve ORA-65011: Pluggable database does not exist
How Oracle Rename a Pluggable Database
Rename PDB After creating a new PDB or cloning a remote PDB, you might want to change its name for your own purpose. In this… Read More »How Oracle Rename a Pluggable Database
How to Backup PDB Tablespace
Backup Tablespace Normally Since tablespace is a logical set of data files, it's allowable to have same name tablespaces in different pluggable databases (PDB). Therefore,… Read More »How to Backup PDB Tablespace
How to Connect a PDB Directly by OS Authentication
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 Connect a PDB Directly by OS Authentication
How to expdp PDB as SYSDBA without Password
Expdp PDB as SYSDBA If we want to export data from a Pluggable Database (PDB) using expdp as sysdba by OS Authentication, we will get… Read More »How to expdp PDB as SYSDBA without Password
How to Resolve EM Express XDB Dialog
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 EM Express XDB Dialog
How to Resolve ORA-15173 Error Message
ORA-15173: entry 'pdbseed' does not exist in directory There're two operations that you might see ORA-15173. Creating a Multitenant Database Creating a Pluggable Database ORA-15173… Read More »How to Resolve ORA-15173 Error Message
How to Build 19c RAC - 4 of 4 - Creating a RAC Database
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 Build 19c RAC - 4 of 4 - Creating a RAC Database