Creating a Container Database Using SQL Commands
Let’s us create a container database (CDB) by name ICACDB and one pluggable database ICAPDB1.
We will place all datafiles, logfiles, controlfile of CDB in /u02/oracle/icacdb directory
and place seed database pdbseed database datafiles in ‘/u02/oracle/icacdb/pdbseed’
directory and pluggable database PDB1 files /u02/oracle/icacdb/icapdb1 directory
Step 1: Make directories
$mkdir /u02/oracle/icacdb
$cd /u02/oracle/icacdb
$mkdir icapdb1
$mkdir fast_recovery_area
$mkdir pdbseed
Create directory for storing audit files
$mkdir $ORACLE_BASE/admin/icacdb
$cd $ORACLE_BASE/admin/icacdb
$mkdir adump
Create directory for diagnostic destination
$cd /u02/oracle/icacdb
$mkdir diag
Step 2:- Create Parameter File by copying Template
$cd $ORACLE_HOME/dbs
$cp init.ora initicacdb.ora
Now open the PFile in vi editor and edit the require parameters. After editing it
should look like as shown below
db_name='icacdb'
memory_target=500M
processes = 150
audit_file_dest=/opt/oracle/product/admin/icacdb/adump
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u02/oracle/icacdb/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest=/u02/oracle/icacdb/diag
dispatchers='(PROTOCOL=TCP) (SERVICE=ICACDBXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = '/u02/oracle/icacdb/control01.ora'
compatible ='12.1.0'
enable_pluggable_database=TRUE