Skip Headers
Oracle® Real Application Clusters Installation Guide
11g Release 2 (11.2) for Linux and UNIX

Part Number E10813-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

B Using Scripts or Response Files to Create Oracle Real Application Clusters Databases

This appendix describes the steps required to create an Oracle Real Application Clusters (Oracle RAC) database using scripts to perform noninteractive installations.

Note:

The scripts generated by DBCA are for reference purposes only. Oracle strongly recommends that you use DBCA to create a database.

See Also:

Oracle Universal Installer and OPatch User's Guide for Windows and UNIX for detailed information about generating scripts

This appendix contains the following topics:

B.1 Using DBCA to generate Installation Scripts for Oracle RAC

To generate scripts to create an Oracle RAC database, create a database using the scripts, and prepare the database for use, complete the following steps:

  1. Start Database Configuration Assistant (DBCA) and select your preferred options to build the Oracle RAC database.

    On the Creation Options page of your DBCA session, deselect Create Database and select Generate Database Creation Scripts before you click Finish. You can accept the default destination directory for the scripts, or browse for a different location. In either case, you should note the path name for use in the next step.

  2. Navigate to the directory where DBCA created the scripts, and review the SQL scripts to ensure that they contain the statements to build a database with the characteristics you require. If they do not, then Oracle recommends that you rerun DBCA to create scripts with the desired configuration rather than editing the scripts yourself.

  3. On each cluster node you identified during your DBCA session, run the script sid.sh, where sid is the SID prefix that you entered on the DBCA Database Name page.

  4. Set the initialization parameter, cluster_database, to the value TRUE in your SPFILE by issuing an ALTER SYSTEM command, or by uncommenting it in your PFILE for each instance.

  5. Configure Oracle Net Services to support your new database and instances as described in Chapter 7, "Understanding the Oracle Real Application Clusters Installed Configuration".

  6. Set the local_listener and remote_listener parameters in your SPFILE by issuing an ALTER SYSTEM command, or by uncommenting it in your PFILE for each instance.

  7. Run SRVCTL to configure and start database and instance applications as described in Oracle Real Application Clusters Administration and Deployment Guide.

    See Also:

    Oracle Universal Installer and OPatch User's Guide for Windows and UNIX for additional information about creating and using scripts to install Oracle software with OUI

B.2 Using DBCA Noninteractive (Silent) Configuration for Oracle RAC

You can perform a noninteractive, or "silent" configuration of Oracle RAC using DBCA. To perform a silent configuration, you must have completed an Oracle Clusterware installation, run the root.sh script from the Oracle Database or Oracle ASM homes, and defined the Oracle home and Oracle ASM home directory environment variables.

The following command syntax creates an Oracle ASM instance and one disk group:

# su oracle -c "$ORA_ASM_HOME/bin/dbca -silent -configureASM -gdbName NO -sid NO -emConfiguration NONE -diskList ASM_Disks -diskGroupName ASM_Group_Name -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo $NODE1,$NODE2 -obfuscatedPasswords false -asmSysPassword My_ASM_password -redundancy ASM_redundancy"

In the preceding syntax example:

The following command syntax creates an Oracle RAC database on an existing Oracle ASM disk group, where the cluster nodes are node1 and node2, and where the disk group name is ASMgrp1, the passwords are my_password, and the ASM SYS password is My_ASM_Password:

# su oracle -c "$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName $DBNAME -sid $SID -sysPassword my_password -systemPassword my_password -sysmanPassword my_password -dbsnmpPassword my_password -emConfiguration LOCAL -storageType ASM -diskGroupName ASMgrp1 -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo node1,node2 -characterset WE8ISO8859P1 -obfuscatedPasswords false -sampleSchema false -asmSysPassword My_ASM_password"

B.3 How Response Files Work

When you start the installer, you can use a response file to automate the installation and configuration of Oracle software, either fully or partially. The installer uses the values contained in the response file to provide answers to some or all installation prompts.

Typically, the installer runs in interactive mode, which means that it prompts you to provide information in graphical user interface (GUI) screens. When you use response files to provide this information, you run the installer from a command prompt using either of the following modes:

