Thursday, January 8, 2009

How to run Oracle Forms 10g applications on vista???

To make Oracle forms Services to run on Vista you need to have Oracle forms version 10.1.2.3.0. For more information follow the below link for software matrix
http://www.oracle.com/technology/products/forms/htdocs/10gR2/clientsod_forms10gR2.html

To upgrade to Oracle Forms 10.1.2.3.0 and Webutil Version 10.1.2.3 follow the below steps:

Step 1:
--------

To upgrade Oracle Application Server to 10.1.2.3 .0 follow Note number: 329361.1 on http://metalink.oracle.com .
This note explains all the steps and patches needed to be applied to make Oracle Application Server 10.1.2.3.0.
Patch 4505133 to upgrade Database homes to 10.1.0.5.
Patch 5983622 to upgrade Middle and infrastructure tier to 10.1.2.3.0

Step 2:
--------

After that you need to follow Note Number 421930.1 on http://metalink.oracle.com .
This note explains how to obtain FRMWEBUTIL.JAR file from the IAS/IDS Patchset kit (10.1.2.x). This file is needed when you upgrade the IAS from 10.1.2.0.2 to 10.1.2.2/3 to fix the Webutil issues.
Current signature for frmwebutil.jar from 10.1.2.3 patch expires on January 2009. You can get a new frmwebutil.jar that is signed with a new certificate that is valid beyond January 2009 from Patch 7384879 . Please pay attention to the version you download 10.1.2.2 or 10.1.2.3.

Step 3:
--------

Configuration of your Application on the Application Server.
Jinitiator will not work with Vista so you have to change your application setting to use Sun JRE. You should use SUN JRE version 1.6 to make Application run to Vista.

Default.env file
Add “rt.jar” and “frmall.jar” paths in your CLASSPATH. Your CLASSPATH should look like below.

CLASSPATH=E:\10g_mid\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\
WEB-INF\lib\frmsrv.jar;E:\10g_mid\jlib\repository.jar;E:\10g_mid\jlib\ldapjclnt10.jar;
E:\10g_mid\jlib\debugger.jar;E:\10g_mid\jlib\ewt3.jar;E:\10g_mid\jlib\share.jar;
E:\10g_mid\jlib\utj.jar;E:\10g_mid\jlib\zrclient.jar;E:\10g_mid\reports\jlib\rwrun.jar;
E:\10g_mid\forms\java\frmwebutil.jar;
E:\10g_mid\jdk\jre\lib\rt.jar;E:\10g_mid\forms\java\frmall.jar

Formsweb.cfg
Your Application configuration should look like below

WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
archive=frmall.jar
lookAndFeel=oracle
workingDirectory=E:\webutil demo
form=WU_TEST_106.fmx
userid=username/password@host string
pageTitle=Webutil Demo
jpi_classid=clsid:CAFEEFAC-0016-0000-0011-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u10-windows-i586.cab#Version=1,6,0,11
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_11

After performing the above steps run your application on Vista with Admin Privileges for the first time as it will download some .dll’s from the Application Server to the Client Machine for webutil purpose. After that you can run the application as a Normal User on Vista.

Please leave comment if you still have any issues.

No comments: