Using Oracle DBCA Commands for Noninteractive (Silent) Configuration of Oracle RAC

A.3 Using Oracle DBCA Commands for Noninteractive (Silent) Configuration of Oracle RAC

You can use Oracle Database Configuration Assistant (DBCA) in non-interactive mode to create an Oracle RAC database.

Example A-1 Using DBCA in Silent Mode to Create an Oracle RAC Database

Use the following command syntax to create an Oracle RAC database using the general purpose template, placing the data files in an existing Oracle ASM disk group, configuring a TDE wallet, and defining default encryption algorithm during the database creation:

%ORACLE_HOME%\bin\dbca -silent -createDatabase -templateName General_Purpose.dbc
-gdbName %DBNAME% -sid %ORACLE_SID% [-policyManaged | -adminManaged |-managementPolicy [AUTOMATIC|RANK]]
-configureTDE true [-tdeAlgorithm AES256] 
-encryptTablespaces ALL:table_spacename:true/false
-encryptPDBTablespaces ALL:table_spacename:true/false
-sysPassword password
-systemPassword password -tdeWalletPassword password [-tdeWalletLoginType AUTO_LOGIN]
-dbsnmpPassword password -serviceUserPassword 
-emConfiguration LOCAL -storageType ASM -diskGroupName +ASMgrp1 
-datafileJarLocation %ORACLE_HOME%\assistants\dbca\templates 
-nodeinfo node1,node2 -characterset WE8MSWIN1252

Nodes node1 and node2 are the cluster nodes on which Oracle RAC database instances are created with a TDE wallet configuration and AES256 as the default encryption algorithm for tablespace creation operations. The disk group name is +ASMgrp1, and password is a placeholder for a password. The passwords can be all the same password or different passwords each time. An Oracle Home User was specified for this installation, and is indicated with the -serviceUserPassword option.

After you run this command, if you did not include the passwords as values in the above command, then DBCA prompts you for the passwords for the SYS, SYSTEM, SYSMAN, DBSNMP, Oracle Home (or Oracle Service) and SYSASM users, for example:

Enter SYS user password:
password
Enter SYSTEM user password:
password
...