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
SHOW PDBS
How to Resolve ORA-65011: Pluggable database does not exist
ORA-65011 There're several use cases that may throw ORA-65011. Switch Session Container Tried to set a PDB as the current session container, but it failed… Read More »How to Resolve ORA-65011: Pluggable database does not exist
How Oracle Rename PDB
Rename Pluggable Database After creating a new PDB or cloning a remote PDB, you might want to change its name for your own purpose. In… Read More »How Oracle Rename PDB
How to Add Service to PDB
By default, Container Database (CDB) provides only one service for every Pluggable Database (PDB) for connections, but we can create our own services for various… Read More »How to Add Service to PDB
How to Resolve ORA-01565: error in identifying file
In this post, I'll describe two error patterns for ORA-01565. Missing SPFILE Multitenant DB A. ORA-01565 for Missing SPFILE To create a plain-text parameter file,… Read More »How to Resolve ORA-01565: error in identifying file
Alter Pluggable Database Open Automatically
ALTER PLUGGABLE DATABASE OPEN By default, the pluggable databases (PDB) are at MOUNT state after you startup the container database (CDB). SQL> conn / as… Read More »Alter Pluggable Database Open Automatically
How to Start EM Express for PDB
EM Express for PDB I assumed that you have enabled Enterprise Manager Express (EM Express) before reading this post. During database creation, DBCA enables Enterprise… Read More »How to Start EM Express for PDB
SHOW PARAMETER, How and Why
What is SHOW PARAMETER? SHOW PARAMETER is a SQL*Plus specific command that can show all parameters, types and their values in a simple way. If… Read More »SHOW PARAMETER, How and Why
How to Resolve SP2-0158: unknown SHOW option
SP2-0158 SP2-0158 means that the issued command is not supported by this release of SQL*Plus utility. For example, we use SQL*Plus 11.2.0.4 to connect to… Read More »How to Resolve SP2-0158: unknown SHOW option
How to Resolve SP2-0382: The SHOW PDBS command is not available
SP2-0382 SP2-0382 means that the connected user are not privileged as SYSDBA, so SQL*Plus SHOW PDBS command is not available to the user. SQL> conn… Read More »How to Resolve SP2-0382: The SHOW PDBS command is not available