Introduction
Oracle Kinds 11g lacks native help for client-side
operations, resembling file choice dialogs, clipboard entry, or interactions
with Microsoft Workplace. WebUtil bridges this hole by enabling Oracle Kinds
functions to carry out these client-side operations.
This information supplies a detailed step-by-step process
to configure WebUtil in Oracle Kinds 11g, full with precise instructions.
1.
Put together the Database Schema for WebUtil
Earlier than utilizing WebUtil, it’s essential to create the mandatory
database objects by executing the create_webutil_db.sql script.
Connect with the database as SYSDBA:
|
$ sqlplus /
|
Create a devoted WebUtil person :
|
SQL>CREATE
SQL> GRANT CONNECT, RESOURCE, CREATE SYNONYM, CREATE PUBLIC |
Run the WebUtil database script from software server:
|
$ sqlplus |
1.
Obtain and Place the JACOB Library Recordsdata
WebUtil relies on the JACOB library
to work together with Home windows-based functions.
Obtain the Required JACOB Model
·
For Kinds 11g Launch 1 (11.1.1.X) →
JACOB 1.10.1
·
For Kinds 11g Launch 2 (11.1.2.X) →
JACOB 1.14.3
The JACOB model may be downloaded from following
github website
https://github.com/freemansoft/jacob-project/releases
1.
Copy JACOB Recordsdata to Oracle Kinds
After downloading the JACOB recordsdata, extract
to the ZIP file:
Copy the recordsdata in following path of
software server
|
copy
|
1. Place the JACOB DLL Recordsdata
Place the JACOB DLL recordsdata within the right
directories:
For Kinds 11g Launch 1 (11.1.1.X):
|
copy jacob.dll $ORACLE_HOME/kinds/webutil/ |
Kinds 11g Launch 2 (11.1.2.X):
|
cd jacob-1.14.3 cp jacob-1.14.3-x86.dll $ORACLE_HOME/kinds/webutil/win32/ cp jacob-1.14.3-x64.dll $ORACLE_HOME/kinds/webutil/win64/ |
1.
Signal the JACOB JAR File
To keep away from safety points when working Kinds, signal
the jacob.jar file utilizing Oracle’s offered script.
Earlier than signal, change the next in
$ORACLE_INSTANCE/bin/sign_webutil.sh
file
SET JAR_KEY_PASSWORD=Password123#
SET KEYSTORE_PASSWORD=Password123#
SET VALIDDAYS=3600
|
cd $ORACLE_INSTANCE/bin $ sh sign_webutil.sh $ORACLE_HOME/kinds/java/jacob.jar |
1.
Replace CLASSPATH in default.env
Modify default.env to incorporate the required
JAR recordsdata.
|
cd $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/functions/formsapp_11.1.2/config
Add following parameter
CLASSPATH=$ORACLE_HOME/kinds/java/frmall.jar
|
1.
Modify the formsweb.cfg Configuration File
|
cd $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/functions/formsapp_11.1.2/config
Add following
[webutil] WebUtilArchive=frmwebutil.jar,jacob.jar baseHTMLjinitiator=webutiljini.htm baseHTMLjpi=webutiljpi.htm archive_jini=frmall_jinit.jar Kind=webutil_demo.fmx Userid=username/password@DB_SID ##Present db
|
Save and exit.
1. Compile and Deploy webutil_demo.fmb
First obtain webutil_demo.fmb from
following url and place it in software server
https://www.dropbox.com/s/mdkhjh7997r8arh/webutil_demo.fmb?dl=0
Open kind builder and compile the shape
webutil_demo.fmb and place it underneath
$ORACLE_HOME/kinds location.
Or compile it utilizing command
|
$ Cd $ORACLE_HOME/bin $ frmcmp
|
1.
Compile webutil.pll to create webutil.plx
|
Restart
Oracle Kinds and weblogic providers
|
$ cd $ORACLE_INSTANCE/bin $ ./opmnctl
#Cease studies cd $DOMAIN_HOME/bin
./stopManagedWebLogic.sh
#cease kinds
./stopManagedWebLogic.sh
#cease
./stopWebLogic.sh
#begin
cd $DOMAIN_HOME/bin
nohup
#Look forward to
#begin kinds
nohup
#Begin
nohup
#begin opmn
$ cd $ORACLE_INSTANCE/bin ./opmnctl ./opmnctl |
1.
Take a look at WebUtil Configuration
|
http://your_server_hostname:port/kinds/frmservlet?config=webutil |
This could open a window like under
