How to setup Webutil for forms 11g R1 (11.1.1.2.0)

Stics Post in oracle, oracle forms, oracle pl/sql,Tags: , ,
0

Notes:
- frmwebutil.jar already exists/is signed on 11g
- tested with JRE version 1.6.0_25, webutil 1.0.6, jacob 1.10.1_b17
- windows 7, 32bit

1. Download webutil_1.0.6  (or from oracle’s index page) and jacob_1.10.1_b17 (or from project page) jar files.

2. Copy files:
=========
path = c:\Oracle\Middleware\as_1\forms\java

d2kwut60.dll
ffisamp.dll
forms_base_ie.js
forms_ie.js
frmwebutil.jar
jacob.dll
jacob.jar
JNIsharedstubs.dll
sign_webutil.bat[\text]

*Create a folder "server" under forms\:
<span style="color: #0000ff;">path</span> = c:\Oracle\Middleware\as_1\forms\server\
[text]base.htm
basejpi.htm
forms.conf.backup
ftrace.cfg
webutil.cfg
webutilbase.htm
webutiljini.htm
webutiljpi.htm

*May also need the following folder:
path = c:\Oracle\Middleware\as_1\forms\webutil\

d2kwut60.dll
ffisamp.dll
jacob.dll
JNIsharedstubs.dll
sign_webutil.bat

3. SQL operations
=================
Execute the create_webutil_db.sql
-Create a webutil_db/user
-Create a synonym for webutil_db
-Grant the following packages with sys:
DBMS_LOB
UTL_ENCODE
UTL_RAW

4. Sign the following files with sign_webutil or jarsigner tool:
================================================
frmwebutil.jar (normally not needed 11g)
frmall.jar (normally not needed in 11g)
jacob.jar

Edit the sign_webutil.bat (/Oracle/Middleware/as_1/forms/webutil/):

# Path to the keystore file
SET KEYSTORE="C:\Oracle\Middleware\user_projects\domains\DOMAIN_NAME\config\fmwconfig\servers\WLS_FORMS\.keystore"
# If KEYSTORE already exists, old KEYSTORE_PASSWORD for the keystore file must
# be correctly given here. If KEYSTORE does not already exist, any password
# given here will be taken for the new KEYSTORE file to be created.
SET KEYSTORE_PASSWORD=MyPassword
# Give your alias key here. (CAUTION: make sure to change this for each run)
SET JAR_KEY=webutil14
# Key Password for the given key to be used for signing (must be DIFFERENT from KEYSTORE).
SET JAR_KEY_PASSWORD=MyJarPassword 

Save and run the batch to sign the files:

set path=C:\Oracle\Middleware\as_1\jdk\bin
cd C:\Oracle\Middleware\as_1\forms\java
sign_webutil.bat %ORACLE_HOME%\forms\java\jacob.jar
#or
jarsigner -keystore C:\Oracle\Middleware\user_projects\domains\DOMAIN_NAME\config\fmwconfig\servers\WLS_FORMS\.keystore -storepass webutilpasswd frmwebutil.jar webutil14 -verbose

#you can also verify the jar file (if cert errors, add -verbose -cert):
jarsigner  -verify frmwebutil.jar

Notes:
- once you set passwords for the sign tool you shouldn’t change them, only change the jar key alias for every session it is run
- first try with oracle’s sign_webutil.bat, if it fails in all cases do it with java’s jarsigner

5. Set new settings for webutil

[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar
lookAndFeel=Generic
pageTitle=WEBUTIL_TEST
« Prev: :Next »

Leave a Reply

You must be logged in to post a comment.