ORA-65086: cannot open/close the pluggable database

During cloning activity we unplugged a pdb and then try to open it but we faced “ORA-65086: cannot open/close the pluggable database  ” error.

Unplug a pluggable database
SQL> ALTER PLUGGABLE DATABASE hrpdb close
immediate;
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE hrpdb UNPLUG INTO
‘/u10/EXAM/bkp_pdb/hrpdb.xml’;
Pluggable database altered.

Now you can see the status of pdbs.
SQL> show pdbs;
    CON_ID
CON_NAME                       OPEN MODE  RESTRICTED
———- ——————————
———- ———-
         2
PDB$SEED                       READ
ONLY  NO
         3
PDB1                           READ WRITE
NO
         4
SALESPDB                       READ WRITE
NO
         5
PDB2                           READ WRITE
NO
         6
HRPDB                          MOUNTED
SQL>

Here, I am trying to open the same database. But it is not opening due to unplugged.
SQL> alter pluggable database hrpdb open;
alter pluggable database hrpdb open
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable
database
SQL>
It is not possible to open again the pluggable
database… The official documentation claims:
After a PDB is unplugged, it remains in the CDB
with an open mode of MOUNTED and a status of UNPLUGGED. The only operation you
can perform on an unplugged PDB is DROP PLUGGABLE DATABASE, which will remove
it from the CDB. You must drop the PDB before you can plug it into the same CDB
or another CDB.
So, following official documentation
recommendations:
SQL> drop pluggable database hrpdb;
Pluggable database dropped.
SQL> CREATE pluggable DATABASE hrpdb USING
‘/u10/EXAM/bkp_pdb/hrpdb.xml’ NOCOPY;
Pluggable database created.
SQL> show pdbs;
    CON_ID
CON_NAME                       OPEN
MODE  RESTRICTED
———- ——————————
———- ———-
         2
PDB$SEED                       READ
ONLY  NO
         3
PDB1                           READ WRITE NO
         4
SALESPDB                       READ WRITE
NO
         5
PDB2                           READ WRITE
NO
         6
HRPDB                          MOUNTED
SQL> alter pluggable database hrpdb open;
Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
———- —————————— ———- ———-
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 SALESPDB                       READ WRITE NO
         5 PDB2                           READ WRITE NO
         6 HRPDB                          READ WRITE NO
SQL>
  • October 3, 2018 | 32 views
  • Comments