We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Upgrade Oracle Applications to 11.5.10 CU 2 |
| Saturday, February 10, 2007 |
|
This post is coming bit late & I know lot of you might be wondering when Oracle Apps R12 is in market why I am still writing on 11.5.10 Upgrade . Looking at quesries/doubts/document request by many of my readers in mail and in forum at http://teachMeOracle.com/forum I thought of covering entire 11.5.10 upgrade and its related docs in this post.
This post will focus on 11.5.10.2 which is oracle apps version 11.5.10 with CU 2 and patch number is 3480000 and related metalink note is 316365.1 . Minimum prereq AD patch for 11.5.10.2 is AD.I.2 (4337683)
Please Note:
1. Patch 348000 (11.5.10.2) is for 11.5.9 or lower version , If you are already on 11.5.10 and which to apply CU2 then this is not right patch for you.
2. Steps mentioned here are for upgarding your apps version 11.5.X , This post doesn't cover upgrade procedure from 10.7 or 11.0.3
3. If you have language other than US then you have to apply translated version of patch as well
4. To reduce Upgrade downtime you can use staged APPL_TOP methodology mentioned in metalink note # 242480.1 Using a Staged Applications 11i System to Reduce Patching Downtime
5. MRC schema is no more used from 11.5.10 onwards so you can drop MRC schema after upgrade so there is no need to maintain/synchronize MRC before or after 11.5.10 (CU2) upgrade
6. 11.5.10.2 requires database version 9.2.X and higher so you can upgarde to 9.2.X or 10.1.X before Upgarde . If you wish to upgrade to database 10.2.X then its better you do it after 11.5.10.2 Update.
7. Since I upgraded Financial & HRMS system so I will focus on steps related to these module but check optional steps mentioned in metalink note # 316365.1 , There are some additional steps for Windows which are not covered in this post
8. To reduce patch downtime online help patches can be applied at later stage
A) Pre Update task
Compulsory Steps
-----------------
A.1 As mentioned above apply AD.I.2
A.2 Update Autoconfig Tech Stack template files - Autoconfig uses Template files to build files specific to your applications
A.3 Run Technology Validation Utility - This will test minimum tech stack components required to run 11.5.10.2 (Tech Stack components are database, forms & reports, discoverer, Jinitiator, JDK, OJSP, JDBC, libraries for web & form server )
A.4 Check OATM step mentioned in optional steps below. If you are not migrating to OATM mentioned above then prepare your table space to include new space requirement and new products . Read me of patch 3180164 will help you in creating additional tablespaces.
Optional Steps
----------------
A.5 Manual Update script - Run this script to find optional & compulsory manual steps you should do before upgarding (This script is specific to an Instance and vary instance to instance)
A.6 Convert database to OATM (Earlier tablespace were based on OFA/Optimal Flexible Architecture where each product used to have one data & one index tablespaces so there were around 200+ tablespace which was difficult to manage which is now moved to ATM/Application Tablespace Model which is simple to manage & there are around 15 table spaces)
A.7 This steps is only required if you are using audit trails & shadow tables name > 26 characters. For auditing purpose you may have auiting enabled for Instance which you want to upgrade then you must change shadow table names (I will cover more on auditing in oracle applications in coming post) before any new columns can be added . HRMS & Payroll customers with Auditing enabled focus on this. If you are not sure if any of your shadow table name is > 26 then use script FNDATCTBL.sql provided with patch 3872242
A.8 If you are using any of product which require ilog planner libraries then apply related patches
A.9 Unmerge of Contacts from TCA Process is long running process during 11.5.10.2 upgrade process so if you wish to reduce downtime during upgrade
then run this program before upgrade else it will be executed during upgrade
process
Apply Maintenance Pack
===================
1. Shutdown application tier services
2. If your database is not 9i upgrade it now
3. Apply maintenance patch . This is unified driver
4. Apply any additional languages patches (If your installation is multi language)
Post Update task
==============
1. Apply Interoperability patch (If you upgraded database to 10g)
2. Register new product , If you want to use any product installed as part of 11.5.10.2 you have to manually license it via OAM
3. Drop MRC schema (As mentioned above MRC schema is no longer required from
11.5.10)
4. If you are not using HRMS Pack I before upgrading to 11.5.10.2 then you have to apply HR legislative updates
5. There are product specific updates which you should carry out with your
functional consultant.
For complete list and extensive steps to upgrade follow metalink note # 316365.1Labels: upgrade |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 8:23 PM
  |
