商云方的技术博客 (沪ICP备14046774号-1)

WEBUTIL installation in Oracle Application Server10.1.2.0.2

1.download http://www.oracle.com/technology/software/products/forms/files/webutil/webutil_106.zip

2.upzip webutil_106.zip
3.copy java\frmwebutil.jar to the directory [OraHome]\forms\java
4.copy all files in directory server\ to the directory [OraHome]\forms\server；
5.copy directory webutil to the directory [OraHome]\forms\；

6.unzip jacob_18.zip
http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip
7.copy jacob.jar to the directory %ORACLE_HOME\forms\java；
8.copy jacob.dll to the directory %ORACLE_HOME\forms\webutil；
9.set environment variablePath :[OraHome]\jdk\bin

10．open command window，sign frmwebutil.jar and jacob.jar
cd [OraHome]\forms\webutil\
[OraHome]\forms\webutil\sign_webutil [OraHome]\forms\java\frmwebutil.jar
[OraHome]\forms\webutil\sign_webutil [OraHome]\forms\java\jacob.jar
note：Do not care if key is duplicated when signing
11.create webutil_db package;

login db as sysdba

CREATE USER webutil IDENTIFIED BY webutil
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;

GRANT CONNECT, resource, CREATE PUBLIC SYNONYM TO webutil;

grant execute on dbms_lob to webutil;

grant execute on utl_encode to webutil;

grant execute on utl_raw to webutil;

CONNECT webutil/webutil@orcl

@[OraHome]\forms\create_webutil_db.sql

CREATE PUBLIC SYNONYM webutil_db FOR webutil.webutil_db;
grant execute on webutil_db to public;

12.modify [OraHome]\forms\server\default.env
CLASSPATH=[OraHome]\forms\java\frmwebutil.jar;[OraHome]\jdk\jre\lib\jacob.jar;[OraHome]\jdk\jre\lib\rt.jar ;

13.modify [OraHome]\forms\server\formsweb.cfg

[webutil]

WebUtilArchive=frmwebutil.jar,jacob.jar,frmall.jar

14.modify [OraHome]\forms\server\webuitl.cfg

transfer.database.enabled=TRUE

transfer.appsrv.enabled=TRUE

15.modify webutil.pll

replace webutil.pll by webutil.pll in the directory Oracle Developer Suit-home/forms/webutil.pll

and rename webutil.pll to webutil_lib.pll

WEBUTIL installation in Oracle Developer Suit10.1.2.0.2

In Forms DS 10.1.2.0.2, almost all the required configurations are done by the Oracle Universal Installer itself, except for the part related to jacob.

1) Download http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip
and extract to a temporary staging area. Do not attempt to use 1.7 or 1.9.

2) Copy or move jacob.jar and jacob.dll
C:\webutile is the folder where you extracted Jacob, and will end in …\jacob_18
cd C:\webutile
copy jacob.jar Oracle_Home\forms\java\.
copy jacob.dll Oracle_Home\forms\webutil\.
The Jacob staging area is no longer needed, and may be deleted.

3) Sign frmwebutil.jar and jacob.jar
Open a DOS command prompt.
Add Oracle_Home\jdk\bin to the PATH:
set PATH=C:\oracle\developer\jdk\bin;%PATH%
Sign the files, and check the output for success:
C:\oracle\developer\forms\webutil\sign_webutil C:\oracle\developer\forms\java\frmwebutil.jar
C:\oracle\developer\forms\webutil\sign_webutil C:\oracle\developer\forms\java\jacob.jar

4) If you already have a schema in your RDBMS which contains the WebUtil stored code,
you may skip this step. Otherwise,
Create a schema to hold the WebUtil stored code, and privileges needed to
connect and create a stored package. Schema name “WEBUTIL” is recommended
for no reason other than consistency over the user base.

Login as sysdba
CREATE USER webutil IDENTIFIED BY webutil
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;

GRANT CONNECT, resource, CREATE PUBLIC SYNONYM TO webutil;

grant execute on dbms_lob to webutil;

grant execute on utl_encode to webutil;

grant execute on utl_raw to webutil;

CONNECT webutil/webutil@orcl

@[OraHome]\forms\create_webutil_db.sql

CREATE PUBLIC SYNONYM webutil_db FOR webutil.webutil_db;
grant execute on webutil_db to public;

5) Modify Oracle_Home\forms\server\default.env, and append C:\oracle\developer\jdk\jre\lib\rt.jar
to the CLASSPATH entry.

6) Modify Oracle_Home\forms\server\formsweb.cfg insde [default] add :
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar

also add :
[webutil]

WebUtilArchive=frmwebutil.jar,jacob.jar,frmall.jar
archive=frmwebutil.jar,frmall.jar
lookAndFeel=oracle

7) Modify Oracle_Home\forms\server\webutil.cfg and add :
transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE

8)rename webutil.pll to webutil_lib.pll

8) Start the OC4J instance

9) Start Forms Builder and connect to a schema in the RDBMS used in step (4).
Open webutil.pll, do a “Compile ALL” (shift-Control-K), and generate to PLX (Control-T).
It is important to generate the PLX, to avoid the FRM-40039 discussed in
Note 303682.1
If the PLX is not generated, the Webutil.pll library would have to be attached with
full path information to all forms wishing to use WebUtil. This is NOT recommended.

10) Create a new FMB.
Open webutil.olb, and Subclass (not Copy) the Webutil object to the form.
There is no need to Subclass the WebutilConfig object.
Attach the Webutil.pll Library, and remove the path.
Add an ON-LOGON trigger with the code
NULL;
to avoid having to connect to an RDBMS (optional).
Create a new button on a new canvas, with the code
show_webutil_information (TRUE);
in a WHEN-BUTTON-PRESSED trigger.
Compile the FMB to FMX, after doing a Compile-All (Shift-Control-K).

11) Under Edit->Preferences->Runtime in Forms Builder, click on “Reset to Default” if
the “Application Server URL” is empty.
Then append “?config=webutil” at the end, so you end up with a URL of the form
http://server:port/forms/frmservlet?config=webutil

aritcle source : http://lyh7609.iteye.com/blog/423373