Ora-65085:cannot Open Pluggable Database in read-only mode problem solving

Source: Internet
Author: User

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 the PDB has new, NORMAL, UNPLUGGED, NEEDS UPGRADE, converting, unusable several states, the explanation of these states are as follows:

New-the PDB had never been opened since it was created. It must is opened in READ WRITE mode for Oracle to perform processing needed to complete the integration of the PDB into T He CDB and mark it NORMAL. An error would be thrown if a attempt is made to open the PDB read only.


Normal-the PDB is a ready-to-be used.

Unplugged-the PDB has been UNPLUGGED. The only operation so can be performed on it is DROP pluggable DATABASE.


NEEDS upgrade-a PDB NEEDS to is upgraded to the version of the CDB into which it is plugged.


Converting-a non-cdb were plugged into the CDB and are undergoing conversion required to make it behave like A real PDB.


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


During PDB creation.


The above description of status states, the PDB belonging to the new will need to open first.


sql> alter pluggable database test open;




Again on the database operation open Read Only operation:

[Email protected] ~]$ sqlplus sys/[email protected]:1521/test as Sysdba


Sql*plus:release 12.1.0.2.0 Production on Tue Dec 1 09:53:23 2015


Copyright (c) 1982, 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


This article is from the "unity of Knowledge" blog, please be sure to keep this source http://dovelauren.blog.51cto.com/9876026/1719532

Ora-65085:cannot Open Pluggable database in read-only mode problem resolution

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.