12C-ORA-65086: cannot open/close the pluggable database

ORA-65086: cannot open/close the pluggable database

一旦pdb執行了unplug，然後想在該cdb中重新使用該pdb，不能直接操作，需要先drop，然後重新plug到該cdb中：

SQL>  show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TESTCS1                        READ WRITE NO
         4 PDB_PLUG_NOCOPY                MOUNTED
         5 CRM                            READ WRITE NO
         6 ESSDB                          READ WRITE NO
         8 PDB_PLUG_MOVE                  READ WRITE NO
        
QL> alter PLUGGABLE database   PDB_PLUG_NOCOPY  open;
alter PLUGGABLE database   PDB_PLUG_NOCOPY  open
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database

SQL>  drop pluggable database PDB_PLUG_NOCOPY;

Pluggable database dropped.

SQL>  show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TESTCS1                        READ WRITE NO
         5 CRM                            READ WRITE NO
         6 ESSDB                          READ WRITE NO
         8 PDB_PLUG_MOVE                  READ WRITE NO
        
         然後重新plug後使用。        

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/13750068/viewspace-1064232/，如需轉載，請註明出處，否則將追究法律責任。