January 26 2011

Upgrading Oracle Database from to

Tagged Under : ,

Upgrade steps for Oracle DB from to :

(1) Make sure you have taken level 0 database backup.

(2) Ensure that (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.

January 14 2011

Upgrade Oracle Grid Infrastructure patchset from (Part 2)

Tagged Under : , , , ,

Upgrade Oracle Grid Infrastructure patchset to, follow the steps below:

(1) Unset all GI, CRS and RDBMS related environment variable.
(2) Goto extracted GI files and run “runInstaller”

January 14 2011

Upgrade Oracle Grid Infrastructure patchset from (Part 1)

Tagged Under : , , , , ,


Existing 3-node Oracle RAC GI (Grid Infrastructure) is running 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
                      30963708  17473048  13490660  57% /usr/grid_gxs