Upgrade Oracle Grid Infrastructure patchset to 11.2.0.2, follow the steps below:
(1) Unset all GI, CRS and RDBMS related environment variable.
For example: ORA_CRS_HOME, ORACLE_HOME, ORA_NLS10, TNS_ADMIN ..
(2) Goto extracted GI files and run “runInstaller”
/oradump/patchset/grid $ ll
total 80
drwxr-xr-x 8 oracle oinstall 4096 Sep 6 22:12 .
drwxr-xr-x 8 oracle oinstall 4096 Jan 5 19:13 ..
drwxr-xr-x 9 oracle oinstall 4096 Sep 6 22:12 doc
drwxr-xr-x 4 oracle oinstall 4096 Sep 6 22:12 install
-rwxrwxrwx 1 oracle oinstall 27303 Sep 9 17:22 readme.html
drwxr-xr-x 2 oracle oinstall 4096 Sep 6 22:12 response
drwxr-xr-x 2 oracle oinstall 4096 Sep 6 22:12 rpm
-rwxr-xr-x 1 oracle oinstall 4409 Sep 6 21:42 runcluvfy.sh
-rwxr-xr-x 1 oracle oinstall 3227 Sep 6 21:42 runInstaller
drwxr-xr-x 2 oracle oinstall 4096 Sep 6 22:12 sshsetup
drwxr-xr-x 14 oracle oinstall 4096 Sep 6 22:12 stage
-rw-r–r– 1 oracle oinstall 4290 Sep 6 22:12 welcome.html
/oradump/patchset/grid $ ./runInstaller
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 3564 MB Passed
Checking swap space: must be greater than 150 MB. Actual 23999 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-01-05_08-24-06PM. Please wait …
(3) When 1st GUI prompted, Choose “skip software updates”and click “Next”.
(4) Choose “upgrade GI and ASM” from installation options and click “Next”.
(5) Choose your language and click Next.
(6) By default, all nodes will be selected from “Select cluster nodes for GI upgrade” and click Next.
(7) When ask for GI ORACLE_HOME, please enter new GI ORACLE_HOME. GI ORACLE_BASE will not be changed (still using exiting ORACLE_BASE).
(8) When ask for SCAN address, please use the existing SCAN virtual host.
(9) Proceed installation steps until it prompt to run GI $ORACLE_HOME/rootupgrade.sh with root in each RAC node by sequence as instructed.
(10) For Linux 64bit environment, you will get following error during rootupgrade.sh. It is safe to ignore and continue if you have applied Bug Fix 9413827 in previous old GI.
“Failed to add (property/value):(‘OLD_OCR_ID/’-1′) for checkpoint:ROOTCRS_OLDHOMEINFO.Error code is 256”
(11) After rootupgrade.sh have successfully executed in each RAC node. It will prompt to and run cluster verification (cluvfy) in background.
You may get error on “Default user file creation check failed.” with UNKNOWN status, instead of 0022.
Please verify umask setting on all nodes as GI owner id manually, if output is 22, 022 or 0022, then you may safely ignore this warning (Doc ID 1051783.1).
(12) By then, all GI processes and resources are restarted in all nodes.
You should have completed GI and ASM upgrade exercise.
Post upgrade check:
(1) Check ASM and LISTENER if it has been relocated to new GI ORACLE_HOME.
$ srvctl config asm
ASM home: /usr/grid_gxs2/oracle/product/11.2/grid
ASM listener: LISTENER
$ srvctl config listener -a
Name: LISTENER
Network: 1, Owner: oracle
Home: <CRS home>
/usr/grid_gxs2/oracle/product/11.2/grid on node(s) dcgdbp7,dcgdbp6,dcgdbp5
End points: TCP:1521
(2) Pls set the permission bit for /opt/oracle directory to 755 in all nodes if it is not 755.
$ pwd
/opt
$ ls -ald oracle
drwxr-xr-x 4 root oinstall 4096 Aug 12 03:01 oracle