?
Solved

Run Oracle Forms 11g

Posted on 2010-11-16
7
Medium Priority
?
52,157 Views
Last Modified: 2015-01-05
Hi,

I have Web Logic Server,  Forms/Reports 11g all installed on my PC with XP.
I created a hello.fmb and generated hello.fmx on my c:\temp

How to run this form?
    What services need to be started 1st?
    What URL to use ?
    Can I run the form in developer without browser?

Thanks,
Luchuan
0
Comment
Question by:luchuanc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 13

Accepted Solution

by:
sonicefu earned 2000 total points
ID: 34151848
Hi,


There are two ways to run it

1- edit ORACLE_HOME/forms/server/formsweb.cfg file and create an entry for your forms at the end of file, for example "test" then you'll call your forms


http://YourServerName:7777/forms/frmservlet?config=test

2- call the form directly

http://YourServerName:7777/forms/frmservlet?form=c:\temp\hello.fmx
## Sample formsweb.cfg

[default]
# System parameter: default base HTML file
baseHTML=base.htm
# System parameter: base HTML file for use with JInitiator client
baseHTMLjinitiator=basejini.htm
# System parameter: base HTML file for use with Sun's Java Plug-In
baseHTMLjpi=basejpi.htm
# System parameter: delimiter for parameters in the base HTML files
HTMLdelimiter=%
# System parameter: working directory for Forms runtime processes
# WorkingDirectory defaults to <oracle_home>/forms if unset.
workingDirectory=
# System parameter: file setting environment variables for the Forms runtime processes
envFile=default.env
# Forms runtime argument: whether to escape certain special characters
# in values extracted from the URL for other runtime arguments
escapeparams=true
# Forms runtime argument: which form module to run
form=test.fmx
# Forms runtime argument: database connection details
userid=treasury/tisnic@orcl
# Forms runtime argument: whether to run in debug mode
debug=no
# Forms runtime argument: host for debugging
host=
# Forms runtime argument: port for debugging
port=
# Other Forms runtime arguments: grouped together as one parameter.
# These settings support running and debugging a form from the Builder:
otherparams=buffer_records=%buffer% debug_messages=%debug_messages% array=%array% obr=%obr% query_only=%query_only% quiet=%quiet% render=%render% record=%record% tracegroup=%tracegroup% log=%log% term=%term%
# Sub argument for otherparams
buffer=no
# Sub argument for otherparams
debug_messages=no
# Sub argument for otherparams
array=no
# Sub argument for otherparams
obr=no
# Sub argument for otherparams
query_only=no
# Sub argument for otherparams
quiet=yes
# Sub argument for otherparams
render=no
# Sub argument for otherparams
record=
# Sub argument for otherparams
tracegroup=
# Sub argument for otherparams
log=
# Sub argument for otherparams
term=
# HTML page title
pageTitle=Oracle Application Server Forms Services
# HTML attributes for the BODY tag
HTMLbodyAttrs=
# HTML to add before the form
HTMLbeforeForm=
# HTML to add after the form
HTMLafterForm=
# Forms applet parameter: URL path to Forms ListenerServlet
serverURL=/forms/lservlet
# Forms applet parameter
codebase=/forms/java
# Forms applet parameter
imageBase=DocumentBase
# Forms applet parameter
width=750
# Forms applet parameter
height=600
# Forms applet parameter
separateFrame=false
# Forms applet parameter
splashScreen=
# Forms applet parameter
background=
# Forms applet parameter
lookAndFeel=Oracle
# Forms applet parameter
colorScheme=teal
# Forms applet parameter
logo=
# Forms applet parameter
restrictedURLparams=HTMLbodyAttrs,HTMLbeforeForm,pageTitle,HTMLafterForm,log,allow_debug,allowNewConnections
# Forms applet parameter
formsMessageListener=
# Forms applet parameter
recordFileName=
# Forms applet parameter
serverApp=default
# Forms applet archive setting for JInitiator
archive_jini=frmall_jinit.jar
# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
archive=frmall.jar
# Number of times client should retry if a network failure occurs.  You should
# only change this after reading the documentation.
networkRetries=0
# Page displayed to Netscape users to allow them to download Oracle JInitiator.
# Oracle JInitiator is used with Windows clients.
# If you create your own page, you should set this parameter to point to it.
jinit_download_page=/forms/jinitiator/us/jinit_download.htm
# Parameter related to the version of JInitiator
jinit_classid=clsid:CAFECAFE-0013-0001-0022-ABCDEFABCDEF
# Parameter related to the version of JInitiator
jinit_exename=jinit.exe#Version=1,3,1,22
# Parameter related to the version of JInitiator
jinit_mimetype=application/x-jinit-applet;version=1.3.1.22
# Page displayed to users to allow them to download Sun's Java Plugin.
# Sun's Java Plugin is typically used for non-Windows clients.
# (NOTE: you should check this page and possibly change the settings)
jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html
# Parameter related to the version of the Java Plugin
jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin
jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06
# EM config parameter
# Set this to "1" to enable Enterprise Manager to track Forms processes
em_mode=0
# Single Sign-On OID configuration parameter
oid_formsid=%OID_FORMSID%
# Single Sign-On OID configuration parameter
oracle_home=/u/appas/oracle/OraHome_1
# Single Sign-On OID configuration parameter
formsid_group_dn=%GROUP_DN%
# Single Sign-On OID configuration parameter: indicates whether we allow
# dynamic resource creation if the resource is not yet created in the OID.
ssoDynamicResourceCreate=true
# Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false
ssoErrorUrl=
# Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.
ssoCancelUrl=
# Single Sign-On parameter: indicates whether the url is protected in which
# case mod_osso will be given control for authentication or continue in
# the FormsServlet if not. It is false by default. Set it to true in an
# application-specific section to enable Single Sign-On for that application.
ssoMode=false
# The parameter allow_debug determines whether debugging is permitted.
# Administrators should set allow_debug to "true" if servlet
# debugging is required, or to provide access to the Forms Trace Xlate utility.
# Otherwise these activities will not be allowed (for security reasons).
allow_debug=false
# Parameter which determines whether new Forms sessions are allowed.
# This is also read by the Forms EM Overview page to show the
# current Forms status.
allowNewConnections=true
# EndUserMonitoring
# EndUserMonitoringEnabled parameter
# Indicates whether EUM/Chronos integration is enabled
EndUserMonitoringEnabled=
# EndUserMonitoringURL
# indicates where to record EUM/Chronos data
EndUserMonitoringURL=
# Example Named Configuration Section
# Example 1: configuration to run forms in a separate browser window with
# "generic" look and feel (include "config=sepwin" in the URL)
# You may define your own specific, named configurations (sets of parameters)
# by adding special sections as illustrated in the following examples.
# Note that you need only specify the parameters you want to change.  The
# default values (defined above) will be used for all other parameters.
# Use of a specific configuration can be requested by including the text
# "config=<your_config_name>" in the query string of the URL used to run
# a form.  For example, to use the sepwin configuration, your could issue
# a URL like "http://myhost.mydomain.com/forms/frmservlet?config=sepwin".
[webapp]
form=opening.fmx
lookAndfeel=generic
seperateFrame=yes
WebUtilArchive=/u/appas/oracle/OraHome_1/forms/java/frmwebutil.jar,jacob.jar
WebUtilLogging=all
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=/u/appas/oracle/OraHome_1/forms/java/frmall_jinit.jar
archive=/u/appas/oracle/OraHome_1/forms/java/frmall.jar
 
