Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-65054: Cannot open a pluggable database in the desired mode.

Kam__apexMar 20 2020 — edited Mar 29 2020

Dear Freinds

Please check below red highlighted error and help, how to resolve this issue? Thanks in advance. Its Oracle18c.

SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 2550136816 bytes

Fixed Size                  9031664 bytes

Variable Size             822083584 bytes

Database Buffers         1711276032 bytes

Redo Buffers                7745536 bytes

Database mounted.

SQL> SHOW PDBS

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       MOUNTED

         3 ORCLPDB                        MOUNTED

SQL> alter session set container = ORCLPDB;

Session altered.

SQL> ALTER DATABASE OPEN READ WRITE;

ALTER DATABASE OPEN READ WRITE

*

ERROR at line 1:

ORA-65054: Cannot open a pluggable database in the desired mode.

Regards

Kam

Comments
Post Details
Added on Mar 20 2020
10 comments
7,443 views