Solved

Run Oracle Forms 11g

Posted on 2010-11-16
7
39,293 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
7 Comments
 
LVL 13

Accepted Solution

by:
sonicefu earned 500 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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now