- 31 Aug, 2023
- 0 Comments
- 1 Min Read
Convert Non CDB Database To PDB Database In Oracle 12c
Convert Non CDB Database To PDB Database In Oracle 12c
The procedures for converting an Oracle non-CDB/PDB database to a PDB database are listed below. i.e Plugging a normal 12c non pdb database to a container database.
DB Name :
NON-CDB DB -NAME : – NONCDB
CDB DB NAME : – PRIM
1. Open the non-cdb database in read only mode:
1 2 3 4 | SQL> select name from v$database;SQL> shutdown immediate;SQL> startup open read onlySQL> select name,open_mode from v$database; |
- Check the compatibility of PDB on ( NONCDB)
1 2 3 4 5 6 | BEGINDBMS_PDB.DESCRIBE(pdb_descr_file => '/export/home/oracle/NonCDB.xml');END;/PL/SQL procedure successfully completed. |
- shutdown NON-CDB database ( NONCDB)
1 2 3 4 5 | SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> exit |
Now connect to the container database, where it need to be plugged.
1 2 3 4 5 6 7 8 9 10 | SET SERVEROUTPUT ON;DECLAREcompatible CONSTANT VARCHAR2(3) := CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(pdb_descr_file => '/export/home/oracle/NonCDB.xml')WHEN TRUE THEN 'YES'ELSE 'NO'END;BEGINDBMS_OUTPUT.PUT_LINE(compatible);END;/ |
- Check the violations:
1 | select name,cause,type,message,status from PDB_PLUG_IN_VIOLATIONS where name='NONCDB'; |
- Create pluggable database ( PRIM)
1 | SQL> create pluggable database NONCDB using '/export/home/oracle/NonCDB.xml' NOCOPY tempfile reuse; |
7 . Run the noncdb_to_pdb.sql script
1 2 3 | ALTER SESSION SET CONTAINER=NONCDB;@$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql |
- Open the PDB:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | SQL> ALTER PLUGGABLE DATABASE OPEN;Pluggable database altered.SQL> SELECT name, open_mode FROM v$pdbs;NAME OPEN_MODE-------------------- ----------NONCDB READ WRITE1 row selected.SQL> select name,open_mode from v$pdbs; |