重庆思庄Oracle、Redhat认证学习论坛

标题: 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 ;


Pluggable database altered.













欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2