Database 12c: Create Container Database


To create a CDB there are two methods to do so:

  1. Create CDB with DBCA
  2. Create CDB manually

1. Create CDB with DBCA

To create a CDB with DBCA , there is nothing special to do. If you install in Basic Mode, you are able to configure CDB on the start site:

createcdb1

If you are installing in Advanced Mode you are able on the second site:

createcdb2

2. Create CDB manually or with “CREATE DATABASE”

1. Setup init file with the according parameters. In my example I used the OFM creation method:

*.db_create_file_dest='/opt/oracle/app/oradata'
*.enable_pluggable_database=TRUE

2. Execute the “CREATE DATABASE” statement with the “ENABLE PLUGGABLE DATABASE”:

CREATE DATABASE db12ee2
USER SYS IDENTIFIED BY welcome1
USER SYSTEM IDENTIFIED BY welcome1
EXTENT MANAGEMENT LOCAL
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
   SEED
   SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
   SYSAUX DATAFILES SIZE 100M;

3. Execute catcdb.sql

@?/rdbms/admin/catcdb.sql

This step is a problem right now, because the required file catcdb.sql is not shipped with the installation. The problem is already in progress:
Bug 17033183 – $OH/rdbms/admin/catcdb.sql is missing from 12c release (Doc ID 17033183.8)