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