Upgrade steps for Oracle DB from 11.2.0.1 to 11.2.0.2 :
(1) Make sure you have taken level 0 database backup.
(2) Ensure that 11.2.0.2 (out-of-place) rdbms binary has been installed in new home e.g. /usr/oracle_gxs2/oracle/product/11.2/db_1.
(3) Please refer to Metalink / My Oracle Support document 1201253.1 to check for DST update action. In this scenario, we assume that no application schema object using datatype TSLTZ or TSTZ, hence no action on DST required.
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”
Scenario:
Existing 3-node Oracle RAC GI (Grid Infrastructure) is running 11.2.0.1 in RHEL 5.3 x86_64 with patch 9413827 at Non-share GI ORACLE_HOME .
GI OS owner id: oracle
Environment variable,
export ORACLE_BASE=/usr/grid_gxs/grid
export ORACLE_HOME=/usr/grid_gxs/oracle/product/11.2/grid
Exising GI filesystem,
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/vg01-grid_gxs
30963708 17473048 13490660 57% /usr/grid_gxs