How to Add Services 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 Services to PDB
SHOW CON_NAME
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 Start EM Express for PDB
EM Express for PDB During database creation, DBCA enables Enterprise Manager Express (EM Express) for being created CDB, not for PDB globally by default. We… 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?