Trigger AFTER STARTUP ON DATABASE
Trigger AFTER STARTUP ON DATABASE.
Purpose:To start Pluggable databases while starting container Databases if PDBs are in MOUNT state
Trigger name: “SYS”.”OPEN_PDBS”
Script name: OPEN_DB.sql
Purpose:To start Pluggable databases while starting container Databases if PDBs are in MOUNT state
Parameters to be passed: None
Technology: Oracle PL/SQL
sub functions/scripts: None
Code:
DDL of the Trigger
CREATE OR REPLACE NONEDITIONABLE TRIGGER “SYS”.”OPEN_PDBS”
AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE ‘ALTER PLUGGABLE DATABASE ALL OPEN’;
END open_pdbs;
Explanation: To start Pluggable databases while starting container Databases if PDBs are in MOUNT state
How to run manually :
SQL> CREATE OR REPLACE NONEDITIONABLE TRIGGER “SYS”.”OPEN_PDBS”
AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE ‘ALTER PLUGGABLE DATABASE ALL OPEN’;
END open_pdbs; 2 3 4 5
6 /
Trigger created.
SQL> show Errors
No errors.
Verification
SQL> select trigger_name from dba_triggers where trigger_name like ‘%OPEN%’;
OPEN_PDBS