标题: ORACLE 19C 正常打开PDBSEED [打印本页] 作者: 郑全 时间: 2024-6-30 12:25 标题: 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 ;