How to setup Webutil for forms 11g R1 (11.1.1.2.0)

Notes:
– frmwebutil.jar already exists/is signed on 11g
– tested with JRE version 1.6.0_25, webutil 1.0.6, jacob 1.10.1_b17
– windows 7, 32bit

1. Download webutil_1.0.6  (or from oracle’s index page) and jacob_1.10.1_b17 (or from project page) jar files.

2. Copy files:
=========
path = c:\Oracle\Middleware\as_1\forms\java
[text]d2kwut60.dll
ffisamp.dll
forms_base_ie.js
forms_ie.js
frmwebutil.jar
jacob.dll
jacob.jar
JNIsharedstubs.dll
sign_webutil.bat[\text]

*Create a folder “server” under forms\:
path = c:\Oracle\Middleware\as_1\forms\server\
[text]base.htm
basejpi.htm
forms.conf.backup
ftrace.cfg
webutil.cfg
webutilbase.htm
webutiljini.htm
webutiljpi.htm[/text]

*May also need the following folder:
path = c:\Oracle\Middleware\as_1\forms\webutil\
[text]d2kwut60.dll
ffisamp.dll
jacob.dll
JNIsharedstubs.dll
sign_webutil.bat[/text] (more…)

How to change the Look and Feel of Oracle Forms 11g

C:\Oracle\Middleware\user_projects\domains\<domain_name>\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_11.1.1\config\formsweb.cfg

[text][sepwin]

lookandfeel=Generic

[webutil]

lookAndFeel=windows[/text]

The change is instant, no need to reload the services.

How to set forms 11g buttons to display icons

Simple way

Copy your images to:

[text]c:\Oracle\Middleware\as_1\forms\java\[/text]

Notes:
– Icon files may not be supported.
– In case of a Java security issue when using gif images, you will need to create a jar file and sign it with oracles sign-tool (see below, point 6).
– In case you having trouble with oracle’s sign-tool, do it directly with java’s

Recommended way (more…)

How to configure a Weblogic 11g VM if moved or copied

When you move or copy a WebLogic 11g environment setup as a VM from one host PC to another, you will encounter various IP connection problems (may also be needed if you have problems debugging forms). To help make a quick fix to this problem, try this:

1. Make sure you have the following files set with your machine’s new IP:

[bash]edit C:\Oracle\Middleware\user_projects\domains\<domain_name>\servers\WLS_FORMS\
data\nodemanager\startup.properties
AdminURL=http\://<ip-address_of_pc>\:7001

C:\Oracle\Middleware\asinst_1\config\OPMN\opmn\instance.properties
adminHost=<ip-address_of_pc>

C:\Oracle\Middleware\user_projects\domains\<domain_name>\config\config.xml
//replace ip.address for every occurrence found (~ 7)[/bash]

2. Restart the machine/server

3. Start the Node Manager
Tip: tail the log file to see whether the ip-address is the correct one being used
C:\Oracle\Middleware\user_projects\domains\<domain_name>\servers\AdminServer\logs\AdminServer.log

4. Start the em “http://localhost:7001/em” to further configure the server to start forms and reports services.

5. Start the Administration Console (Weblogic Domain > select your domain > from Weblogic Domain menu select “Weblogic Administration Console” or enter the url: http://192.168.139.128:7001/console)

6. from the Change Center click on “Lock & Edit”

7. from the Domain Structure pane > Environment > Servers > click on Control tab

8. select WLS_FORMS and WLS_REPORTS > click Start to start the services

9. make sure after you start Forms Builder that “Application Server URL” in Runtime tab of Preferences is set to what your new ip-address is (i.e. http://192.168.139.128:9001/forms/frmservlet)

 

How to install Oracle Forms and Reports 11g on Windows XP 32bit

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows XP 32bit
reqs: WinXp SP2 or later, 1GB Memory,
time: Oracle Weblogic: 10 min,
Fusion Middleware: 40 min setup, 50 min config

  1. Download Weblogic Server 10.1.3.2 (11g) from here
    Tip: look for “Oracle WebLogic Server 11gR1 (10.3.2) – Package Installer” and select
    the i586 JVM installer package (about over 1/2 GB)
  2. Download Fusion Middleware – Portal, Forms, Reports and Discoverer (11.1.1.2.0) from here
    Tip: look for “Portal, Forms, Reports and Discoverer (11.1.1.2.0)” download link and select
    the i586 zip files (about 2.5 GB in chunks of ~500MB).
  3. Make sure you have at least
    • an i586 compatible CPU and Windows system
    • 1 GB of memory
    • 5 GB of free disk space for a typical install

If needed, download Java JDK 6u25 i586 (jdk-6u25-windows-i586.exe). (more…)