ORA-65085 cannot open pluggable database in read-only mode

在执行将所有pluggable数据库以read only模式打开时，报错ORA-65085 cannot open pluggable database in read-only mode ，如下所示：

SQL> show pdbs

    CON_ID CON_NAME                   OPEN MODE  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                        READ WRITE  NO

         4 ORCLPDB3                       READ WRITE NO

         5 PDB2                           READ WRITE  NO

SQL> alter pluggable database all close;

Pluggable database altered.

SQL> alter pluggable database all open;

Pluggable database altered.