How to convert a normal database to Container enabled database?

@ : Home > > Interview Room

1) Upgrade and set comptabile = 12.0.0 
2) Open the database in readonly mode
3) Execute the dbms_pdb package describe procedure
BEGIN 
DBMS_PDB.DESCRIBE( pdb_descr_file => ‘/disk1/oracle/ncdb.xml’);
END; /

4) Shutdown the non-cdb database
5) If in same server your CDB database contains
CREATE PLUGGABLE DATABASE ncdb USING ‘/disk1/oracle/ncdb.xml’
COPY FILE_NAME_C ‘/disk2/oracle/ncdb/’);

6) Execute the script 
@$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql
7) Open the read write mode new PDB

Alert me