You define the settings for a silent or response file installation by entering values for the variables listed in the response file. For example, to specify the Oracle home name, supply the appropriate value for the ORACLE_HOME variable:

ORACLE_HOME="OraDBHome1"

Another way of specifying the response file variable settings is to pass them as command line arguments when you run the installer. For example:

-silent "ORACLE_HOME=OraDBHome1" ...

In this command, directory_path is the path of the database directory on the DVD or the path of the Disk1 directory on the hard drive.

This method is particularly useful if you do not want to embed sensitive information, such as passwords, in the response file. For example:

-silent "s_dlgRBOPassword=binks342" ...

Enclose the variable and its setting in quotes.

See Also:

Oracle Universal Installer and OPatch User's Guide for Windows and UNIX for more information about response files

B.3.1 Reasons for Using Silent Mode or Response File Mode

The following table provides use cases for running the installer in silent mode or response file mode.

Mode Uses
Silent Use silent mode for the following installations:
  • Complete an unattended installation, which you schedule using operating system utilities such as at.

  • Complete several similar installations on multiple systems without user interaction.

  • Install the software on a system that does not have X Window System software installed on it.

The installer displays progress information on the terminal that you used to start it, but it does not display any of the installer screens.

Response file) Use response file mode if you want to complete similar Oracle software installations on more than one system, providing default answers to some, but not all of the installer prompts.

If you do not specify information required for a particular installer screen in the response file, then the installer displays that screen. It suppresses screens for which you have provided all of the required information.


B.3.2 Creating a Database Using Oracle ASM for Database Files

Before you create a database that uses Oracle Automatic Storage Management (Oracle ASM), you must run the root.sh script. For this reason, you cannot create a database using Oracle ASM as the storage option for database files during a silent-mode installation. Instead, you can complete a software-only installation using silent-mode, and then run the Oracle Net Configuration Assistant and Database Configuration Assistant configuration assistants in silent mode after you have completed the software-only installation and you have run the root.sh script.

Note:

This limitation applies only to databases that use Automatic Storage Management as the storage option for database files. You can create a database that uses the file system option during a silent-mode installation.

B.3.3 General Procedure for Using Response Files

The following are the general steps to install and configure Oracle products using the installer in silent or response file mode:

Note:

You must complete all required preinstallation tasks on a system before running the installer in silent or response file mode.
  1. Create the oraInst.loc file if it is not present on the server.

  2. Prepare a response file.

  3. Run the installer in silent or response file mode.

  4. If you completed a software-only installation, then run Net Configuration Assistant and Database Configuration Assistant in silent or response file mode.

These steps are described in the following sections.

B.4 Creating the oraInst.loc File

If you plan to install Oracle products using the installer in silent or suppressed mode, and an oraInst.loc file does not already exists, then you must manually create the oraInst.loc file. This file specifies the location of the Oracle Inventory directory, which is where the installer creates the central inventory of Oracle products installed on the system.

Note:

If Oracle software has been installed previously on the system, then the oraInst.loc file should already exist. If the file does exist, then you do not need to create this file.

To create the oraInst.loc file, follow these steps:

  1. Switch user to root:

    $ su - root
    
  2. Change directory:

    # cd /etc/
    
  3. Use a text editor to create the oraInst.loc file, containing the following lines:

    inventory_loc=$ORACLE_BASE/oraInventory
    inst_group=oinstall
    

    This example assumes that the $ORACLE_BASE environment variable is set to the path of the Oracle base directory, such as /u01/app/oracle.

  4. Set the ownership of the oraInst.loc file to an Oracle software installation owner, and to members of the oraInventory group, and change permissions to 664. For example, if the installation owner is oracle, and the oraInventory group is oinstall, then enter the following commands:

    # chown oracle:oinstall oraInst.loc
    # chmod 664 oraInst.loc
    

B.5 Preparing a Response File

This section describes the following methods to prepare a response file for use during silent mode or response file mode installations:

B.5.1 Editing a Response File Template

