Pluggable Database (PDB) Automatic Startup

 

Pluggable Database (PDB) Automatic Startup

There is no default mechanism to automatically start them when the CDB is started. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.

sqlplus '/ as sysdba'

CREATE OR REPLACE TRIGGER open_pdbs 

    AFTER STARTUP ON DATABASE 

    BEGIN 

    EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN'; 

    END open_pdbs;

/