MANUAL DATABASE (CDB AND PDB) CREATION VIA SQL*PLUS
A NOT SO STRAIGHTFORWARD APPROACH TO MANUAL DATABASE (CDB AND PDB) CREATION VIA SQL*PLUS While beginning my tinkering with Database 12c, I was curious to create the container database via SQL*Plus. Below are the steps I followed. Set your environment variable for ORACLE_SID . It’s a given that you need ORACLE_HOME set J [oracle@collabn1 dbs]$ ORACLE_SID=beans [oracle@collabn1 dbs]$ export ORACLE_SID Edit your initialization parameter file. It is important to note, for the CREATE DATABASE script to create the SEED database, the ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE . To simplify my creation, I enabled Oracle Managed Filsystem (OMF) by setting db_create_file_dest . [oracle@collabn1 dbs]$ ls -lhtr total 16K -rw-r--r-- 1 oracle oinstall 3.0K Feb 3 2012 init.ora -rw-r----- 1 oracle oinstall 33 Sep 1 16:15 initrac1.ora -rw-r----- 1 oracle oinstall 0 Sep 2 14:05 lkinstslob -rw-rw---- 1 oracle oinstall 1.6K Sep 2 14:05 hc_slob.dat -rw-rw-