Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to do ORA-65085 errors in oracle, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

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

The status of pdb has several states of NEW, NORMAL, UNPLUGGED, NEEDS UPGRADE, CONVERTING and UNUSABLE. The explanations for these states are as follows:

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.

Through the above description of several states of status, open is required for pdb that belongs to NEW.

SQL > alter pluggable database test open

Then operate open read only operation on the database:

[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

Thank you for reading this article carefully. I hope the article "what to do if there are ORA-65085 errors in oracle" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.