ORACLE 19C 正常打开PDBSEED

郑全

我们知道，直接打开PDBSEED，会报错：ORA-65017: seed pluggable database may not be dropped or altered



SYS@DEVCDB>  alter pluggable database pdb$seed close force;
alter pluggable database pdb$seed close force
                          *
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered

SYS@DEVCDB> alter pluggable database pdb$seed open read write force;
alter pluggable database pdb$seed open read write force
                         *
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered

要修改PDBSEED，需要修改一个参数：_oracle_script

SYS@DEVCDB> alter session set "_oracle_script"=true;


Session altered.


SYS@DEVCDB> alter pluggable database pdb$seed close;


Pluggable database altered.


SYS@DEVCDB> alter pluggable database pdb$seed open read write ;


Pluggable database altered.