Pages

Popular Posts

Powered By Blogger

Thursday, December 13, 2018

DBCA silent database creation.

Why we need silent feature of Database creation using DBCA?
  1. To achieve database creation on non graphical environment.
  2. This point is my environment : As you know SAP installation on Windows not support Oracle RAC on Windows ( those who work on SAP project they well known this matter). To achieve first we need to install SAP using single instance and migrate database from single to RAC.
And another main issue is SAP only support UTF-8 database characterset that you don't find in DBCA graphical database creation mode.
Below is the Command to achive silent database creation in non graphical environment:
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName PIB -sid PIB -sysPassword password123 -systemPassword password123 -sysmanPassword password123 -dbsnmpPassword password123 -emConfiguration NONE -storageType ASM -diskGroupName PIBDATA -datafile Destination PIBDATA,ARCH -datafileJarLocation D:\app\PIB\11.2.0.4\assistants\dbca\templates -nodeinfo proudsapdb01,proudsapdb02 -characterset UTF8 -nationalCharacterSet UTF8 -obfuscatedPasswords false -sampleSchema false -asmSysPassword password123 -totalMemory 20480 -redoLogFileSize 250

No comments:

Post a Comment