Thursday, July 19, 2007

Upgrading Developer 6i with Oracle Apps 11i

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:

Anonymous said...

hii
I think "11) Relink applications executables
- execute admin"

you meaned to adadmin

bye

Aviad said...

Hi,
Thanks for the correction and paying attention.
You right, I mean to adadmin...

Aviad

Anonymous said...

good job..

plesse keep this up.

Aviad said...

Thanks :-)

Anonymous said...

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.

Aviad said...

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

Anonymous said...

Hi,

How can i find the existing Forms / Developer patchset version ??

Thx

Aviad said...

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

M Ashour said...

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

Aviad said...

Hi,
This is exactly what I mean.
It's illogical to change the file name within the patch directory anyway... :-)
Thanks!
Aviad

Anonymous said...

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.

Aviad said...

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

yusuf said...

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

yusuf said...

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

Oracle said...

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.

Aviad said...

You are definitely can split the installation to these steps instead of doing them together.

Aviad

Aviad said...

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

Oracle said...

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

Aviad said...

Hi,

You are welcome to post any question as a comment, this way, all questions and answers will be shared to everyone.

Thanks,
Aviad

yusuf said...

Thats rite Aviad,

I downloaded the wrong patch.. and Now I successfully upgraded .


Thanks
Yusuf

aljaro said...

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

Anonymous said...

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

Aviad said...

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

Anonymous said...

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

Anonymous said...

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

Aviad said...

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

Anonymous said...

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 ?

Aviad said...

See Note: 232313.1 - Information on Previous Versions of Developer 6i Patchsets