11i Upgrading Oracle Applications - Section 2: Applying the Maintenance Pack.

1. Download the US version of the Maintenance Pack 3480000 and unzip it. Your unzip utility should be of version 5.41 (or later).

2. If you using other languages along with your US langauage, download the corresponding NLS version of the patch 3480000. If you are using 2 or more NLS languages, you can merge all the NLS version of the Maintenance Pack and applied it at one go.

References:

Oracle Applications NLS Release Notes (Note 316804.1).
Oracle Applications Maintenance Procedures (Note 289791.1).

The above 2 steps should be done, before the downtime starts.

3. Shut down application tier server processes or services.
Bring down all the Oracle Applications services down, only your database and database listener should be up.

4. Maintenance mode.
Place the instance in maintenance mode using adadmin and selecting option 5.

5. Deinstall application tier services (Windows only).

MP changes the way few services are defined and started on windows. We have to manually deinstall the services, once the Oracle Applications services are down.

Apache Server:
%COMMON_TOP%\admin\install\\adsvapc.cmd -deinstall

Forms Server:
%COMMON_TOP%\admin\install\\adsvfrm.cmd -deinstall

TCF Socket Server:
%COMMON_TOP%\admin\install\\adsvtcf.cmd -deinstall

Fulfillment Server:
%COMMON_TOP%\util\OamkSvc.exe -sr "Oracle Fulfillment Server"

iProcurement Server:
%COMMON_TOP%\admin\install\\icxblksvc.cmd -deinstall

ICSM:
%IEO_TOP%\admin\scripts\\ieontics.cmd unregister

6. Upgrade the database.

This is a conditional step. The minimum version of database required to go to 11.5.10.2 is Oracle9i Release 2. If you want to go to datbase 10g, then you must be atleast at 11.5.9.2 or 11.5.10.2. There is a bug assciated with this issue. We cannot upgrade your database to 10g, which you are at 11.5.9 or prior or if you are at 11.5.10.

Review the documnets Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) (Note 216550.1) or Oracle Applications Release 11i with Oracle10g Release 1 (10.1.0) (Note 282038.1).

As mentioned in the pre-update section, database upgrade is invariably done as one of the first step, well before this point.

7. Apply the maintenance pack.

Apply patch 3480000. You need to applying first of the admin node, then apply it on other Oracle applications nodes. If Shared APPL_TOP is implemented, then you need to apply it only once from the admin node, immaterial of how many nodes you have.

If you are applying from 11.5.4 or earlier, you need to run Maintain multi-lingual tables from the admin node, using adadmin.

Once the MP is completed review the log file for any errors and confirm that 3480000 went through successfully.

Once US version of the MP is applied successfully, you can apply the NLS/merged NLS version of MP. You have to apply on admin node first.

Review note Oracle Applications Maintenance Procedures (289791.1).

Prior to Release 11.5.9, you were required to run AD Administration to:

Recreate grants and synonyms for APPS schema(s)
Compile APPS schema(s)
Compile flexfield data in AOL tables
Maintain Multiple Reporting Currencies schema(s)
Generate message files
Compile Java Server Pages

The above is not required now. Autopatch will do it automatically.

With this we conclude this section.

You are at 11.5.10.2 now.You can confirm the same by running the following query--

select RELEASE_NAME from FND_PRODUCT_GROUPS;