Oracle Class – Wissem's Oracle and NOSQL Tips – Tunisia's First Oracle, NOSQL Website

Download the response file: grid-rsp.txt
Introduction:

These last months, I have installed many Oracle RAC environments. This is good thing, but using the OUI installer prevents me to do other tasks in parallel since I have to enter values, go manually from one installer screen to another. To make the installation process easier, fast and avoid mistakes I adopted the silent installation solution. I have searched on the net and unfortunately I didn’t found any detailed available and free article to follow.

In this post, I am going to show you how to install the Oracle clusterware 11.2.0.2 on 7 nodes using the silent method.

Installation Steps:

Before running the runInstaller you have to check for storage, network, system parameters, etc…
You can follow the manual available on:
http://download.oracle.com/docs/cd/E11882_01/install.112/e22489/toc.htm
http://download.oracle.com/docs/cd/E11882_01/install.112/e24660/toc.htm

I am using Redhat Linux 5 as the base operating system. I am also using the role separation; Oracle user for RAC database owner and grid user as the Oracle grid clusterware owner.

Run the Cluster verify utility:

As the grid user:

./runcluvfy.sh stage -pre crsinst -n srvdb01,srvdb02,srvdb03,srvdb04,srvdb05,srvdb06,srvdb07 –verbose

The output should be ok.

Now, as a grid user and from node 1, install grid infrastructure: I have attached to this post the response file I have used for the silent installation.

bash-3.2$ ./runInstaller -silent -responseFile /opt/11gr2Src/grid/grid.rsp

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 808 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 16351 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-10-07_12-51-30AM. Please wait ...
-bash-3.2$ [WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.

   CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].

   ACTION: Provide a password that conforms to the Oracle recommended standards.

[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.

   CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].

   ACTION: Provide a password that conforms to the Oracle recommended standards.

[WARNING] [INS-32016] The selected Oracle home contains directories or files.

   CAUSE: The selected Oracle home contained directories or files.

   ACTION: To start with an empty Oracle home, either remove its contents or choose another location.

[WARNING] [INS-13014] Target environment do not meet some optional requirements.

   CAUSE: Some of the optional prerequisites are not met. See logs for details. /opt/app/oraInventory/logs/installActions2011-10-07_12-51-30AM.log

   ACTION: Identify the list of failed prerequisite checks from the log: /opt/app/oraInventory/logs/installActions2011-10-07_12-51-30AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.

You can find the log of this install session at:

 /opt/app/oraInventory/logs/installActions2011-10-07_12-51-30AM.log

As a root user, execute the following script(s):

        1. /opt/11.2.0/grid/root.sh

As install user, execute the following script to complete the configuration.

        1. /opt/11.2.0/grid/cfgtoollogs/configToolAllCommands

        Note:

        1. This script should be run in the same environment from where the installer has been run.

        2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).

Successfully Setup Software.

-bash-3.2$

run root.sh on all nodes. one by one starting by 1,2,3,4,5,6,7; all should return positive result.

[root@srvdb01 logs]# /opt/11.2.0/grid/root.sh

Check /opt/11.2.0/grid/install/root_srvdb01_2011-10-07_01-44-46.log for the output of root script

[root@srvdb01 logs]#

Once finish the root.sh at node 7. Check:

$GRID_HOME/bin/crsctl stat res –t
$GRID_HOME/bin/crsctl stat res -t -init
$GRID_HOME/bin/crsctl check cluster -all

–> all should return positive results, all resources shoud be ONLINE except the gsd resources.

There is NO need to run /opt/11.2.0/grid/cfgtoollogs/configToolAllCommands on ALL nodes, You just need to execute it on node1, where the OUI started.

After running root.sh on all nodes, back to node1, as grid user, follow these steps:

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.

As per oracle documentation; http://download.oracle.com/docs/cd/E11882_01/install.112/e24660/scripts.htm, section Example B-1 Password response file for Oracle Real Application Clusters