|
| 19 Comments: |
-
Note:242480.1 Using a Staged Applications 11i System to Reduce Patching Downtime
It refers a staged APPL_TOP, but doesn't mention how to stage COMMON_TOP and ORA_TOP (6i and Apache home).
Any idea about this? Thanks.
-
Nice question anonymous, Yes you use entire application tier as staged (Think appl_top) in terms of application tier because when you apply apps patch using adpatch only appl_top changes (if you apply tech stack patches jinit, iAS or forms & report) . So you can stage entire application tier. At actual upgrade you just have to upgrade database tier and you need to copy application tier (appl_top, comn_top & iAS & 806)
-
From what release of 11.5.x have you performed the upgrade? How long did it take to do the upgrade?
-
Hi Atul,
What should we do if we want to upgrade from 11.0.3 ?
Thanks
-
Hi,
I had upgrade from 11.5.9 to 11.5.10 after this i want to upgrade my db from 9.2.07 to 9.2.0.8. Please let me know the steps for the upgrade of the db.
thanks,
Shailender
-
hi Atul
i had setup in 11.5.9 and we want 2 upgrade it in 11.5.10 and my database is 9.2.0.5 so plz provide me steps to do upgrade or do i need to upgrade my database is also.
Thanx
RAHEEL KHAN
-
Check 316365.1 Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions
Upgrade of database is optional & not compulsory
-
Dear Atul,
Thanks for your information you have provided. We have a similar scneario but with 11.0.3 Applications. I need your help and opinion, which will be greatly appreciated.
Our Company is on 11.0.3/8.0.5 Version and on Digital UNIX V4.0F. We want to upgrade the applications to 11.5.10.2/10g DB and move it to Red Hat Linux AS 4.
I want to know during this upgrade process when we have to move the application to Linux either in the mid or after the upgrade. What is the best procedure.
Your inputs regarding this higly appreciated.
Regards,
AS
-
Hi AS,
I am have not upgarded/migrated from 11.0.3 so you might have to contact Oracle Support for this information
-
Hi,
Please provide me the steps for Upgrading Oracle Applications 11.0.3 on Compaq Alpha to Oracle Applications 11.5.10.2 on Linux 4i.
Thanks and Regards,
Fouad.
-
Hi Foud, As I have not worked on 11.0.3 I may not be able to help you. Kindly check with Oracle Support
-
Mr. Atul,
i am stuck with below issue while upgrading to 11.5.10.
i already installed jdk 1.4
when i type
which java it is showing the path correctly.
java -version command also showing version 1.4.
please help.
cd $FND_TOP/patch/115/bin
txkJdkM.sh jdktop=/usr/java/j2sdk1.4.2_15/bin
Using Application context file /d00/oracle/siixappl/admin/SIIX_ebsiprd.xml...
Sourcing /d00/oracle/siixappl/SIIX_ebsiprd.env APPL_TOP environment file.....
A valid JDK installation directory is required - verify that
/usr/java/j2sdk1.4.2_15/bin
exists and is readable and restart txkJdkM.sh
-
Mr. Atul,
i am stuck with below issue while upgrading to 11.5.10.
i already installed jdk 1.4
when i type
which java it is showing the path correctly.
java -version command also showing version 1.4.
please help.
cd $FND_TOP/patch/115/bin
txkJdkM.sh jdktop=/usr/java/j2sdk1.4.2_15/bin
Using Application context file /d00/oracle/siixappl/admin/SIIX_ebsiprd.xml...
Sourcing /d00/oracle/siixappl/SIIX_ebsiprd.env APPL_TOP environment file.....
A valid JDK installation directory is required - verify that
/usr/java/j2sdk1.4.2_15/bin
exists and is readable and restart txkJdkM.sh
-
-
Thanks for your nice post!
-
hi Atul,
We are on 11.5.9 and planning for 11.5.10.2 upgrade.
The workflow is highly customized and with imodules.
What preliminary steps to be taken to take care of the workflow before/after upgrade.
Thanks
-
hi this is kiran i want 11.5.9 to 11.5.10 upgradation steps
and also 11.5.10 ,11.5.10.2 differences.
-
hi Sir!
Is it also best to upgrade our linux machine? we will also upgrade from 11.5.9 to 11.5.10 with 9.2.0.4 database.
Thanks!
\\ Jen
-
hi Atul
iam upgrading the applications 11.5.9 to 11.5.10.2
while aim applying maintenance pack
3480000 i have hang up with my workers invirupg2.sql,ozfaelne.sql and bom10u03.sql this scrips are running from 10 to 15 hours still it was running can u please suggest me ..
|
| |
| << Home |
| |
|
|
Note:242480.1 Using a Staged Applications 11i System to Reduce Patching Downtime
It refers a staged APPL_TOP, but doesn't mention how to stage COMMON_TOP and ORA_TOP (6i and Apache home).
Any idea about this? Thanks.