I noticed a new “feature” on my managed DBAAS Oracle OCI environments, that whatever I do, my pluggable databases always open in READ WRITE.
After mentioning this to Oracle support, it seems that there is a new Oracle database startup trigger called OPEN_ALL_PDBS. In this trigger the following has been defined in code…
SQL> select dbms_metadata.get_ddl(‘TRIGGER’,’OPEN_ALL_PDBS’,’SYS’) from dual
DBMS_METADATA.GET_DDL(‘TRIGGER’,’OPEN_ALL_PDBS’,’SYS’)
——————————————————————————–
CREATE OR REPLACE NONEDITIONABLE TRIGGER “SYS”.”OPEN_ALL_PDBS”
after startup on database
BEGIN
execute immediate ‘alter pluggable database all open instances=all’;
END OPEN_ALL_PDBS ;
If you want to not disregard your needed pluggable database SAVE STATE (alter pluggable database <PDBs Name> SAVE STATE) then you need to disable this trigger under SYS with the name “OPEN_ALL_PDBS”.
HTH/M.
