ITPub博客

首页 > 数据库 > Oracle > 12C-ORA-65086: cannot open/close the pluggable database

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

原创 Oracle 作者:yyp2009 时间:2013-12-25 10:50:01 0 删除 编辑

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博客 ” ,链接:https://blog.itpub.net/13750068/viewspace-1064232/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-10-17

  • 博文量
    330
  • 访问量
    1094547