Auto Start Oracle PDBs

In Oracle 12c, you need to start all pluggable database manually after the startup of the Container Database. To automate the startup of pluggable databases, we have option to preserve the state of the pluggable database. After this setting, every time when container database would start, pluggable database would be in the state which was preserved. It means that if we preserve the “open” state for any of our pluggable database, we will find it open every time container database is started.

The following commands will open all PDBs when connected to the PDB as a privileged user.

ALTER PLUGGABLE DATABASE ALL OPEN;

Now all pluggable databases are in open state, we will save the state of PDB1 by following;

ALTER PLUGGABLE DATABASE PDB1 SAVE STATE;