Mir Sayeed Hassan – Oracle Blog

Cannot open the Pluggable DB due to ORA-65086: cannot open/close the pluggable database

Check the status of database

SQL> select instance_name, open_mode, version from V$database, v$instance;

INSTANCE_NAME    OPEN_MODE      VERSION
-----------------------------------------
ORA19c          READ WRITE    19.0.0.0.0

Perform the Unplug one of the PDB database.

SQL> alter pluggable database pdb1 close immediate;
Pluggable database altered.

SQL> alter pluggable database pdb1 UNPLUG into '/u01/app/oracle/bkp_pdbs/pdb1.xml';
Pluggable database altered.

Check the status of pluggable database

SQL> show pdbs

CON_ID    CON_NAME     OPEN MODE      RESTRICTED
-------------------------------------------------
2         PDB$SEED    READ ONLY          NO
3         PDB1        MOUNTED

Try to open the pluggable database, but its not opening due to the unplugged operation perform.

SQL> alter pluggable database PDB1 open;
alter pluggable database PDB1 open
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database

Check the status of PDB

SQL> set linesize 300

PDB_NAME        STATUS
-----------------------
PDB$SEED       NORMAL
PDB1           UNPLUGGED

The above status shows the pdb status is unplugged., Therefore we cannot open the unpluggable pdb again.

Note: Once the PDB is unplugged its exist in the CDB with the open mounted state, hence we should drop this pdb & re-create a new pdb if require.

Drop the UNLOUGGED Pluggable database

SQL> drop pluggable database PDB1;
Pluggable database dropped.

Create a New PDB DB

SQL> create pluggable database pdb1 using '/u01/app/oracle/bkp_pdbs/pdb1.xml' nocopy;
Pluggable database created.

SQL> show pdbs;

CON_ID    CON_NAME    OPEN MODE      RESTRICTED
------------------------------------------------
2         PDB$SEED    READ ONLY         NO
3         PDB1        READ WRITE        NO

Open the pluggable datagbase

SQL> alter pluggable database pdb1 open;
Pluggable database altered.

Verify

SQL> show pdbs;

CON_ID    CON_NAME    OPEN MODE      RESTRICTED
---------- -------------------------------------
2        PDB$SEED    READ ONLY        NO
3        PDB1        READ WRITE       NO

=====Hence tested & verified on our test env====