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

最新推荐文章于 2024-06-15 18:34:59 发布

转载最新推荐文章于 2024-06-15 18:34:59 发布 · 598 阅读

文章标签：

本文详细介绍了在Oracle数据库中插拔PDB（Pluggable Database）的操作流程，包括PDB执行unplug后的处理步骤，以及如何在cdb（Container Database）中重新使用该PDB。通过实例演示了从drop到重新plug的过程，确保数据库系统的稳定性和高效管理。

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-1064232/