Postinstallation Configuration Using Response File Created During Installation

Use response files to configure Oracle software after installation. You can use the same response file created during installation to also complete postinstallation configuration.

Using the Installation Response File for Postinstallation Configuration

Starting with Oracle Database 12c release 2 (12.2), you can use the response file created during installation to also complete postinstallation configuration.

Run the installer with the -executeConfigTools option to configure configuration assistants after installing Oracle Grid Infrastructure or Oracle Database. You can use the response file located at $ORACLE_HOME/install/response/product_timestamp.rsp to obtain the passwords required to run the configuration tools.

Note:

If passwords are not specified in the response file or on the command-line, the installer prompts for the applicable passwords during installation.

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. \\

Example A-1 Response File Passwords for Oracle Grid Infrastructure (grid user)

grid.install.crs.config.ipmi.bmcPassword=password
grid.install.asm.SYSASMPassword=password
grid.install.asm.monitorPassword=password
grid.install.config.emAdminPassword=password

If you do not have a BMC card, or you do not want to enable IPMI, then leave the ipmi.bmcPassword input field blank.

If you do not want to enable Oracle Enterprise Manager for management, then leave the emAdminPassword password field blank.

Example: Response File Passwords for Oracle Grid Infrastructure for a Standalone Server (oracle user)

oracle.install.asm.SYSASMPassword=password
oracle.install.asm.monitorPassword=password
oracle.install.config.emAdminPassword=password

If you do not want to enable Oracle Enterprise Manager for management, then leave the emAdminPassword password field blank.

Example: Response File Passwords for Oracle Database (oracle user)

This example illustrates the passwords to specify for use with the database configuration assistants.

oracle.install.db.config.starterdb.password.SYS=password
oracle.install.db.config.starterdb.password.SYSTEM=password
oracle.install.db.config.starterdb.password.DBSNMP=password
oracle.install.db.config.starterdb.password.PDBADMIN=password
oracle.install.db.config.starterdb.emAdminPassword=password
oracle.install.db.config.asm.ASMSNMPPassword=password

You can also specify oracle.install.db.config.starterdb.password.ALL=password to use the same password for all database users.

The database configuration assistants require the SYS, SYSTEM, and DBSNMP passwords for use with Oracle DBCA. You must specify the following passwords, depending on your system configuration:

  • If the database uses Oracle Automatic Storage Management (Oracle ASM) for storage, then you must specify a password for the ASMSNMPPassword variable. If you are not using Oracle ASM, then leave the value for this password variable blank.
  • If you create a multitenant container database (CDB) with one or more pluggable databases (PDBs), then you must specify a password for the PDBADMIN variable. If you are not using Oracle ASM, then leave the value for this password variable blank.

Running Postinstallation Configuration Using Response File

You can use a response file to complete postinstallation tasks on one or more servers simultaneously.

Complete this procedure to run configuration assistants with the executeConfigTools command and a response file.

  1. Edit the response file and specify the required passwords for your configuration. You can use the response file created during installation, located at $ORACLE_HOME/install/response/product_timestamp.rsp. For example:

    For Oracle Database (oracle user)

    oracle.install.asm.SYSASMPassword=password
    oracle.install.config.emAdminPassword=password

    For Oracle Grid Infrastructure (grid user)

    grid.install.asm.SYSASMPassword=password
    grid.install.config.emAdminPassword=password
  2. Change directory to the Oracle home containing the installation software. For example:

    For Oracle Grid Infrastructure:

    cd Grid_home

    Where, Grid_home is the path to the Oracle Grid Infrastructure home directory /u01/app/19.0.0/grid

    For Oracle Database:

    cd $ORACLE_HOME
  3. Run the configuration script using the following syntax:

    For Oracle Grid Infrastructure:

    $ ./gridSetup.sh -executeConfigTools -responseFile Grid_home/install/response/product_timestamp.rsp

    For Oracle Database:

    $ ./runInstaller -executeConfigTools -responseFile $ORACLE_HOME/install/response/product_timestamp.rsp

    For Oracle Database, you can also run the response file located in the directory $ORACLE_HOME/inventory/response/:

    $ ./runInstaller -executeConfigTools -responseFile $ORACLE_HOME/inventory/response/db_install.rsp

    The postinstallation configuration tool runs the installer in the graphical user interface mode, displaying the progress of the postinstallation configuration. Specify the [-silent] option to run the postinstallation configuration in the silent mode.

    For example, for Oracle Grid Infrastructure:

    $ ./gridSetup.sh -executeConfigTools -responseFile /u01/app/19.0.0/grid/response/grid_2016-01-09_01-03-36PM.rsp [-silent]

    For Oracle Database:

    $ ./runInstaller -executeConfigTools -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/inventory/response/db_2016-01-09_01-03-36PM.rsp [-silent]