In this post I will explain - step by step - how to upgrade an Oracle Applications 11i environment to the latest certified Developer 6i patchset - nowadays patchset 18.
In this post I assume you have an Oracle Applications 11.5.10.2 on Linux with autoconfig enabled.
Other OS needs another patches (take a look on note #125767.1).
So let's begin...
1) Stop all applications processes (adstpall.sh) on all application tier nodes.
2) Apply latest certified Developer 6i patchset 18 (4948577) on all application tier nodes.
- make sure ORACLE_HOME refer to 8.0.6 Oracle home.
- run ./patch_install.sh
- execute the following commands:
cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install
cp –b /developer6i_patch18/bin/genshlib $ORACLE_HOME/bin
3) Apply patch 5713544
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
4) Apply patch 4261542
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG4261542
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG4261542
- cp /oracle/forms/engine/Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
- cp /oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
5) Apply patch 5216496
- sh patch.sh
6) Apply patch 5753922
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
7) Apply patch 5355158
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG5976594
- cp /oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
- execute adadmin -> "Generate Applications Files menu" -> "Generate product JAR files"
8) Apply patch 5938515
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
9) Apply patch 3830807
- sh patch.sh
- execute adadmin -> "Maintain Applications Files" -> "Relink Applications programs"
10) Apply patch 4586086
- mv env_forms60.mk env_forms60.mk.PRE_BUG4586086
- cp /env_forms60.mk $ORACLE_HOME/forms60/lib
- cd $ORACLE_HOME/forms60/lib
- make -f cus_forms60w.mk libso_install
- adrelink.sh force=y "fnd f60webmx"
11) Relink applications executables
- execute admin
- “Maintain Applications Files Menu”
- "Relink Applications program"
- List of product to link: “fnd”
- Generate specific executables ….: “y”
- Relink with debug: “n”
- Enter executables to relink: “f60webmx ar60run ar60runb ar60rund *”
12) Apply Apps Interoperability patch - 4888294
- adpatch...
13) execute adadmin -> "Generate Applications Files menu" -> "Generate product JAR files"
14) Start all applications processes (adstrtall.sh)
Now your system are upgraded with the latest Developer6i patchset.
Additional information you can find at Oracle Metalink Note #125767.1 - Upgrading Developer 6i with Oracle Applications 11i.
If you need more information or something is not clear, please leave a comment and/or Mail. |
28 comments:
hii
I think "11) Relink applications executables
- execute admin"
you meaned to adadmin
bye
Hi,
Thanks for the correction and paying attention.
You right, I mean to adadmin...
Aviad
good job..
plesse keep this up.
Thanks :-)
Hai.
Good job. It's more clear than Metalink Note:125767.1. But, you were not clear about the relinking of the executables like f60webmx. Can you be more clear on this supposing that we have a multinode installation where on one node we have ADMIN-CCM-DB & other node FRM-WEB.
regards,
Dileep Tallam.
Thanks!
Regarding the relinking - what part exactly wasn't clear?
To relink the f60webmx, issue this: adrelink.sh force=y "fnd f60webmx"
The Developer 6i patch should be applied on all application tier nodes hosting the Forms server, Reports server, HTTP server and Concurrent Processing server.
regards,
Aviad
Hi,
How can i find the existing Forms / Developer patchset version ??
Thx
Hi,
Navigate to help -> About Oracle Applications in any forms session window.
Look for: Oracle Forms Version : 6.0.8.XX.X
6.0.8.24.x -> patchset 15
6.0.8.25.x -> patchset 16
6.0.8.26.x -> patchset 17
Take a look on Note:232313.1 - Information on Previous Versions of Developer 6i Patchsets.
Aviad
Hi Avid,
Good job,
But i think we need to edit the patch 4586086 steps to be:
mv $ORACLE_HOME/forms60/lib/env_forms60.mk env_forms60.mk.PRE_BUG4586086
then
cp /env_forms60.mk $ORACLE_HOME/forms60/lib
BR
Hi,
This is exactly what I mean.
It's illogical to change the file name within the patch directory anyway... :-)
Thanks!
Aviad
Hi,
Thanks for the nice post.
We are Upgrading Developer 6i with Oracle Applications 11i patch 4948577 in the UNIX env and followed the read me of README for 4948577
Having following query.
We have 2 node installation (Apps Tier and DB Tier) with 10g DB and Oracle Apps 11i10
Apps tier has - Apache and Form server
DB tier- Concurrent manager and Report server.
In Apps tier the
$ORACLE_HOME=/oa_ebs_t651a/applmgr/t651ora/8.0.6
$IAS_ORACLE_HOME=/oa_ebs_t651a/applmgr/t651ora/iAS
In the DB tier
$ORACLE_HOME =/oa_ebs_t651d/applmgr/t651ora/8.0.6
$IAS_ORACLE_HOME=/oa_ebs_t651d/applmgr/t651ora/iAS
Our application owner is applt651 which has all permission to $ORACLE_HOME as well as $IAS_ORACLE_HOME
As per note ID- 125767.1
Install the full Developer 6i Patch on all Application Tier nodes hosting the Forms server, Reports server, HTTP server and Concurrent Processing server.
Q- DO WE NEED TO INSTALL Developer 6i Patch IN BOTH APPS AND DB TIER. PL CONFORM.
As per READ ME- 4948577
1- Set your ORACLE_HOME.
Q---->1- PL ADVICE WHAT WILL BE THE ORACLE_HOME FOR APPS TIER AND DB TIER.
Is it $ORACLE_HOME =/oa_ebs_t651d/applmgr/t651ora/8.0.6. Pl conform…?
2- Do we need to install the patch on 8.0.6 both Apps and DB tier…? Pl conform…?
Step 2 is talking below
2- If you are going to apply this patch on top of an iAS install:
Set ORACLE_HOME to iAS_HOME iserver
Q----> 1- DO WE NEED TO INTALL THE PATCH TOP OF IAS on both Apps tier and DB tier.…..?
2- If yes the what will be the $ORACLE_HOME
If you have any query pl let us know.
Waiting for your update.
Hi Anonymous,
Q- DO WE NEED TO INSTALL Developer 6i Patch IN BOTH APPS AND DB TIER
Answer – Yes, you should install this patch on both DB & Apps tier nodes.
Q---->1- PL ADVICE WHAT WILL BE THE ORACLE_HOME FOR APPS TIER AND DB TIER.
Is it $ORACLE_HOME =/oa_ebs_t651d/applmgr/t651ora/8.0.6. Pl conform…?
Answer – for Apps tier: $ORACLE_HOME=/oa_ebs_t651a/applmgr/t651ora/8.0.6
For DB tier: $ORACLE_HOME =/oa_ebs_t651d/applmgr/t651ora/8.0.6
Q----> 1- DO WE NEED TO INTALL THE PATCH TOP OF IAS on both Apps tier and DB tier.…..?
Answer – You shouldn’t set the ORACLE_HOME to the IAS_HOME.
The only ORACLE_HOME you should set is to the 806_ORACLE_HOME.
You should install the Developer 6i patchset 18 only once on top of 806_ORACLE_HOME.
Hope it will help
Aviad
Aviad,
when applying patch 5355158, you've said,
cp /oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
I extracted this patch file , but I could'nt find this oracle folder inside..rather I have only this 2 directory
[appl10@oracle 5355158]$ ls
etc files README.txt
let us know
Thanks
Yusuf
Aviad,
I suggest to add cd $ORACLE_HOME/forms60/lib
before.. this..
mv env_forms60.mk env_forms60.mk.PRE_BUG4586086
- cp /env_forms60.mk $ORACLE_HOME/forms60/lib
- cd $ORACLE_HOME/forms60/lib
- make -f cus_forms60w.mk libso_install
- adrelink.sh force=y "fnd f60webmx"
Thanks
Yusuf
Aviad:
You have listed all the steps (for upgrading the DB from 9.2 to 10.2 together. I work alone and have no backup or a team - and was wondering whether I could potentially stagger the upgrade and do the Developer Patch Set, then the Autoconfig Patch set, then the interoperabilty patchset and finally the DB upgrade at different times - i.e. space them out - instead of doing them all together.
Tks in advance for your response.
You are definitely can split the installation to these steps instead of doing them together.
Aviad
Hi Yusuf,
I think you have downloaded the wrong patch.
There are 2 patches numbered 5355158:
1) For release 6.0.8.27
2) For release 9.0.4.3
You downloaded the second while you should download the first one (for release 6.0.8.27)
Aviad
Aviad:
I have spent almost a whole day today literally like a 'dog chasing it's tail' trying to find out how to go about a DB upgrade - and it seems that the interruption to users will not be minimal at best. Would you mind if I asked you some questions (fairly stupid to you - but really important to me - being that I have been an APPS DBA for only 9 months) off-line or would you prefer I post them here?
Tks
Hi,
You are welcome to post any question as a comment, this way, all questions and answers will be shared to everyone.
Thanks,
Aviad
Thats rite Aviad,
I downloaded the wrong patch.. and Now I successfully upgraded .
Thanks
Yusuf
HI
You motioned in the step 5 to apply the patch 5216496 by executing -sh patch.sh, but I found in metalink (README for 5216496) others instructions to apply it. Please Advice
Aljaro
HI
You motioned in the step 5 to apply the patch 5216496 by executing -sh patch.sh, but I found in metalink (README for 5216496) others instructions to apply it. Please Advice
Aljaro
Aljaro,
I can't see the others instruction you are talking about.
This is the relevant section from the README:
% cd 5216496
% sh patch.sh
Aviad
Hi Aviad,
I would to thank you for your efforts to post like this comments and investigations.
Just I would like to bring your attention to the point number 7, since the patch number 5355158 replaced by the patch number 6195758 through metalink document ID 125767.1 to be as the following:
7) Apply patch 6195758
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG6195758
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class.PRE_BUG6195758
- cp /oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
- cp /oracle/forms/handler/ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
- execute adadmin -> "Generate Applications Files menu" -> "Generate product JAR files"
Thanks,
Farrah
Hi Aviad,
Thanks for the informative post!
All I would like to ask is - is it a must to upgrade Forms once Oracle DB is upgraded from 9i to 10g on 11.5.10 or we could leave the forms upgrade ...
Would appreciate an early response.
Thanks for your time!
Regards,
a1_win
Hi a1_win,
The minimun version of Developer 6i that must exists before upgrading EBS 11i database from 9i to 10g is Developer 6i patchset 17.
You may consider applying the latest Developer 6i patchset 19 before upgrading to 10g.
Check this post for detailed step by step Developer 6i Patch Set 19 upgrade with EBS 11i
Regards,
Aviad
Hi,
Note 125767.1 has been updated with Patchset 19 details. I wanted the previous note with Patchset 18 details., becoz i have done 2 Trails with that note and now i have to do the Production.
How can get the old note ?
See Note: 232313.1 - Information on Previous Versions of Developer 6i Patchsets
Post a Comment