Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error running form with webutil configuration in 11g

Tony007Feb 6 2018 — edited Feb 6 2018

hi am in form 11gR2 am having webutill after following webutil configuration when running form this is the error

this is mu url http://hostname:9001/forms/frmservlet?form=WEBUTIL_DEMO.fmx&config=webutil

demoerror.jpg

my env file is

# default.env - default Forms environment file, Windows version

#

# This file is used to set the Forms runtime environment parameters.

# If a parameter is not defined here, the value used will be that defined

# in the environment in which the WLS Managed Server was started.

#

# NOTES

Configuration assistant will replace all the macro's with

the actual values.

#

ORACLE_HOME=C:\Oracle\Middleware\FRHome

ORACLE_INSTANCE=C:\Oracle\Middleware\asinst

#

#

# TNS Entry to locate the database

#

TNS_ADMIN=C:\Oracle\Middleware\asinst\config

#

#

# Search path for Forms applications (.fmx files, PL/SQL libraries)

#

FORMS_PATH=C:\Oracle\Middleware\FRHome\forms;C:\Oracle\Middleware\asinst\FormsComponent\forms

#

#

# Webutil config file path

#

WEBUTIL_CONFIG=C:\Oracle\Middleware\asinst\config\FormsComponent\forms\server\webutil.cfg

#

#

# Disable/remove this variable if end-users need access to the query-where

# functionality which potentially allows them to enter arbitrary SQL

# statements when in enter-query mode.

#

FORMS_RESTRICT_ENTER_QUERY=TRUE

#

#

# Java class path

This is required for the Forms debugger

You can append your own Java code here)

# frmsrv.jar and ldapjclnt11.jar are required for

# the password expiry feature to work(2213140).

#

CLASSPATH=C:\Oracle\Middleware\FRHome\forms\j2ee\frmsrv.jar;C:\Oracle\Middleware\FRHome\jlib\ldapjclnt11.jar;C:\Oracle\Middleware\FRHome\jlib\debugger.jar;C:\Oracle\Middleware\FRHome\jlib\ewt3.jar;C:\Oracle\Middleware\FRHome\jlib\share.jar;C:\Oracle\Middleware\FRHome\jlib\utj.jar;C:\Oracle\Middleware\FRHome\jlib\zrclient.jar;C:\Oracle\Middleware\FRHome\reports\jlib\rwrun.jar;C:\Oracle\Middleware\FRHome\forms\java\frmwebutil.jar;C:\Oracle\Middleware\FRHome\jlib\start_dejvm.jar;C:\Oracle\Middleware\FRHome\opmn\lib\optic.jar;C:\Oracle\Middleware\FRHome\forms\java\frmall.jar

#

#

# The PATH setting is required in order to pick up the JVM (jvm.dll and

# java.exe).

# Since PATH is being set, it needs to also include

# %ORACLE_HOME%\bin so relevant files are correctly found.

#

PATH=C:\Oracle\Middleware\FRHome\bin;C:\Oracle\Middleware\FRHome\jdk\jre\bin\client;C:\Oracle\Middleware\FRHome\jdk\bin

#

#

# Settings for Forms tracing and logging

# -----------------------------------------------

# Note: By default tracing and logging directory is

# ORACLE_INSTANCE\FormsComponent\forms\trace

# To change the trace directory this entry has to be uncommented and set to

# desired directory for tracing and logging

#

#

#FORMS_TRACE_DIR=%ORACLE_INSTANCE%\FormsComponent\forms\trace

#

#

# Settings for Javascript events

# -----------------------------------------------

# Note: If this variable is set to false then the triggers and

# built-ins associated with javascript events are disabled

#

#

#FORMS_ALLOW_JAVASCRIPT_EVENTS=

#

#

#

# System settings

# ---------------

# You should not normally need to modify these settings

#

FORMS=C:\Oracle\Middleware\FRHome\forms

mywebutil cfg is

# ---------------------------------------------------------------------------

# webutil.cfg - WebUtil default configuration file

# ---------------------------------------------------------------------------

# This file provides all of the configuration settings for webutil. These are

# divided into the following sections:

# 1. Logging Options

# 2. Installation Options

# 3. File Upload and Download Options

# 1. Server Side Logging Options for logging errors and log messages

# You must set logging.enabled to true to allow mid-tier logging. Without this

# mid-tier logging will not take place no matter what PL/SQL or URL options

# are supplied to switch it on. Once logging is enabled the other settings come

# into play.

# Details

# -------

logging.file : Defines the file name and location of the log file.

Note that WebUtil does no log file management. You may

need to manually clean this file up from time to time.

logging.enabled : Can be TRUE or FALSE

logging.errorsonly : Can be TRUE or FALSE. Setting to true will ensure that

only errors and not normal informational log messages

are written to the log file. For product use this would

normally be set to TRUE

logging.connections: Can be TRUE or FALSE. Setting to true will cause each

connection from a client using WebUtil to write into

the log as it sets up.

logging.file=

logging.enabled=FALSE

logging.errorsonly=FALSE

logging.connections=FALSE

# 2. Installation Options

# WebUtil needs to download some files to the client in order to perform

# certain integration operations such as OLE or Registry Access. These files

# are downloaded to the client when webutil is being run for the first time.

# Subsequent runs will use the cached dll. You have to define the location of

# these files on the server and the location on the client.

# Here is a table that shows various numeric constants and their meanings. They

# are used in the install options configurations. These constants are defined

# in WEBUTIL_CORE package spec. Note that the Client OS Processor Architecture

# is typically the architecture of the JVM that will be running on the client,

# not necessarily same as the actual client OS architecture.

#

# <os> - Client OS Family <arch> - Client OS Processor Architecture

0 - Windows 0 - 32 bit architecture

1 - Linux 1 - 64 bit architecture

2 - SOLARIS

3 - HP

4 - AIX

5 - Mac

9 - Unknown

# <package> - Package Name

7 - WEBUTIL_OLE2

9 - WEBUTIL_C_API

# We don't yet have downloads for other packages. If there is a need, refer

# WEBUTIL_CORE package spec for the constants of other packages

# Details

# -------

NOTE: For all settings <arch> field is optional. Without this field, the

setting will be applicable for both 32 bit and 64 bit client OS (JVM)

architectures.

install.syslib.location.<os>.<arch> :

The virtual path to the directory holding the webutil library files on the

server side. This must either be an absolute URL or a URL that is relative

to the documentbase.

NOTE: <os> field is optional for this setting. In the absence of a setting

that has the matching client OS and ARCH, it will use

install.syslib.location. <arch> cannot be specified if <os> is omitted.

install.syslib.location.client.<os>.<arch> :

The path to the directory on the client machine where webutil library

files will be downloaded. This must either be an absolute path or a path

that is relative to client user profile or HOME. Directory will be created

if necessary along with other required parent directories. If the path is

not set, it will be treated as a special case where libraries will be

downloaded to client JRE\bin (windows) or JRE/lib (unix). If this

directory is changed, all the libraries will be redownloaded again.

Please keep in mind that other Forms server could also have a similar

location setting and thus libraries could be overwritten when the same

client runs webutil from different forms server. It is therefore

advisable that the location has a subdirectory that can be unique to your

server, such as server host name. You could use $(SERVERHOST) in the

location. This string will be replaced with the actual server host name

install.syslib.<os>.<arch>.<package>.<n> :

The name(s) of the libraries required for particular webutil beans. The

format of this is name|size|version|showDownloadDialog. Multiple libraries

can be downloaded per package. But ensure that the <n> values are

consecutive and start at 1 for a given os, arch and package set.

install.syslib.location=/webutil

install.syslib.location.0.0=/webutil/win32

install.syslib.location.0.1=/webutil/win64

# Add/change the following if you want to specify a different client location

# where the syslib libraries can be downloaded.

# Format:

# install.syslib.location.client.<os>.<arch>=<location>

install.syslib.location.client.0.0=webutil\syslib\$(SERVERHOST)\win32

install.syslib.location.client.0.1=webutil\syslib\$(SERVERHOST)\win64

# Change size and version if necessary, like when upgrading the library.

# Normally this would not be required since most of these libraries come with

# install itself. Jacob however does not come with install

# Format:

# install.syslib.<os>.<arch>.<package>.<n>=name|size|version|showDownloadDialog

install.syslib.0.0.7.1=jacob-1.14.3-x86.dll|102400|1.14.3|true

install.syslib.0.1.7.1=jacob-1.14.3-x64.dll|117760|1.14.3|true

install.syslib.0.0.9.1=JNIsharedstubs.dll|45056|1.0|true

install.syslib.0.1.9.1=JNIsharedstubs.dll|58368|1.0|true

install.syslib.0.0.9.2=d2kwut60.dll|81920|1.0|true

install.syslib.0.1.9.2=d2kwut60.dll|102400|1.0|true

# You can also add your own libraries in here, e.g.

#install.syslib.0.0.user.1=testwebutil.dll|204872|1.0|true

#install.syslib.0.0.user.1=ffisamp.dll|40960|1.0|true

#install.syslib.0.1.user.1=ffisamp.dll|35328|1.0|true

# 3. Upload / Download options

# For the file upload and download options you can define the default locations

# on the server that webutil can use as a work area. Optionally you can switch

# upload and download off

# Details

# -------

transfer.database.enabled : Can be TRUE or FALSE - allows you to enable or

disable upload and download from the database

server.

transfer.appsrv.enabled : Can be TRUE or FALSE - allows you to enable or

disable upload and download from the

application server.

transfer.appsrv.workAreaRoot: The root of the location in which WebUtil can

store temporary files uploaded from the client.

If no location is specified, application server

user_home/temp will be assumed.

This location is always readable and writable

no matter what the settings in

transfer.appsrv.* are. This setting is

required if you need the Client side

READ/WRITE_IMAGE_FILE procedures.

transfer.appsrv.accessControl:Can be TRUE or FALSE - allows you to indicate

that uploads and downloads can only occur from

the directories named in the

transfer.appsrv.read.n and

transfer.appsrv.write.n entries and their

subdirectories. If this setting is FALSE,

transfers can happen anywhere.

transfer.appsrv.read.<n>: List of directory names that downloads can read

from.

transfer.appsrv.write.<n>: List of directory names that uploads can write

to.

#NOTE: By default the file transfer is disabled as a security measure

transfer.database.enabled=TRUE

transfer.appsrv.enabled=TRUE

transfer.appsrv.workAreaRoot=/uploadedfiles

transfer.appsrv.accessControl=TRUE

#list transfer.appsrv.read.<n> directories

transfer.appsrv.read.1=/uploadedfiles

#list transfer.appsrv.write.<n> directories

transfer.appsrv.write.1=/uploadedfiles

# 4. Others

# Details

# -------

# BlockAllowHeartBeat : To continue the heart beat communication with the

server when set to TRUE. By default the value is

set to False. When False there would not be heart

beat communication in blocking mode.

BlockAllowHeartBeat=False

am also geting this error

blockweb.jpg

i did sign webutil

C:\Oracle\Middleware\asinst\bin>sign_webutil.bat C:\Oracle\Middleware\FRHome\forms\java\jacob.jar

WARNING:

Self-signing Jar files is no longer recommended.

Jar files should be digitally signed using a trusted certificate.

Generating a self signing certificate for key=webutil2...

...successfully done.

.

Backing up C:\Oracle\Middleware\FRHome\forms\java\jacob.jar as C:\Oracle\Middleware\FRHome\forms\java\jacob.ja

r.old...

    1 file(s) copied.

Signing C:\Oracle\Middleware\FRHome\forms\java\jacob.jar using key=webutil2...

...successfully done.

C:\Oracle\Middleware\asinst\bin>sign_webutil.bat C:\Oracle\Middleware\FRHome\forms\java\frmwebutil.jar

WARNING:

Self-signing Jar files is no longer recommended.

Jar files should be digitally signed using a trusted certificate.

Generating a self signing certificate for key=webutil2...

keytool error: java.lang.Exception: Key pair not generated, alias <webutil2> already exists

.

There were warnings or errors while generating a self signing certificate. Please review them.

.

Backing up C:\Oracle\Middleware\FRHome\forms\java\frmwebutil.jar as C:\Oracle\Middleware\FRHome\forms\java\frm

webutil.jar.old...

    1 file(s) copied.

Signing C:\Oracle\Middleware\FRHome\forms\java\frmwebutil.jar using key=webutil2...

...successfully done.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2018
Added on Feb 6 2018
6 comments
1,318 views