Shulou(Shulou.com)06/01 Report--

By default, when CDB is started, all PDBs are in mount state, and there is no default mechanism. PDB is automatically started when CDB is started.

Here we do this by way of triggers.

CREATE OR REPLACE TRIGGER open_pdbsAFTER STARTUP ON DATABASEBEGINEXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';END open_pdbs;/

The procedure is as follows:

SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1560281088 bytesFixed Size 2924784 bytesVariable Size 956305168 bytesDatabase Buffers 587202560 bytesRedo Buffers 13848576 bytesDatabase mounted.Database opened.SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 MOUNTEDSQL> CREATE OR REPLACE TRIGGER open_pdbs 2 AFTER STARTUP ON DATABASE 3 BEGIN 4 EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN'; 5 END open_pdbs; 6 /Trigger created.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1560281088 bytesFixed Size 2924784 bytesVariable Size 956305168 bytesDatabase Buffers 587202560 bytesRedo Buffers 13848576 bytesDatabase mounted.Database opened.SQL> show con_nameCON_NAME------------------------------CDB$ROOTSQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NOSQL>

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.