[webutil]
form=opening.fmx
lookAndfeel= generic
WebUtilArchive=/u/appas/oracle/OraHome_1/forms/java/frmwebutil.jar,/u/appas/oracle/OraHome_1/forms/java/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
envFile=default.env
 
 
 
 
[sepwin]
separateFrame=True
lookandfeel=Generic
# Example Named Configuration Section
# Example 2: configuration forcing use of the Java Plugin in all cases (even if
# the client browser is on Windows)
[jpi]
baseHTMLJInitiator=basejpi.htm
# Example Named Configuration Section
# Example 3: configuration running the Forms ListenerServlet in debug mode
# (debug messages will be written to the servlet engine's log file).
[debug]
serverURL=/forms/lservlet/debug
# Sample configuration for deploying WebUtil. Note that WebUtil is shipped with
# DS but not AS and is also available for download from OTN.

[test]
form=c:\temp\hello.fmx
lookAndfeel=generic
seperateFrame=yes
WebUtilLogging=all
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm

Open in new window

0
 

Author Comment

by:luchuanc
ID: 34152394
Hi sonicefu,

I was able to get login screen using the 2nd way. But after In entered login information, I got a kind of blank web page. There is no error message. The following is from Java console, it stoped at loading help.gif. Is this memory related (I am running this on my PC with 2 GB)? Why the form didn't load after login?

