Apps DBA Concepts

Just another WordPress.com weblog

Database Upgrade from 10.2.0.2 to 10.2.0.3 – R12

Posted by vasselva on October 26, 2007

Oracle Apps certified the 10.2.0.3 database with R12.Metalink Note 454750.1

Here I will explain my upgrade experience.

As a normal practice before doing upgrade please backup your system. Download the required patches.

Operating system

Unix Users

Windows users

Patch set

5337014

5337014

Patch

6319846

6344567

1. Before Upgrade , check the invalid count in the database

2. Unzip the patch 5337014 .

3. Invoke the run installer for unix and setup.exe for windows users.

4. As a part of post install step

· Start the database in upgrade mode

· @?/rdbms/admin/catupgrd.sql

· After completed upgrade ,Shutdown the database and startup in normal mode.

· @?/rdbms/admin/utlrp.sql

· Apply the additional patches(6319846 and 6344567)

One Response to “Database Upgrade from 10.2.0.2 to 10.2.0.3 – R12”

  1. anubhav said

    Nice post

    Please see this link and post your valuable comments

    http://infosysblogs.com/oracle/2008/12/r12_upgrade_whats_in_it_for_re.html#more

Leave a comment