Oracle Database 18c: Oracle Restart Silent DB Creation

In this short blog, I am going to cover on how to create a database using dbca command line using silent method


export ORACLE_BASE=/u01/app/oracle # Set it as per your environment
export ORACLE_HOME=/u01/app/oracle/product/180/db
export PATH=$ORACLE_HOME/bin:$PATH

Use dbca silent method to create Database



#####
dbca -silent -createDatabase -gdbName ORCL -sid ORCL \
-templateName /opt/oracle/product/180/db/assistants/dbca/templates/General_Purpose.dbc \
-characterSet WE8MSWIN1252 -nationalCharacterSet AL16UTF16 \
-databaseConfigType SI \
-databaseType MULTIPURPOSE \
-asmsnmpPassword Oracle123 -sysPassword Oracle123 -systemPassword Oracle123  \
-redoLogFileSize 300 \
-sampleSchema false -storageType ASM \
-datafileDestination DG_DATA  -archiveLogDest DG_ARCH \
-enableArchive false  \
-automaticMemoryManagement false  \

 -initParams 'undo_retention=900,db_block_size=8K,processes=450,use_large_pages=ONLY,sga_target=2048MB,pga_aggregate_target=512M,db_create_online_log_dest_1=+DG_REDO1,db_create_online_log_dest_2=+DG_REDO2' 

Prepare for db operation

10% complete

Registering database with Oracle Restart

14% complete

Copying database files

43% complete

Creating and starting Oracle instance

45% complete

49% complete

53% complete

56% complete

62% complete

Completing Database Creation

68% complete

70% complete

71% complete

Executing Post Configuration Actions

100% complete

Database creation complete. For details check the logfiles at:

 /u01/app/oracle/base/cfgtoollogs/dbca/ORCL.

Database Information:

Global Database Name:ORCL

System Identifier(SID):ORCL

Look at the log file "/u01/app/oracle/base/cfgtoollogs/dbca/ORCL/ORCL.log" for further details.