Oracle Database Creation ( Silent Mode )

=>> At first Goto oracle home location and check the databases available.

#

#su - oracle

$ps -eaf | grep smon

$cat /etc/oratab

$clear

=>> And Now we go for NEW Database Creation Steps.

$.  .bash_profile

$cd $ORACLE_HOME


$ls

$ cd assistants

$ls

$cd dbca/

$ls

$cp dbca.rsp  dbcanew.rsp

$ls



$vi  dbcanew.rsp

#Edit these below parameters only with the below specified values. Remaining should be kept as it is. 
#If  any below specified parameters are kept in Comment Mode, You should uncoomment those parameters.

OPERATION_TYPE = "CreateDatabase"

GDBNAME = "sales"

SID = "sales"

SYSPASSWORD = "sys"

SYSTEMPASSWORD = "sys"

SYSMANPASSWORD = "sys"

DBSNMPPASSWORD = "sys"

CHARACTERSET = "AL32UTF8"

NATIONAL CHARACTERSET = "UTF8"

:wq!

=>> From the same location Execute the below command to create a database.

$dbca  -silent  -createdatabase  -responsefile  dbcanew.rsp

=>> After completing the database creation Goto oracle home location and check the database.

$cd

$ps  -eaf  | grep  smon

$cat  /etc/oratab