Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, July 22, 2014

Create Oracle RAC 11gR2 database using dbca silent file


How to create a 11g RAC database using dbca silent response file.

dbca -progress_only -responseFile “/home/shaiksameer/dbca_testdb.rsp”

vi dbca_testdb.rsp
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = "TESTDB"
SID = "TESTDB"
NODELIST=machine1,machine2,machine3,machine4
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "syspass12"
SYSTEMPASSWORD = "systempass12"
STORAGETYPE=ASM
DISKGROUPNAME=DATA
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16
SAMPLESCHEMA=FALSE
MEMORYPERCENTAGE = "10"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "TRUE"

or you can pass the variable values directly.

dbca -silent -nodelist machine1,machine2,machine3,machine4 
 -createDatabase -templateName General_Purpose.dbc 
 -gdbName TESTDB 
 -sid TESTDB 
 -SysPassword syspass12
 -SystemPassword systempass12 
-emConfiguration NONE 
-characterSet WE8ISO8859P15
 -totalMemory 500

No comments: