Saturday, February 6, 2010

Upgrade from Jinitiator 1.3 to Java Plugin 1.6.0.x

Upgrade from Jinitiator 1.3 to Java Plugin 1.6.0.x

Lately Oracle announced the end of Error Correction Support for Jinitiator 1.3 for E-Business Suite 11i, effective July 2009 (ML Note: 552692.1).

This is the sign it’s about time to upgrade to the native Java Plug-in… :-)

Among other things, one of the main advantages of upgrading from Jinitiator to the native Java Plug-in is the prevention of conflicts between them.

This upgrade is great news to all are working with Oracle Discoverer Plus (with Java plug-in) and Oracle EBS 11i (with Jinitiator) and experiencing those conflicts.

I’ll skip all the others advantages and disadvantages of upgrading to Java Plug-in as they are well described in Steven Chan’s post - Jinitiator 1.1.8 To Be Desupported for Apps 11i on blogs.oracle.com and in Metalink Note: 290807.1 - Upgrading Sun JRE with Oracle Applications 11i.

So I will focus on the upgrade process itself - step by step.

I tested the upgrade on the following test environment:

EBS 11.5.10.2
Database 10.2.0.3
ATG Rollup 5
Developer 6i patchset 18
OS RHEL4.

Be aware that before upgrading to Java Plug-in you must upgrade to Developer 6i patchset 18 or later (currently the latest patchset is 19).

1. Download JRE plug-in Oracle E-Business Suite interoperability patch - 6863618

2. Download the Sun JRE Plug-in from http://java.sun.com/javase/downloads/index.jsp

>Select Java Runtime Environment (JRE) 6 Update X (select the latest available update, currently it’s 5)
>Select Windows offline installation, multi-language

3. Rename the downloaded installation file jre-6_uX-windows-i586-p.exe to j2se1600x.exe
In my case rename jre-6_u5-windows-i586-p.exe to ==>> j2se16005.exe

4. Copy the j2se1605.exe file to $COMMON_TOP/util/jinitiator on the Apps Tier node

5. If you are on Developer 6i patchset 18 you should apply forms patches 6195758 & 5884875.
** Skip this step if you are on Developer 6i patchset 19.

>Download Patches 6195758 & 5884875

>>Apply patch 6195758
-Stop all applications processes by adstpall.sh
-Unzip p6195758_60827_GENERIC.zip
-cd 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

>>Apply Patch 5884875
-Unzip p5884875_60827_GENERIC.zip
-cd 5884875
-cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
$ORACLE_HOME/forms60/java/oracle/forms/
engine/Main.class.PRE_BUG5884875
-cp -r $ORACLE_HOME/forms60/java/ oracle/forms/
handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/
handler/AlertDialog.class.PRE_BUG5884875
-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/
engine/AlertDialog.class
-Run adadmin -> Generate Applications Files menu -> Generate product JAR files

6. Apply the Interoperability patch 6863618
>Make sure all applications processes are down
>Enable maintenance mode:
>Execute adadmin -> Change Maintenance Mode (5) -> Enable Maintenance Mode (1)
>Unzip p6863618_11i_GENERIC.zip
>Cd 6863618
>Run adpatch to apply patch driver u6863618.drv
>cd [PATCH_NUMBER]/fnd/bin
>Execute the following command where X represent the update number:
$ txkSetPlugin.sh 1600X
In my case:
$ txkSetPlugin.sh 16005
>Disable maintenance mode:
Execute adadmin -> Change Maintenance Mode (5) -> Disable Maintenance Mode (2)

7. Start all applications processes by adstrtall.sh

8. Verify installation by sign in Oracle EBS and select a forms based responsibility.

For those who worry about performance, take a look at this benchmark:
Benchmark comparison test with Jinitiator 1.3.1.23 and Java Plug-in 1.5.0_05 – performance whitepaper (http://www.oracle.com/apps_benchmark/doc/jinitiator-1-3-1-23-java-plug-in-1-5-0-05-benchmark.pdf

For more information - Note: 290807.1 - Upgrading Sun JRE with Oracle Applications 11i