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

标题: ORA-65085：cannot open pluggable database in read-only mode [打印本页]

作者: denglj 时间: 2021-11-29 00:06
标题: ORA-65085：cannot open pluggable database in read-only mode

在执行将所有pluggable数据库以read only模式打开时，

报错ORA-65085 cannot openpluggable database in read-only mode，如下所示：

SQL> show pdbs

CON_ID CON_NAME OPENMODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 ORCLPDB MOUNTED

4 ORCLPDB3 MOUNTED

5 PDB2 MOUNTED

SQL> alter pluggable database all openread only;

alter pluggable database all open read only

ERROR at line 1:

ORA-65085: cannot open pluggable databasein read-only mode

异常原因：创建好ORCLPDB、ORCLPDB3、PDB2之后，需要将这些pluggable数据库打开一次，才能实现all open read only.

解决方案：

SQL> alter pluggable database ORCLPDB3open; #依次将ORCLPDB、PDB2都打开

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ---------------------------------------- ----------

2 PDB$SEED READ ONLY NO

3 ORCLPDB READWRITE NO

4 ORCLPDB3 READ WRITE NO

5 PDB2 READWRITE NO

SQL> alter pluggable database all close;

Pluggable database altered.

SQL> alter pluggable database all open;

Pluggable database altered.

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