01:23:06 [email protected]> Select name, decode (CDB, ' YES ', ' multitenant Option enabled ', ' Regular 12c Database: ' ) "Multitenant Option", Open_mode, con_id from V$database; NAME multitenant Option open_mode con_id--------------------------------------------------------------------ORCL Regular 12c database:read WRITE 0 visible The database is a traditional database, not CDB below we convert this database to cdb01:27:24 [email protected]> select name From V$datafile; NAME----------------------------------------------------------------------------------------------------------- -----------------------+data/orcl/datafile/system.354.874717421 +data/orcl/datafile/undotbs2.352.874718065 +DATA /orcl/datafile/sysaux.322.874717327 +data/orcl/datafile/undotbs1.326.874717527 +DATA/ORCL/DATAFILE/ kiwi.328.874718845 +data/orcl/datafile/users.329.874717527 6 rows selected. elapsed:00:00:00.01 01:27:33 [email protected]> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. 01:28:46 [Email proTected]> startup restrict Mount exclusive; ORACLE instance started. Total System Global area 2488635392 bytes Fixed size 2291424 bytes Variable Size 721422624 bytes Database buffers 17448304 Bytes Redo buffers 20090880 bytes database mounted.01:29:11 [email protected]> ALTER DATABASE open read only; Database altered. elapsed:00:00:04.42 01:30:28 [email protected]> begin 01:32:27 2 dbms_pdb.describe (PDB_DESCR_FILE = '/u02/ Noncdb/orcl.xml '); 01:32:27 3 END; 01:32:27 4/create Pluggable database ORCL using '/u02/noncdb/orcl.xml ' copy;alter session set CONTAINER=ORCL; In executing this script to convert to P Db@?/rdbms/admin/noncdb_to_pdb.sql
Three nocdb of Oracle 12c learning converted to PDB