Oracle 12c response file example

So all my Oracle software installations are done by using response files. I already wrote a blog post about the response file format for Oracle 11gR2 and put my Oracle installation scripts on GitHub.

In this article, I want to show a few response file examples for Oracle 12c (specifically, 12.1). These files were copied and modified from an Oracle Database 12.1 installation archive. You can find more information on response files in the Oracle documentation.

Using these response files

First of all, Oracle has great documentation on the topic: Installing and Configuring Oracle Database Using Response Files.

Basically, you can run both the Oracle Universal Installer (OUI) and the Net Configuration Assistant (NETCA) with response files, for which I provide the response files here. There is also the possibility to run the Database Configuration Assistant (DBCA) with a response file, but I have never tested that. Here is how you run the OUI and the NETCA using response files:

  • Running Oracle Universal Installer Using a Response File
    $ ./runInstaller -silent -waitForCompletion -responseFile grid_install.rsp
  • Running Net Configuration Assistant Using a Response File
    $ $ORACLE_HOME/bin/netca -silent -responseFile netca.rsp

So for a basic unattended installation of a new Oracle 12c database, I usually run these steps:

  1. Run OUI with grid_install.rsp. This will install the Grid Infrastructure software.
  2. Run OUI with db_install.rsp. This will install the Database Software. Note that this will NOT create a database. To do that, you’ll need to use another script (I usually go with my own installation scripts here).
  3. Run NETCA with netca.rsp to configure a listener service.

So in the following sections you’ll find examples of response files I have used to install a database.

Grid Infrastructure (grid_install.rsp)

oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v12.1.0
ORACLE_HOSTNAME=pandora.krenger.ch
INVENTORY_LOCATION=/etc/oraInventory
SELECTED_LANGUAGES=en
oracle.install.option=CRS_SWONLY
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/grid/product/12.1.0/grid_1
oracle.install.asm.OSDBA=oinstall
oracle.install.asm.OSOPER=asmoper
oracle.install.asm.OSASM=asmadmin
oracle.installer.autoupdates.option=SKIP_UPDATES

Database Software Only (db_install.rsp)

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=pandora.krenger.ch
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/etc/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle
ORACLE_BASE=/u01/app/oracle/product/12.1.0/db_1
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.BACKUPDBA_GROUP=bckpdba
oracle.install.db.DGDBA_GROUP=dgdba
oracle.install.db.KMDBA_GROUP=kmdba
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES

Net Configuration Assistant (netca.rsp)

[GENERAL]
RESPONSEFILE_VERSION="12.1"
CREATE_TYPE="CUSTOM"
SHOW_GUI=false

[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE="typical"
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START="LISTENER"
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"} 

Postinstallation

There are some post-installation tasks involved (usually executing the root.sh scripts), please refer to the documentation for more information.

Hello world

My name is Simon Krenger, I am a Technical Account Manager (TAM) at Red Hat. I advise our customers in using Kubernetes, Containers, Linux and Open Source.

Elsewhere

  1. GitHub
  2. LinkedIn
  3. GitLab