Friday, January 31, 2014

Create New Database Using DBCA With Silent Option

Create New Database Using DBCA With Silent Option


Below are the steps for how to create Database Manual.

  • Make sure you have no existing database entry in /etc/oratab file for the SID you intend to create
  • Make sure you have no initSID.ora under the $ORACLE_HOME/dbs
  • Construct the dbca command line:
  • Make sure you have no existing Listener & TNS entries.
  • Make to be created all the directory structure as required.


dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbName TEST \
-sid TEST \
-sysPassword cloud12c@ \
-systemPassword cloud12c@ \
-emConfiguration NONE \
-datafileDestination E:\app\praveen\oradata \
-recoveryAreaDestination E:\app\praveen\flash_recovery_area \
-storageType FS \
-characterSet AL32UTF8 \
-nationalCharacterSet UTF8 \
-registerWithDirService false \
-listeners LISTENER_1521;


No comments: