Automatically start pluggable databases on container start

With Oracle Database 12c the new feature regarding pluggable databases was introduced. But when you start the database the usual way (sqlplus / as sysdba and then startup) this only starts the container database. You will have to manually start the pluggable databases using:

alter pluggable database [PDB_NAME] open;

If you want all or a specific pluggable database to be started when the container database starts, you will have to create a trigger on the container database like the one below:

create or replace trigger SYS.AFTER_STARTUP after startup on database 
begin 
  execute immediate 'alter pluggable database all open'; 
end; 
/

Leave a Reply

Your email address will not be published. Required fields are marked *