Thanks,

Luchuanr

Java Plug-in 1.6.0_22
Using JRE version 1.6.0_22-b04 Java HotSpot(TM) Client VM
User home directory = C:\Documents and Settings\luchuanc

----------------------------------------------------
c:   clear console window
f:   finalize objects on finalization queue
g:   garbage collect
h:   display this help message
l:   dump classloader list
m:   print memory usage
o:   trigger logging
q:   hide console
r:   reload policy configuration
s:   dump system and deployment properties
t:   dump thread list
v:   dump thread stack
x:   clear classloader cache
0-5: set trace level to <n>
----------------------------------------------------

Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/splash.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/oracle_logo.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/bgnd.gif
Forms Session ID is formsapp.5
The proxy host is null, and the proxy port is 0.
Native HTTP implementation is being used for the connection.
The connection mode is HTTP.
Forms Applet version is 11.1.1.3
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/frame.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/save.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/print.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/pset.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/exit.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/cut.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/copy.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/paste.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/entqry.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/exeqry.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/canqry.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/prvblk.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/prvrec.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/nxtrec.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/nxtblk.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/insrec.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/delrec.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/lockrec.gif
Loaded image: jar:http://dds-luchuanc:9001/forms/java/frmall.jar!/oracle/forms/icons/help.gif
0
 

Author Comment

by:luchuanc
ID: 34155469
Hi sonicefu,
It worked with another form!
I will try anoothe way, and I would like to leave the question open for a couple of more days.
Thanks,
Luchuan
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Closing Comment

by:luchuanc
ID: 34168106
Hi sonicefu:
I don't have time to try option2 at this moment, so I am closing the ticket now.

Thanks a lot,

Luchuan
0
 

Expert Comment

by:ashley91
ID: 35802288
Yes, you can run the form without borwser. If you are trying to run from LAN (network)

1.Share or install 6i component on workstation
OR
2. if you are running locally then (both cases)

C:\Oracle6i\BIN\ifdbg60.EXE module=C:\temo\hello debug_messages=NO

Note: its based on oracle 6i, so you might have different folder name then ORACLE6i
0
 

Expert Comment

by:ashley91
ID: 35802316
hey luchuanc:

missed one line....

-----first create a short cut of you hellp.fmb on your desktop then right click go to property put the line in target C:\Oracle6i\BIN\ifdbg60.EXE module=C:\temo\hello debug_messages=NO
0
 

Expert Comment

by:arv124
ID: 40531255
I have logon to weblogic server - We have oracle 11g installes, users  complaining system throwing them away after a very short period of time.
In oracle WLS within forms and advances  - Network retries set to Zero  - Any idea what does that mean?

Thanks in advance
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question