Oracle 12c : Startup and Shutdown CDB & PDB step by step

The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB).

Starting the container database:-



Starting the CDB is same as it has always been for regular instances.

STARTUP;















Normal startup command will start only the cdb and seed database.but still if you look pdb it will be in mounted mode.

Starting the pluggable database:-

ALTER PLUGGABLE DATABASE PDB_ORCL OPEN;







 starting the one or more pdb .

ALTER PLUGGABLE DATABASE OPEN ALL;

Shutdown PDB:-

ALTER PLUGGABLE DATABASE PDB_ORCL CLOSE;




ALTER PLUGGABLE DATABASE CLOSE ALL;

Shutdown CDB:-

Shutdown  the CDB is same as it has always been for regular instances.

SHUT IMMEDIATE;



Comment me if you find this post is useful also let me know if you need any new topics.