灌溉梦想,记录脚步
« »
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订阅这个日志的所有评论。

13 条评论

  1. vente par correspondance kamagra canada

    acheter kamagra en spain

  2. online order enclomiphene purchase online canada

    cheap enclomiphene cheap united states

  3. purchase androxal generic alternative

    discount androxal uk generic

  4. discounted flexeril cyclobenzaprine prices

    online order flexeril cyclobenzaprine buy online canada

  5. order dutasteride generic discount

    buying dutasteride cost on prescription

  6. cheap gabapentin buy in australia

    cheapest buy gabapentin without prescriptions canada

  7. discount fildena cost new zealand

    online order fildena usa sales

  8. ordering itraconazole cheap online in the uk

    online order itraconazole buy online uk

  9. cheap avodart generic health

    buy cheap avodart purchase england

  10. buy staxyn cheap store

    buy cheap staxyn generic real

  11. buy cheap rifaximin generic side effect

    how to order rifaximin ireland over the counter

  12. purchase xifaxan buy uk no prescription

    buy xifaxan american express canada

  13. koupit kamagra spojené státy

    sleva obecná kamagra

发表回复