January 26 2011

Upgrading Oracle Database from 11.2.0.1 to 11.2.0.2

Tagged Under : ,

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.