B Installing and Configuring Oracle Database Using Response Files

B.1.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.

B.1.2 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:

1. Prepare a response file.

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

3. 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.2.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.

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

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 UNIX for 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.2.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.

To record a response file:

1. Complete preinstallation tasks as for a normal installation.

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

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

4. When the installer displays the Summary screen, perform the following steps:

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

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

      Click Save Response File and 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.

5. 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.5.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 creating and 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=welcome

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.5.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 Grid Infrastructure installation for a cluster

   Oracle Grid Infrastructure requires passwords for Oracle Automatic Storage Management Configuration Assistant (ASMCA). Provide the following response file:

   oracle.assistants.asm|S_ASMPASSWORD=password
   oracle.assistants.asm|S_ASMMONITORPASSWORD=password
   

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

   Oracle Database configuration requires configuring a password for the SYS, SYSTEM, SYSMAN, and DBSNMP passwords for use with Database Configuration Assistant (DBCA). In addition, if you use Oracle ASM storage, then configure the ASMSNMP password. 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
   

4. Change directory to $ORACLE_HOME/cfgtoollogs, and run the configuration script using the following syntax:

   configToolAllCommands RESPONSE_FILE=/path/name.properties

   for example:

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