ORA-65086: cannot open/close the pluggable database

Cause:

PDB is unplugged and hence it cannot be opened

kIsH@Xhydra<>sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
kIsH@Xhydra<>alter pluggable database PDB open;
alter pluggable database PDB open
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database

kIsH@Xhydra<>!oerr ora 65086
65086, 00000, "cannot open/close the pluggable database"
// *Cause:  The pluggable database has been unplugged.
// *Action: The pluggable database can only be dropped.
//

Action:

Drop the PDB , recreate it and then open.

kIsH@Xhydra<>drop pluggable database PDB including datafiles;

Pluggable database dropped.

kIsH@Xhydra<>create pluggable database PDB admin user PDB_ADM identified by password;

Pluggable database created.

kIsH@Xhydra<>alter pluggable database PDB open;

Pluggable database altered.

kIsH@Xhydra<>sho pdbs

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

Leave a Reply