12c Non-CDB to Container PDB with NOCOPY Option

12c NON-CDB to Container PDB

 

Steps for Non-CDB:

EBTUSPRD@EBTUSPRD> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

EBTUSPRD@EBTUSPRD> startup mount

ORACLE instance started.

Total System Global Area 3355443200 bytes

Fixed Size                  8626240 bytes

Variable Size            1040191424 bytes

Database Buffers         2164260864 bytes

Redo Buffers              142364672 bytes

Database mounted.

EBTUSPRD@EBTUSPRD> alter database open read only;

Database altered.

Create XML file:

BEGIN

  DBMS_PDB.DESCRIBE(

    pdb_descr_file => '/home/oracle/EBTUSPRDC.xml');

END;

/

PL/SQL procedure successfully completed.

Shutdown NON-CDB:

EBTUSPRD@EBTUSPRD> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

Steps for Container Database:

SET SERVEROUTPUT ON

DECLARE

  compatible CONSTANT VARCHAR2(3) :=

      CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(

            pdb_descr_file => '/home/oracle/EBTUSPRDC.xml',

            pdb_name       => 'EBTUSPRDPDB1')

     WHEN TRUE THEN 'YES'

     ELSE 'NO'

 END;

 BEGIN

  DBMS_OUTPUT.PUT_LINE(compatible);

END;

/

YES => Result is yes

PL/SQL procedure successfully completed.

Create Pluggable Database:

  

CDB$ROOT@EBTUPRDC> CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse;

Pluggable database created.

Elapsed: 00:00:14.78

PDB Status:

CDB$ROOT@EBTUPRDC> select CON_ID, NAME, OPEN_MODE from V$PDBS;

    CON_ID NAME            OPEN_MODE

---------- --------------- ----------

         2 PDB$SEED        READ ONLY

         3 EBTUSPRDPDB1    MOUNTED

         4 EBTUPRDPDB1     READ WRITE

CDB$ROOT@EBTUPRDC> select  PDB_NAME, DBID , CON_ID, STATUS  from CDB_PDBS;

PDB_NAME              DBID     CON_ID STATUS

--------------- ---------- ---------- ----------

PDB$SEED         622332972          2 NORMAL

EBTUPRDPDB1     3965673099          4 NORMAL

EBTUSPRDPDB1    2894495381          3 NEW

Run noncdb_to_pdb.sql:

CDB$ROOT@EBTUPRDC> ALTER SESSION SET CONTAINER =EBTUSPRDPDB1;

Session altered.

Elapsed: 00:00:00.08

CDB$ROOT@EBTUPRDC> show con_name

CON_NAME

------------------------------

EBTUSPRDPDB1

@?/rdbms/admin/noncdb_to_pdb.sql => this step ran more than 15 Mins.(It may take time to compile invalids)

CDB$ROOT@EBTUPRDC> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 EBTUSPRDPDB1                   MOUNTED

Open PDB:

CDB$ROOT@EBTUPRDC> ALTER PLUGGABLE DATABASE OPEN;

Pluggable database altered.

Elapsed: 00:00:09.49

CDB$ROOT@EBTUPRDC> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 EBTUSPRDPDB1                   READ WRITE NO

CDB$ROOT@EBTUPRDC>

conn /as sysdba

CDB$ROOT@EBTUPRDC> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 EBTUSPRDPDB1                   READ WRITE NO

         4 EBTUPRDPDB1                    READ WRITE NO