ORA-65086: cannot open/close the pluggable database

solution:

— Unplug a pluggable database

SQL> ALTER PLUGGABLE DATABASE VELDB close immediate;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE VELDB UNPLUG INTO ‘/u01/DB/bkp_pdb/VELDB.xml’;

Pluggable database altered.

Now you can see the status of pdbs.

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 VELDB MOUNTED
SQL>

Here, I am trying to open the same database. But it is not opening due to unplugged.

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

solution:

It is not possible to open again the pluggable database.

After a PDB is unplugged, it remains in the CDB with an open mode of MOUNTED and a status of UNPLUGGED.

You must drop the PDB before you can plug it into the same CDB or another CDB.

SQL> drop pluggable database VELDB;

Pluggable database dropped.

SQL> CREATE pluggable DATABASE VELDB USING ‘/u01/DB/bkp_pdb/VELDB.xml’ NOCOPY;

Pluggable database created.

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 VELDB MOUNTED
SQL> alter pluggable database VELDB open;

Pluggable database altered.

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 VELDB READ WRITE NO
SQL>