pdb及pdb service自动启动

alter session set container=BZUAT;
exec dbms_service.start_service('ebs_BZUAT');

alter session set container=CDB$ROOT;
alter pluggable database all open;
alter pluggable database all save state;

sqlplus / as sysdba
CREATE OR REPLACE TRIGGER open_all_pdbs
   AFTER STARTUP
   ON DATABASE
BEGIN
   EXECUTE IMMEDIATE 'alter pluggable database all open';
END open_all_pdbs;
/

sqlplus / as sysdba
alter session set container=BZUAT;
CREATE OR REPLACE TRIGGER pdb_after_startup_trg
AFTER STARTUP ON PLUGGABLE DATABASE
BEGIN
  dbms_service.start_service('ebs_BZUAT');
  NULL;
END;
/
然后每次重启的时候，可以自动启动service