创建触发器启动pdb

 

1.登陆cdb

sqlplus /nolog

connect / as sysdba

2.创建启动某个pdb的触发器
create or replace trigger open_pdbs
after startup on database
begin
execute immediate 'alter pluggable database ora12cpdb1 open';
end open_pdbs;

3.创建启动所有的pdb
create or replace trigger open_all_pdbs
after startup on database
begin
execute immediate 'alter pluggable database all open';
end open_all_pdbs;