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

Use createDatabase command to create an Oracle RAC database using Oracle DBCA.

  1. Use the following command syntax to create an Oracle Real Application Clusters (Oracle RAC) database using the general purpose template and AUTOMATIC management policy, placing the data files in an existing Oracle ASM disk group, configuring a TDE wallet, and defining default encryption algorithm during the database creation. It also configures Oracle Machine Learning for Python in the database and sets the SYS, SYSTEM, and DBSNMP passwords to password, which is the password for each account:
    # su oracle -c "$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc 
    -gdbName $DBNAME -sid $ORACLE_SID -managementPolicy AUTOMATIC -configureTDE true -tdeAlgorithm AES256 -encryptTablespaces ALL -sysPassword password -systemPassword password 
    -tdeWalletPassword password [-tdeWalletLoginType AUTO_LOGIN] -dbsnmpPassword password -emConfiguration LOCAL 
    -storageType ASM -diskGroupName ASMgrp1 -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo node1,node2 -characterset "WE8ISO8859P1" 
    -configureoml4py -oml4pyConfigTablespace SYSAUX -enableOml4pyEmbeddedExecution true

    Note:

    The Oracle Machine Learning for Python feature is supported only on Linux operating systems.

    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.

    See Also:

    Oracle Database Administrator's Guide for a complete description of Oracle Database Configuration Assistant (Oracle DBCA) commands and options