Oracle provides response file templates for each product and installation type, and for each configuration tool. These files are located at database/response directory on the installation media.

Note:

If you copied the software to a hard disk, then the response files are located in the directory /Disk1/response.

Table B-1 lists the response files provided with this software:

Table B-1 Response Files for Oracle Database

Response File Description

db_install.rsp

Silent installation of Oracle Database 11g

dbca.rsp

Silent installation of Database Configuration Assistant

netca.rsp

Silent installation of Oracle Net Configuration Assistant


Caution:

When you modify a response file template and save a file for use, the response file may contain plain text passwords. Ownership of the response file should be given to the Oracle software installation owner only, and permissions on the response file should be changed to 600. Oracle strongly recommends that database administrators or other administrators delete or secure response files when they are not in use.

To copy and modify a response file:

  1. Copy the response file from the response file directory to a directory on your system:

    $ cp /directory_path/response/response_file.rsp local_directory
    

    In this example, directory_path is the path to the database directory on the installation media. If you have copied the software to a hard drive, then you can edit the file in the response directory if you prefer.

  2. Open the response file in a text editor:

    $ vi /local_dir/response_file.rsp
    

    Remember that you can specify sensitive information, such as passwords, at the command line rather than within the response file. "How Response Files Work" explains this method.

    See Also:

    Oracle Universal Installer and OPatch User's Guide for Windows and UNIXfor detailed information on creating response files
  3. Follow the instructions in the file to edit it.

    Note:

    The installer or configuration assistant fails if you do not correctly configure the response file.
  4. Change the permissions on the file to 600:

    $ chmod 600 /local_dir/response_file.rsp
    

    Note:

    A fully specified response file for an Oracle Database installation contains the passwords for database administrative accounts and for a user who is a member of the OSDBA group (required for automated backups). Ensure that only the Oracle software owner user can view or modify response files or consider deleting them after the installation succeeds.

B.5.2 Recording a Response File

You can use the installer in interactive mode to record a response file, which you can edit and then use to complete silent mode or response file mode installations. This method is useful for custom or software-only installations.

Starting with Oracle Database 11g Release 2 (11.2), you can save all the installation steps into a response file during installation by clicking Save Response File on the Summary page. You can use the generated response file for a silent installation later.

When you record the response file, you can either complete the installation, or you can exit from the installer on the Summary page, before it starts to copy the software to the system.

If you use record mode during a response file mode installation, then the installer records the variable values that were specified in the original source response file into the new response file.

Note:

You cannot use record mode to create a response file during an installation that uses the Typical installation method.

To record a response file:

  1. Complete preinstallation tasks as for a normal installation.

    When you run the installer to record a response file, it checks the system to verify that it meets the requirements to install the software. For this reason, Oracle recommends that you complete all of the required preinstallation tasks and record the response file while completing an installation.

  2. If you have not installed Oracle software on this system previously, then create the oraInst.loc file, as described in Section B.4, "Creating the oraInst.loc File".

  3. Ensure that the Oracle software owner user (typically oracle) has permissions to create or write to the Oracle home path that you will specify when you run the installer.

  4. On each installation screen, specify the required information.

  5. When the installer displays the Summary screen, perform the following:

    1. Click Save Response File and specify a file name and location to save the values for the response file.

    2. Click Finish to create the response file and continue with the installation.

    3. Click Cancel if you only want to create the response file but not continue with the installation. The installation will stop, but the settings you have entered will be recorded in the response file.

  6. If you do not complete the installation, then delete the Oracle home directory that the installer created using the path you specified in the Specify File Locations screen.

  7. Before you use the saved response file on another system, edit the file and make any required changes.

    Use the instructions in the file as a guide when editing it.

B.6 Running the Installer Using a Response File

Now, you are ready to run Oracle Universal Installer at the command line, specifying the response file you created, to perform the installation. The Oracle Universal Installer executable, runInstaller, provides several options. For help information on the full set of these options, run the runInstaller command with the -help option, for example:

$ directory_path/runInstaller -help

The help information appears in a window after some time.

