Thursday, July 23, 2009

Upgrade compatibility

To answer to questions while planning for upgrade such as

My current DB and Apps versions are so and so, I need to upgrade DB and Apps to so and so latest versions,
So is direct upgrade possible?
How should I split the upgrade process ?
I want only DB upgrade, will it be compatible with my Current apps version ?
I want only Apps upgrade, will it be compatible with my current DB version ?


Read below to get an answer:

oracle database upgrade guide at http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i1007718
–362203.1 Oracle Applications Release 11i with Oracle 10g Release 2
–216205.1 Database Initialization Parameters for Oracle Applications 11i


10G upgrade :

Base release of 10gR2 is 10.2.0.1 so first you have to Install 10.2.0.1 & then apply patchset 10.2.0.2 which is certified to work with Apps 11i (11.5.9 & 11.5.10)

–You can download 10.2.0.1 software from http://www.oracle.com/technology/software/products/database/oracle10g/index.html
You need companion CD as well so download companion CD as well from above location.
–10.2.0.2 is available as patch 4547817 which you can download from http://metalink.oracle.com or updates.oracle.com


You can upgrade directly to 10.2.0.1 from following database version
8.1.7.4 , 9.2.0.4 or higher, 10.1.0.2 or higher


Database upgrade is Two Step process:

1.upgrade software from 8i, 9i or 10.1 to 10.2
Install companion CD separately ( Ultra Search )
apply patcheset 10.2.0.2 check ReadMe of patch 4547817 via OUI


2.Upgrade database Metadata ( via executing sql’s or dbua )

Complete Checklist for Manual Upgrades to 10gR2 316889.1

Now apart from upgrading database there are some pre upgrade & post upgrade steps specific to oracle applications 11i & follow them as mentioned in metalink note # 362203.1

Upgrade to 9.2.0.8 from note: 216550.1



Apps upgrade to support 10G:

316365.1 Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions (Use this to upgrade from 11i i.e. 11.5.5,6,7,8,9 to 11.5.10.2)

Upgrade of Oracle Application to 11.5.10.2 from previous release of 11i (11.5.5 to 11.5.9) should be done by applying maintenance pack i.e. Patch # 3480000 and few other prereq. & post patch steps. Follow Metalink Note # 316365.1

Your application should be on AD minipack I version 2 i.e. 11.AD.I.2 which is available via patch # 4337683 so first apply patch 4337683. (If you are not sure if you already have AD.I.2 or not query AD_BUGS table)

If you are planning to merge prereq. patches, NLS patches and other functional patches with 11.5.10.2 (3480000), note that AD.I.2 4337683 should not be merged as it is not possible to merge AD patches.

If you are already on 11.5.10 and wish to upgrade to 11.5.10.2, simply apply patch u3480000.drv using adpatch utility (316366.1)


316366.1 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2) (Use this to upgrade from 11.5.10 to 11.5.10.2)


289788.1 Upgrading Oracle Applications (Use this doc to upgrade to 11.5.10.2 from 10.7 or 11.0.3)

No comments: