Tag Archives: auto start pluggable database

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; 
/