To run the installer using a response file:

  1. Complete the preinstallation tasks as for a normal installation

  2. Log in as the software installation owner user.

  3. If you are completing a response file mode installation, set the DISPLAY environment variable.

    Note:

    You do not have to set the DISPLAY environment variable if you are completing a silent mode installation.
  4. To start the installer in silent or response file mode, enter a command similar to the following:

    $ /directory_path/runInstaller [-silent] [-noconfig] \
     -responseFile responsefilename
    

    Note:

    Do not specify a relative path to the response file. If you specify a relative path, then the installer fails.

    In this example:

    • directory_path is the path of the database directory on the DVD or the path of the Disk1 directory on the hard drive.

    • -silent indicates that you want to run the installer in silent mode.

    • -noconfig suppresses running the configuration assistants during installation, and a software-only installation is performed instead.

    • responsefilename is the full path and file name of the installation response file that you configured.

    Note:

    For more information about other options for the runInstaller command, enter the following command:
    $ /directory_path/runInstaller -help
    
  5. When the installation completes, log in as the root user and run the root.sh script:

    $ sudo sh
    password:
    # /oracle_home_path/root.sh
    

B.7 Running Net Configuration Assistant Using a Response File

You can run Net Configuration Assistant in silent mode to configure and start an Oracle Net listener on the system, configure naming methods, and configure Oracle Net service names. To run Net Configuration Assistant in silent mode, you must copy and edit a response file template. Oracle provides a response file template named netca.resp in the response directory in the database/response directory on the DVD.

Note:

If you copied the software to a hard disk, then the response file template is located in the database/response directory.

To run Net Configuration Assistant using a response file:

  1. Copy the netca.rsp response file template from the response file directory to a directory on your system:

    $ cp /directory_path/response/netca.rsp local_directory
    

    In this example, directory_path is the path of the database directory on the DVD. If you have copied the software to a hard drive, you can edit the file in the response directory if you prefer.

  2. Open the response file in a text editor:

    $ vi /local_dir/netca.rsp
    
  3. Follow the instructions in the file to edit it.

    Note:

    Net Configuration Assistant fails if you do not correctly configure the response file.
  4. Log in as the Oracle software owner user, and set the ORACLE_HOME environment variable to specify the correct Oracle home directory.

  5. Enter a command similar to the following to run Net Configuration Assistant in silent mode:

    $ $ORACLE_HOME/bin/netca /silent /responsefile /local_dir/netca.rsp
    

    In this command:

    • The /silent option indicates that you want to run Net Configuration Assistant in silent mode.

    • local_dir is the full path of the directory where you copied the netca.rsp response file template.

B.8 Running Configuration Assistants Using Response Files

You can run configuration assistants in response file or silent mode to configure and start Oracle software after it is installed on the system. To run configuration assistants in response file or silent mode, you must copy and edit a response file template.

Note:

If you copied the software to a hard disk, then the response file template is located in the Disk1/response directory.

This section contains the following topics:

B.8.1 About the Database Configuration Assistant in Response File Mode

In the response file mode, Database Configuration Assistant uses values that you specify, in the response file or as command line options, to create a database. As it configures and starts the database, it displays a window that contains status messages and a progress bar. The window that it displays is the same window that is displayed when you choose to create a preconfigured database during an Enterprise Edition or Standard Edition installation.

To run Database Configuration Assistant in response file mode, you must use a graphical display and set the DISPLAY environment variable. Use -progressOnly flag to set the run mode to response file.

Oracle provides a response file template named dbca.rsp in the /Disk1/response directory on the DVD.

B.8.2 Running Database Configuration Assistant in Response File or Silent Mode

