Upgrade Oracle Apps from 11.5.10 to 11.5.10.2

بتاريخ: 5 ديسمبر 200520 سنة

السلام عليكم ورحمة الله وبركاته
اخوانى اعضاء المنتدى الاعزاء
لقد قمنا بعمل ترقيه للاوراكل عندنا فى الشركى من 11.5.10 الى 11.5.10.2
وقررت ان اكتب لكم هذة الخطوات الت اتبعناها لعلها تفيد اى شخص يمكن ان يحتاج اليها
وارجوا المعذرة ان كان هناك خطا او ما شابه ذلك لنسيان او غيره
وان كان هناك اى اسئلة فانا على اتم استعداد

* مع العلم المسبق ان هذة الخطات تتبق فقط فى حالة CU2 وليس فى حالة Maintenance Pack

SPECIFIC STEPS AND PATCHES FOR UPGRADING FROM 11.5.10 TO 11.5.10.2 **************************************************************
- You must take cold full backup from application and database (Very Important)
- You must firstly read the following notes: (316366.1 - 277366.1)
- You must enable maintenance mode by using ADADMIN utility

NOTE:-
*******
we will use
- prod as instance name
- gsprod as hostname
- oracle as owner of DB
- applmgr as owner of applications
- /home/applmgr as applications home
- /home/oracle/9.2.5/ as oracle home

How to enable maintenance mode:
------------------------------------------
- su – applmgr / password
- Stope applications
- . ./APPSPROD_gsprod.env
- . ./PROD_gsprod.env
- $adadmin
Accept all default answer for questions that will asked to you (you will prompted for user system password)
After that the following menu will appear for you:
AD Administration Main Menu
--------------------------------------------------

1. Generate Applications Files menu

2. Maintain Applications Files menu

3. Compile/Reload Applications Database Entities menu

4. Maintain Applications Database Entities menu

5. Change Maintenance Mode

6. Exit AD Administration

* You must choose option no (5) that belongs to Changing Maintenance Mode

* The next menu will appear

1. Enable Maintenance Mode

2. Disable Maintenance Mode

3. Return to Main Menu

* You must choose option no (1) to enable maintenance mode and exit from adadmin to applmgr bash

Use this instruction:-
-------------------------
-You must to verify that your application with AD version of ADX.E.1 or higher.
- Find your patch set level by applying this select statement:

Select * from ad_bugs where bug_number='<NUMBER>';

Where NUMBER is one of the following numbers:
3817226 : Patch 11i.ADX.E.1
4175764 :11i.ADXE.1 FEB 2005 CUMULATIVE UPDATE
3453499 : Patch 11i.ADX.F

If you get any row for any of the above 3 patches you may precede applying the Technology Stack Validation which it’s highly recommended to be run before starting upgrading to ensure that your oracle is available for this upgrade without errors

1- Apply patch 4318672 on all application tier server nodes to install Technology Stack Validation utility which required performing a series of tests that validate the technology stack components of a Release 11i system, ensuring that the system is prepared for the installation of the Release 11.5.10.2.

How to Apply this Patch:
------------------------
This patch must be applied on all application tier server nodes.
- Open new terminal
- su – applmgr / password
- Stop Applications
- cd prodappl
- . ./APPSPROD_gsprod.env
- ../PROD_gsprod.env
- cd (your pach-4318672- directory)
- adpatch
- ………………….(some questions you must answer them)………..
- It will ask you to enter the driver you must enter u4318672.drv

After applying this Patch on each application tier server nodes:
----------------------------------------------------------------

Step1. Update RDBMS ORACLE_HOME with AutoConfig files:
-------------------------------------------------------
Update the RDBMS ORACLE_HOME file system with the AutoConfig files by Performing the following steps:
• On the Application Tier (as the APPLMGR user):
• Open new terminal
• su – applmgr / password
• cd prodappl
• . ./APPSPROD_gsprod.env
• ../PROD_gsprod.env
• Log in to the APPL_TOP environment
• Create appsutil.zip file
• $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
• This will create appsutil.zip in $APPL_TOP/admin/out .
• On the Database Tier
• Copy appsutil.zip file to the <RDBMS ORACLE_HOME> by using cp UNIX command or ftp
• su – oracle / password
• cd proddb
• cd 9.2.0
• unzip -o appsutil.zip

Step2.Run the Technology Validation Utility
---------------------------------------------
Step2.1. Run the Utility on each Application Tier Nodes:
---------------------------------------------------------
• su – applmgr / password
• cd prodappl
• . ./APPSPROD_gsprod.env
• ../PROD_gsprod.env
• Perl –version
Run the technology validation utility using the following syntax:
If you using UNIX OR LINUX OS use this command:
- $ perl $FND_TOP/patch/115/bin/TXKScript.pl
-script=$FND_TOP/patch/115/bin/txkVal11510MP.pl
-txktop=$APPLTMP
-appspass=<apps_password>
-outfile=$APPLTMP/txkVal11510MP.html
If you using windows OS use this command on command prompt:
- $ perl %FND_TOP%\patch\115\bin\TXKScript.pl
-script=%FND_TOP%\patch\115\bin\txkVal11510MP.pl
-txktop=%APPLTMP%
-appspass=<apps_password>
-outfile=%APPLTMP%\txkVal11510MP.html

