oracle中出現ORA-65085錯誤怎么辦

這篇文章主要介紹了oracle中出現ORA-65085錯誤怎么辦，具有一定借鑒價值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓小編帶著大家一起了解一下。

SQL> show con_name

CON_NAME

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

CDB$ROOT

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

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

2 PDB$SEED  READ ONLY  NO

3 PDB  READ WRITE NO

4 TEST  MOUNTED

SQL> show con_name

CON_NAME

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

CDB$ROOT

SQL> alter pluggable database test open read only;

alter pluggable database test open read only

*

ERROR at line 1:

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

SQL> col pdb_name for a20

SQL> col status for a40

SQL> select pdb_name,status from dba_pdbs;

PDB_NAME     STATUS

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

PDB     NORMAL

PDB$SEED     NORMAL

TEST     NEW

pdb的status有NEW、NORMAL、UNPLUGGED、NEEDS UPGRADE、CONVERTING、UNUSABLE幾種狀態，對這幾種狀態的解釋如下:

NEW - The PDB has never been opened since it was created. It must be opened in READ WRITE mode for Oracle to perform processing needed to complete the integration of the PDB into the CDB and mark it NORMAL. An error will be thrown if an attempt is made to open the PDB read only.

NORMAL - The PDB is ready to be used.

UNPLUGGED - The PDB has been unplugged. The only operation that can be performed on it is DROP PLUGGABLE DATABASE.

NEEDS UPGRADE - A PDB needs to be upgraded to the version of the CDB into which it was plugged.

CONVERTING - A non-CDB was plugged into the CDB and is undergoing conversion required to make it behave like a real PDB.

UNUSABLE - The PDB is being created or an unrecoverable error was encountered during its creation. The PDB cannot be opened while its state is set to UNUSABLE. If the PDB remains in this state because of an error encountered during its creation, it can only be dropped. The alert log can be checked to determine if there was an error 

during PDB creation.

通過上面對status幾種狀態的說明，對屬于NEW的pdb，需要先open。

SQL> alter pluggable database test open;

再對數據庫操作open read only操作：

[oracle@ora12c ~]$ sqlplus sys/oracle@192.168.10.31:1521/test as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 1 09:53:23 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

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

4 TEST  READ WRITE NO

SQL> shutdown immediate;

Pluggable Database closed.

SQL> alter database open read only;

Database altered.

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

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

4 TEST  READ ONLY  NO

感謝你能夠認真閱讀完這篇文章，希望小編分享的“oracle中出現ORA-65085錯誤怎么辦”這篇文章對大家有幫助，同時也希望大家多多支持億速云，關注億速云行業資訊頻道，更多相關知識等著你來學習!