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错误怎么办"这篇文章对大家有帮助，同时也希望大家多多支持，关注行业资讯频道，更多相关知识等着你来学习!
