Tuesday, August 20, 2013

Silent database creation


Here are the steps to do it.
1. Keep the attached file dev001.dbt in $ORACLE_HOME/assistants/dbca/templates

2. Execute the following commands
a) $ export ORACLE_SID=<database name that you want to create>
b) $ cd $ORACLE_HOME/assistants/dbca/templates
c) $ sed s/dev001/$ORACLE_SID/g dev001.dbt > $ORACLE_SID.dbt
d) $ dbca -silent -createDatabase -templateName $ORACLE_SID -gdbName $ORACLE_SID -sid $ORACLE_SID -emConfiguration NONE

All the CRD files will be stored in /u01 location by default. you can modify the attached resposnse file as per your requirement.

Attached file:

Copy this lines to a notepad and save it with the name dev001.dbt