[root@srvdb01 patch3]# cat /opt/11.2.0/grid/cfgtoollogs/cfgrsp.properties
oracle.assistants.server|S_SYSPASSWORD=wissempwd
oracle.assistants.server|S_SYSTEMPASSWORD=wissempwd
oracle.assistants.server|S_SYSMANPASSWORD=wissempwd
oracle.assistants.server|S_DBSNMPPASSWORD=wissempwd
oracle.assistants.server|S_HOSTUSERPASSWORD=wissempwd
oracle.assistants.server|S_ASMSNMPPASSWORD=wissempwd
[root@srvdb01 patch3]#

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

[root@srvdb01 patch3]# chmod 600 cfgrsp.properties
[root@srvdb01 patch3]# ls -rtl /opt/11.2.0/grid/cfgtoollogs/cfgrsp.properties
-rw------- 1 grid oinstall 330 Oct  7 04:59 /opt/11.2.0/grid/cfgtoollogs/cfgrsp.properties
[root@srvdb01 patch3]#

4. Change directory to /opt/11.2.0/grid/cfgtoollogs

Run the configuration script using the following syntax as the grid user:

$ ./configToolAllCommands RESPONSE_FILE=/opt/11.2.0/grid/cfgtoollogs/cfgrsp.properties

Check if configToolRunAllcmds ran successfully, check the generated log file ; /opt/11.2.0/grid/cfgtoollogs/oui/configActions2011-10-07_05-01-44-AM.log

cat /opt/11.2.0/grid/cfgtoollogs/oui/configActions2011-10-07_05-01-44-AM.log

###################################################

The action configuration is performing

------------------------------------------------------

The plug-in Update Inventory is running

/opt/11.2.0/grid/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true "CLUSTER_NODES={srvdb01,srvdb02,srvdb03,srvdb04,srvdb05,srvdb06,srvdb07}" ORACLE_HOME=/opt/11.2.0/grid

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 16351 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /opt/app/oraInventory

The plug-in Update Inventory has successfully been performed

------------------------------------------------------

------------------------------------------------------

The plug-in Oracle Net Configuration Assistant is running

Parsing command line arguments:

    Parameter "orahome" = /opt/11.2.0/grid

    Parameter "orahnam" = Ora11g_gridinfrahome1

    Parameter "instype" = typical

    Parameter "inscomp" = client,oraclenet,javavm,server

    Parameter "insprtcl" = tcp

    Parameter "cfg" = local

    Parameter "authadp" = NO_VALUE

    Parameter "responsefile" = /opt/11.2.0/grid/network/install/netca_typ.rsp

    Parameter "silent" = true

    Parameter "silent" = true

Done parsing command line arguments.

Oracle Net Services Configuration:

Profile configuration complete.

Profile configuration complete.

Profile configuration complete.

Profile configuration complete.

Profile configuration complete.

Profile configuration complete.

Profile configuration complete.

srvdb01...

srvdb02...

srvdb03...

srvdb04...

srvdb05...

srvdb06...

srvdb07...

Oracle Net Listener Startup:

    Listener started successfully.

Listener configuration complete.

Oracle Net Services configuration successful. The exit code is 0

The plug-in Oracle Net Configuration Assistant has successfully been performed

------------------------------------------------------

------------------------------------------------------

The plug-in Automatic Storage Management Configuration Assistant is running

The plug-in Automatic Storage Management Configuration Assistant has failed its perform method

------------------------------------------------------

The action configuration has failed its perform method

###################################################

We can ignore the above failed messages, as soon as our resources are up and running.
Check the actions logs and check for the local listener resource running in all 7 nodes.

As grid user, run:

$GRID_HOME/bin/crsctl stat res –t
$GRID_HOME/bin/crsctl stat res -t -init
$GRID_HOME/bin/crsctl check cluster -all

Now you can proceed with Oracle RAC database installation.