Hide username and password while calling oracle Reports
If you have not configured reports with Oracle Single Sign-on, Oracle report server explicitly requires username and password when report is called using Web.Show_document(). Username and password is required in report calling URL, for example following method calls a reports using Web.Show_Documnet().
Web.Show_Document(‘http://domainname.com:8090/reports/rwservlet?userid=username/password@db& server=ReportsServer_1&desformat=PDF&destype=cache&report=report.rdf¶mform=yes’,’_blank’);
In above call username and password are visible in URL, causing security problem. Oracle has provieded serveral methods to resolve this problem, one of these solution is to define keymapping in CGICMD.DAT file. In Reports services 11g this file is located at following location
$DOMAIN_HOME/servers/WLS_REPORTS/stage/reports/reports/configuration/cgicmd.dat
In Oracle Reports services 10g this file can be located in reportsconf directory.
To define a key mapping, append follwing line at the end of the file
userlogin: userid=username/password@db %*
repenvp: server=report_server_name userid=username/password@sid destype=cache desformat=pdf %*
Restart reports server/Managed server, now you can call your report using following URL
Changes in formsweb.cfg file in Windows 7 64 bit
the Oracle Jinitiator is no longer supported and it based on a JRE that is over 10 years old. It is unreasonable to think this would work with a modern OS like Windows 7 64-bit. You will need to uninstall the Oracle JInitiator and install the current JRE 1.6.0_45 (32-bit). You can have both 32 and 64 bit versions of the JRE installed so your other 64 bit applications will use a 64-bit JRE.
After installing the 32-bit JRE, you’ll need to update the Oracle Developer Suite (ODS) configuration so that it will use the JRE instead of the JInitiator. You will need to modify the formsweb.cfg according to the Oracle 10gR2 Forms Services – Using Sun’s Java Plug-in white paper. Here are the basic settings you will have to change.
## Original Setting
#baseHTMLjinitiator=basejini.htm
## New Setting
baseHTMLjinitiator=basejpi.htm
# Parameter related to the version of the Java Plugin
## Original
#jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA
## New
jpi_classid=clsid:CAFEEFAC-0016-0000-0045-ABCDEFFEDCBA
## Original
#jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06
## New
jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_45
#Following setting is for Firefox.
#jpi_mimetype=application/x-java-applet
Add a OS Parameter: JAVA_TOOL_OPTIONS, and parameter value: -Djava.vendor=»Sun Microsystems Inc.» as Environment Variables
1. Open Advanced system settings
Start Menu › Control Panel › System and Security › System
2. Click Environment Variables
3. Add a System variables
Variable name: JAVA_TOOL_OPTIONS
Variable value: -Djava.vendor=»Sun Microsystems Inc.»
4. Re-log or reboot your system
Width and Height of explorer window which contains form ( Set these parametersaccording to your standards)
DEV_SUITE\forms\server\formsweb.cfg# Forms applet parameter
Form Size Setting
width=300
# Forms applet parameter
height=3501
Hide oracle window in form
#Otherparams(Not Applicable for Application Server)
Hide window tool bar at explorer.
separateFrame=true
Default Form Runtime Location (Applicable For Application Server)
# Forms runtime argument: which form module to run
form=login.fmx
# Forms runtime argument: database connection detailsuserid=olplog/olplog@olpsys2
Add a OS Parameter: JAVA_TOOL_OPTIONS, and parameter value: -Djava.vendor=»Sun Microsystems Inc.» as Java Runtime Parameter
1. Open Java Control Panel
Windows 8
Use search to find the Control Panel
Press Windows logo key + W to open the Search charm to search settings
In the search box enter Java Control Panel
Click on Java icon to open the Java Control Panel.
Windows 7, Vista
Click on the Start button and then click on the Control Panel option.
In the Control Panel Search enter Java Control Panel.
Click on the Java icon to open the Java Control Panel.
Windows XP
Click on the Start button and then click on the Control Panel option.
Double click on the Java icon to open the Java Control Panel.
Alternate method of launching Java Control Panel
In the Start Search box, type:
Windows 32-bit OS: c:\Program Files\Java\jre7\bin\javacpl.exe
Windows 64-bit OS: c:\Program Files (x86)\Java\jre7\bin\javacpl.exe
2. After the Java Control Panel opens, go to the Java tab as shown below.
The rest of the directions apply to both 32-bit and 64-bit Windows.
3. Click «View», then add -Djava.vendor=»Sun Microsystems Inc.» into the Runtime Parameter box
Uninstall your JRE 7, and re-install JRE 6 since Java 7 currently incompatible with Banner Forms
Solution 4 (advanced solution and it is not recommended for end-users): Enable EBS environments for JRE 7, refer: https://blogs.oracle.com/stevenChan/entry/java_jre_1_7_03
How to configure forms builder 10g to run form
https://sites.google.com/site/craigsoraclestuff/oracle-forms—how-to-s/forms-how-to-configure-forms-builder-to-run-forms-locally
FireFox, IE crash with Forms 10g, Replace Jinitiator with JRE
Oracle Jinitiator is no longer compatible with oracle forms services. By default, Oracle Forms services 10g uses Jinitiator 1.3.1.22 to run Forms applications. Jinitiator was compatible with Internet Explorer 6 and Firefox version 2.0. But latest internet explorer like IE 8 and 9 crash with Jinitiator. Similar behavior is seen with Firfox version 3.0 and later.
To resolve this problem, you must configure JRE to work with forms services 10g. It is really easy and requires only very little work. Forms services 10g are by default configured to run with JRE 1.4.2_06. To get this working, locate following lines in your FORMSWEB.CFG file,
# 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
Make changes as shown in bold face below.
# System parameter: default base HTML file
baseHTML=basejpi.htm
# System parameter: base HTML file for use with JInitiator client
baseHTMLjinitiator=basejpi.htm
# System parameter: base HTML file for use with Sun’s Java Plug-In
baseHTMLjpi=basejpi.htm
Make sue that following parmaments in FORMSWEB.CFG are as mentioned below.
jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html
jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA
jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06
jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06
Now install J2RE version 1.4.2_06 from following URL,
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase14-419411.html#j2re-1.4.2_06-oth-JPR
OR
you can also omit version no from following line,
jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06
after ommiting version, above line will look like following
jpi_mimetype=application/x-java-applet
Now you can use any latest JRE version. ( Thanks to S Shamji and JoeAStudent for thier comments related to version change )
Remove Jinitiator from you computer and restart OC4J instance. Now your Forms application 10g will use Sun’s Java plug-in instead of Jinitiator.
Update:
Looks like Firefox 12 does not work by omitting version no from formsweb.cfg. Instead you need to provide correct installed version.
For example, If you have jre 1.6.x installed in your system then edit following line as under.
jpi_mimetype=application/x-java-applet;jpi-version=1.6
The above line covers JRE 6 with all update levels.
If still facing problem then provide the exact version of JRE with update level as under.
jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_24
In “formsweb.cfg”, jpi_classid indicates the version of JRE. “clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA” indicates that 1.4.2_06 or any later version can be used.
Configuration for Webutil to work with JRE
——————————————————————————————————————–
For webutil to work with jre, locate following line in webutil configuration,
baseHTMLjinitiator=webutiljini.htm
Change it as under,
baseHTMLjinitiator=webutiljpi.htm
Now locate following lines,
archive_jini=frmall_jinit.jar
archive=frmall.jar
remove above two line and add following line
archive=frmall_jinit.jar,frmall.jar
I tested webutil setting on Forms [32 Bit] Version 10.1.2.0.2.
Below is my webutil configuration,
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
archive=frmall_jinit.jar,frmall.jar
lookAndFeel=oracle
Configuring Auto Download of JRE at Client
——————————————————————————————————————–
You can configure automatic download of JRE at client using following steps. In IE, it will automatically download JRE and initiates install process but in Firefox, user will be required to click on “Manual Install” button.
1- Copy required exe file in a virtual directory on forms server. You can create a new virtual directory or use an existing virtual directory. For example, you can place you .exe file in /forms/java folder
2- Edit jpi_download_page and jpi_codebase parameters as under,
jpi_download_page=http://servername:port/forms/java/jre-6u23-windows-i586.exe
jpi_codebase=http://servername:port/forms/java/jre-6u23-windows-i586.exe
Above setting is for JRE6u23.
Alternately you can also specify download location from oracle website as under,
jpi_download_page=http://java.sun.com/update/1.6.0/jinstall-6u23-windows-i586.cab
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u23-windows-i586.cab
for complete list of URL for all JRE version, visit following URL
http://java.sun.com/update/1.6.0/jinstall-6u23-windows-i586.cab
Above settings were test on Forms 10.1.2.0.2.
How to Start Report Server in Development Suite 10g in Windows xp on client not in Application Server
Start — Run — cmd — then type
rwserver server=rep_fsprod start
OR
rwserver server=rep_fsprod batch=yes autostart=yes
rep_fsprod is a name of report server.
How to create jar for icons
For this you use at best the jdk (java development kit) that is already
installed on your pc when forms is installed.
Copy all your gif-icons into one folder
open the command prompt and change to that folder.
If we assume you installed forms in the default directory, call the jar.exe like this:
This will create a jar file in the same directory.
copy the jar file into your x:\DevSuiteHome_1\forms\java folder.
Then open your formsweb.cfg in x:\DevSuiteHome_1\forms\server and under your config entry change the
to
Please check if in your formsweb.cfg if the imagebase is set to codebase.
If not, create a parameter under your config entry:
Now the the jar file is loaded when you start your application and the icons are
getting red from the jar file.
In the Start menu in windows, click RUN. Then you type this:
«REGEDIT» and hit ENTER.
Then in the tree panel in the left search the following node:
MyPc/HKey_Local_Machine/SOFTWARE/ORACLE.
Click on the oracle node and then in the edit menu click on new/string value to Add a new string value.
Name it «UI_ICON» and then set the value to «d:\icons».
UI_ICON D:\icons
UI_ICON_EXTENSION gif
THERE ARE TWO CHANGES on two files to view icon in forms 10g!
1.orion-web.xml
2.registry.dat
—————————————————————————————————
(1) first change orion-web.xml(C:\ORACLE HOME\j2ee\DevSuite\application-deployments\forms\formsweb)
copy one line(of virtual path and real path line) and paste it change it with your icon real path and virtual path is (any name)
———————————————————————————————————-
(2) on registry.dat(C:\ORACLE HOME\forms\java\oracle\forms\registry) default.icons.iconpath= then only give virtual path to (any name) which you changes in orion-web.xml
————————————————————————————————- ———
(3)in form buillder on ic0n paletle first iconic select (yes) and icon filename= (only icon name for example:tick)
and your icon is in gif format not other than that.
—————————————————————————————————————————
Example:
| 1) Find C:\oracle\ora9i\forms90\java\oracle\forms\registry\Registry.dat, make it read-write, then edit it. Change line 89 Save the file and back it up. 2) Find C:\oracle\ora9i\j2ee\Oracle9iDS\application-deployments\forms\forms90web\orion-web.xml and edit it. Duplicate one of the ‘virtual-directory virtual-path’ lines and make it read as below: Save the file and back it up. |
Verify your placement of the ‘/’ on the two references to ‘icons’.
In Case of mine, the folder name is icons which contains gif files and the jar file name is icons.
I have placed the gif folder on root directory c:\icons and jar file on C:\DevSuiteHome_1\forms\java
—————————————————
Registry.dat:
C:\DevSuiteHome_1\forms\java\oracle\forms\registry
default.icons.iconpath=icons/
default.icons.iconextension=gif
—————————————————
D:\DevSuiteHome_1\j2ee\DevSuite\application-deployments\forms\formsweb\orion-web.xml:
copy last line of virtual-directory and past it below the line which has been copied then change it as.
—————————————————
default.env:
C:\DevSuiteHome_1\forms\server
FORMS_PATH=C:\FDesk;C:\FDesk\FOF;C:\FDesk\Setup;C:\HR;C:\Restaurant;C:\icons
—————————————————
formsweb.cfg:
C:\DevSuiteHome_1\forms\server
Find image with Ctrl+F and change as
Find archive with Ctrl+F and change as
archive_jini=frmall_jinit.jar,icons.jar
archive=frmall.jar,icons.jar
—————————————————
forms.conf:
C:\DevSuiteHome_1\forms\server
AliasMatch ^/forms/java/icons/(..*) «C:\DevSuiteHome_1/forms/java/icons/$1»
—————————————————
Run>regedit (Oracle Register)
Give path as a value of FORMS_PATH of all folders which you are using for the under developing application at the end of path already given.
FORMS_PATH=C:\FDesk;C:\FDesk\FOF;C:\FDesk\Setup;C:\HR;C:\Restaurant;C:\icons
UI_ICON=C:\icons
UI_ICON_EXTENSION=gif
Now iconic property of the push button is yes and icon filename is only gif filename without extension.
FRM-92101 there was a failure in the forms server during startup
Hi ,
Recently i encountered a form Error
FRM-92101 there was a failure in the forms server during startup while opening the forms 10G using forms URL . This was happening randomly . Initially I thought it was a Oracle database max session error because during the problem i seen after some fix no of sessions it was happening but not all the time.
Finally i got the initial solution on internet then later from our DBA .The problem was with windows 2003 server . Here is the Solution.
1. Go to Application server open Run> Services.msc>OracleFRHome1ProcessMangerService
2.Right click on Service select properties.
3.Click on LogOn Tab.
4.Select checkbox “Allow Service to Entract with Desktop”
5.Close Properties and Sercvies Window.
6. Goto Run>regedit>HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\
7. Click on Right Hand Side Key window and Create New String Value
Name =SharedSection , Value =1024,3072,1024
8.Close the Registry Editor .
9. Restrart the server.
Note : This solution is for Forms 10 G Application Server Running on Windows 2003 Enterprise Edition.
To run .fmx file without application server installed
Go through the basics of deploying forms
You have to add your Folder where you kept your .fmx/.mmx,/plx files to FORMS_PATH variable in default.env
Or create a config section in formsweb.cfg file
run the Form using browser
http://machinename:port/forms/frmservlet?configname
or
http://machinename:port/forms/frmservlet?form=formname&userid
Creating a Customized Sign-on Form
Figure 2.8. A customized sign-on form.
Figure 2.9. This alert message is displayed in the case of an invalid username or password.
The code for the procedure p_show_alert is as follows:
