Create RAC database using DBCA silent mode

Real World Scenario: 

Previously, we had a vacancy on Senior DBA position. Some of our candidates had >15 years of experience in database administration.

So for testing their knowlege we created lab. There were already installed grid and database softwares, shared disks were present and diskgroups were already created.

The first task was to create RAC database in silent mode using DBCA.  They had an option to use the internet during the exam. But unfortunatelly they have not managed to do that.

So I decided to write the simple version of the script:

dbca -silent \

-createDatabase \

-templateName General_Purpose.dbc \

-gdbName orcl  \

-sid orcl  \

-SysPassword MyPassword123 \

-SystemPassword MyPassword123 \

-emConfiguration NONE \

-redoLogFileSize 2048  \

-recoveryAreaDestination FRA \

-storageType ASM \

-asmSysPassword MyPassword123 \

-diskGroupName DATA \

-characterSet AL32UTF8 \

-nationalCharacterSet AL32UTF8 \

-automaticMemoryManagement true \

-totalMemory 2536  \

-databaseType MULTIPURPOSE \

-nodelist rac1,rac2

Copying database files
1% complete
3% complete
9% complete
15% complete
21% complete
30% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
44% complete
45% complete
48% complete
50% complete
Creating cluster database views
52% complete
70% complete
Completing Database Creation
73% complete
76% complete
85% complete
94% complete
100% complete
Look at the log file “/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log” for further details.