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

Next Page