where <apps_password> is the schema password for Oracle Applications user.

Step2.2. Run the Utility on Database Server Nodes:
--------------------------------------------------

• su – oracle / password
• cd proddb
• cd 9.2.0
• . ./PROD_gsprod.env
• Perl –version
Run the technology validation utility using the following syntax:
If you using UNIX OR LINUX OS use this command:
- $ perl ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkVal11510MP.pl
-txktop=$ORACLE_HOME/appsutil
-appspass=<apps_password>
-outfile=$ORACLE_HOME/appsutil/temp/txkVal11510MP_DB.html
If you using windows OS use this command on command prompt:
- $ ORACLE_HOME%\appsutil\bin\TXKScript.pl
-script=%ORACLE_HOME%\appsutil\bin\txkVal11510MP.pl
-txktop=%ORACLE_HOME%\appsutil
-appspass=<apps_password>
-outfile=%ORACLE_HOME%\appsutil\temp\txkVal11510MP_DB.html

where <apps_password> is the schema password for Oracle Applications user.

Step3. Ensure ALLPASS in Technology Validation Utility Report
--------------------------------------------------------------

The utility must return the "[ALLPASS]" status on each application tier
server node as well as database server nodes in order for you to be able to
continue with the installation of the Release 11.5.10 Maintenance Pack. If
the "[FAIL]" status is returned for any test on any node, you must take the
specified action to fix the problem, re-run the utility on each node that
reported a failure, and ensure that the "[ALLPASS]" status is returned.

In addition, if any tests return the "[WARN]" status, it is highly
recommended, although not required, that you take the specified action to
fix the problem before continuing with the maintenance pack installation.

NOTE:
All above steps listed in note no (4318672):-

********************************************
2 -Apply AD patch 4229931.

How to Apply this Patch no (4229931):
-------------------------------------
This patch must be applied on all application tier server nodes.
- Open new terminal
- su – applmgr / password
- Stop Applications
- cd prodappl
- . ./APPSPROD_gsprod.env
- ../PROD_gsprod.env
- cd (your pach-4229931- directory)
- adpatch
- ………………….(some questions you must answer them)………..
- It will ask you to enter the driver you must enter u4229931.drv

3 -Apply patch 4297568 on the concurrent processing server node.
How to Apply this Patch no (4297568):
-------------------------------------
AutoPatch is not used to apply this patch. It is applied manually, using the instructions in this readme.txt file.

3.1. Log in to each concurrent processing server node as the owner of the
Applications file system.

3.2. If the path /home/applmgr/visappl/sht/11.5.0/lib/ilog/5.1/directory already exists back up any files or directories that it contains.

3.3. Unzip the ilog51lib.zip file (which come from downloading the patch no(4297568)

3.4 Located in the sht/lib directory of this patch
into the $/home/applmgr/visappl/sht/11.5.0/lib directory.

3.5 This will create the ilog/5.1 subdirectory if it doesn't already exist.

3.6 Rgarding to your OS type Copy directories to $/home/applmgr/visappl/sht/11.5.0/lib/ilog/5.1/<your platform>.
(Replace your os type files with old one in the path $/home/applmgr/visappl/sht/11.5.0/lib/ilog/5.1/)
-The files on UNIX or LINUX are concert.lib,cplex71.lib,hybrid.lib,
ilocplex.lib,cplex81.lib,solver.lib,cplex71.dll,cplex81.dll

3.7. Use ADadmin to relink the following specific executables:
- MSO: MSONEW
- WIP: WICDOL WICMEX WICMLX
- WPS: WPCWFS
- MSR: MSRNEW (if using Release 11.5.4 or later)
- MST: MSTNEW (if using Release 11.5.10 or later)
- ENG: ENCACN (if using Release 11.5.6 or later)

How to relink this executables:-
---------------------------------
- su – applmgr / password
- Stop Applications
- cd prodappl
- . ./APPSPROD_gsprod.env
- ../PROD_gsprod.env
- $ adadmin
- Choose Relink Application programs option
- It will ask you some questions accept all defaults except linking all executables option
- When it required you to specifiec one enter the name of the above executables
- After finishing choose exit option untile you out from adadmin

3-Apply the CU2 driver (u3460000.drv).
How to Apply this Patch no(3460000)
-------------------------------------
-------------------------------------
This patch must be applied on all application tier server nodes.
- Open new terminal
- su – applmgr / password
- Stop Applications
- cd prodappl
- . ./APPSPROD_gsprod.env
- ../PROD_gsprod.env
- cd (your pach-3460000- directory)
- adpatch
- ………………….(some questions you must answer them)………..
- It will ask you to enter the driver you must enter u3460000.drv

This patch will take along time do not worry about that
NOTE:
If for any cause your upgrade fail after you run the last patch(u3460000.drv)
- Reenter adpatch and during questions that will asked for you choose option to complete the previous session and evry thing will be ok

Thanks And Best Regards
Oracle Applications DBA
Abdelfatah El_hadad