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
SHOW CON_NAME
Connect to PDB as SYSDBA by ORACLE_PDB_SID
Connect as SYSDBA We usually connect to the database by / as SYSDBA without providing any password for maintenance works, such as startup, shutdown and… Read More »Connect to PDB as SYSDBA by ORACLE_PDB_SID
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
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
Which Container Am I Using? Where Am I?
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 »Which Container Am I Using? Where Am I?