灌溉梦想，记录脚步
« »
2013年9月12日技术合集

ORA-65086: cannot open/close the pluggable database

在Oracle 12C中执行卸载命令后，如果执行PDB的OPEN操作，将会提示错误，如下：

1
2
3
4
5
6
7
8

SQL> alter pluggable database pdb01 unplug into '/opt/oracle/pdb01.xml';
 
Pluggable database altered.
 
SQL> ALTER PLUGGABLE DATABASE pdb01 OPEN;
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database


处理办法是先drop掉，然后插入此PDB。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

SQL> drop pluggable database pdb01;
 
Pluggable database dropped.
 
SQL> show pdbs;
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
SQL> create pluggable database pdb01 using '/opt/oracle/pdb01.xml' nocopy;
 
Pluggable database created.
 
SQL> show pdbs
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB01                          MOUNTED
SQL> alter pluggable database pdb01 open;
 
Pluggable database altered.

日志信息 »

该日志于2013-09-12 15:09由 kevin 发表在技术合集分类下， 你可以发表评论。除了可以将这个日志以保留源地址及作者的情况下引用到你的网站或博客，还可以通过RSS 2.0订阅这个日志的所有评论。

发表回复