To run Database Configuration Assistant in response file or silent mode:

  1. Copy the dbca.rsp response file template from the response file directory to a directory on your system:

    $ cp /directory_path/response/dbca.rsp local_directory
    

    In this example, directory_path is the path of the database directory on the DVD. If you have copied the software to a hard drive, you can edit the file in the response directory if you prefer.

    Note:

    As an alternative to editing the response file template, you can also create a database by specifying all required information as command line options when you run Database Configuration Assistant. For information about the list of options supported, enter the following command:
    $ $ORACLE_HOME/bin/dbca -help
    
  2. Open the response file in a text editor:

    $ vi /local_dir/dbca.rsp
    
  3. Edit the file, following the instructions in the file.

    Note:

    Database Configuration Assistant fails if you do not correctly configure the response file.
  4. Log in as the Oracle software owner user, and set the ORACLE_HOME environment variable to specify the correct Oracle home directory.

  5. If you intend running Database Configuration Assistant in response file mode, set the DISPLAY environment variable.

  6. Use the following command syntax to run Database Configuration Assistant in silent or response file mode using a response file:

    $ORACLE_HOME/bin/dbca {-progressOnly | -silent} -responseFile \
    /local_dir/dbca.rsp 
    

    In this example:

    • The -silent option indicates that you want to run Database Configuration Assistant in silent mode.

    • The -progressOnly option indicates that you want to run Database Configuration Assistant in response file mode.

    • local_dir is the full path of the directory where you copied the dbca.rsp response file template.

B.9 Postinstallation Configuration Using a Response File

Use the following sections to create and run a response file configuration after installing Oracle software.

B.9.1 About the Postinstallation Configuration File

When you run a silent or response file installation, you provide information about your servers in a response file that you otherwise provide manually during a graphical user interface installation. However, the response file does not contain passwords for user accounts that configuration assistants require after software installation is complete. The configuration assistants are started with a script called configToolAllCommands. You can run this script in response file mode by using a password response file. The script uses the passwords to run the configuration tools in succession to complete configuration.

If you keep the password file to use for clone installations, then Oracle strongly recommends that you store it in a secure location. In addition, if you have to stop an installation to fix an error, you can run the configuration assistants using configToolAllCommands and a password response file.

The configToolAllCommands password response file consists of the following syntax options:

  • internal_component_name is the name of the component that the configuration assistant configures

  • variable_name is the name of the configuration file variable

  • value is the desired value to use for configuration.

The command syntax is as follows:

internal_component_name|variable_name=value

For example:

oracle.assistants.asm|S_ASMPASSWORD=myPassWord

Oracle strongly recommends that you maintain security with a password response file:

  • Permissions on the response file should be set to 600.

  • The owner of the response file should be the installation owner user, with the group set to the central inventory (oraInventory) group.

B.9.2 Running Postinstallation Configuration Using a Response File

To run configuration assistants with the configToolAllCommands script:

  1. Create a response file using the syntax filename.properties. For example:

    $ touch cfgrsp.properties
    
  2. Open the file with a text editor, and cut and paste the password template, modifying as needed.

    Example B-1 Password response file for Oracle Real Application Clusters

    Oracle Database configuration requires the SYS, SYSTEM, SYSMAN, and DBSNMP passwords for use with Database Configuration Assistant (DBCA). The S_ASMSNMPPASSWORD response is necessary only if the database is using Oracle ASM for storage. Also, if you selected to configure Oracle Enterprise Manager, then you must provide the password for the Oracle software installation owner for the S_HOSTUSERPASSWORD response.

    oracle.assistants.server|S_SYSPASSWORD=password
    oracle.assistants.server|S_SYSTEMPASSWORD=password
    oracle.assistants.server|S_SYSMANPASSWORD=password
    oracle.assistants.server|S_DBSNMPPASSWORD=password
    oracle.assistants.server|S_HOSTUSERPASSWORD=password
    oracle.assistants.server|S_ASMSNMPPASSWORD=password
    

    If you do not want to enable Oracle Enterprise Manager or Oracle ASM, then leave those password fields blank

  3. Change permissions to secure the file. For example:

    $ ls -al cfgrsp.properties
    -rw------- 1 oracle oinstall 0 Apr 30 17:30 cfgrsp.properties
    
  4. Change directory to $ORACLE_BASE/cfgtoollogs

    Run the configuration script using the following syntax:

    configToolAllCommands RESPONSE_FILE=/path/name.properties

    for example:

    $ ./configToolAllCommands RESPONSE_FILE=/home/oracle/cfgrsp.properties