Oracle Forms 11g Configuration / log Files

formsweb.cfg
DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config

default.env

DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config

base(jpi).htm

DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config

registry.dat
DOMAIN_HOME/config/FormsComponent/forms/registry/oracle/forms/registry

frmweb.res
UNIX:

ORACLE_INSTANCE/config/FormsComponent/forms/admin/resource/

Windows:

ORACLE_INSTANCE/config/FormsComponent/forms

jvmcontroller.cfg

ORACLE_INSTANCE/config/FRComponent/frcommon/tools/jvm/

forms_ohs.conf

ORACLE_INSTANCE/config/OHS/ohs1/moduleconf


WLS_FORMS.log
DOMAIN_HOME/servers/WLS_FORMS/logs

WLS_FORMS.out
DOMAIN_HOME/servers/WLS_FORMS/logs

Forms trace files
ORACLE_INSTANCE/FormsComponent/forms/trace

Listener Servlet logs
DOMAIN_HOME/servers/WLS_FORMS/logs

cauprefs.ora 11g

Two Changes to do in 64 bit environmet in:
C:\Oracle\MW\FRinst\config\FRComponent\frcommon\tools\admin\cauprefs.ora

1. Change the values of the attributes to:

• Reports.root_x = 0
• Reports.root_y = 0

2. Change the attribute:

• Reports.PluggableDataSourceFactories = ()

Open reports job - excel, delimeted ...

web.show_document(v_server_url || '/reports/rwservlet/getjobid' || v_jobid || '?server=' || :GLOBAL.rp2rroReportServer || '&mimetype=application/vnd.ms-excel', '_blank');

Oracle Forms 11g R2 Installation Win64, Getting Ready

Steps to prepare the machine:


Install:
    Notepad++
    WinZip / WinRAR / 7Zip
Define TEMP / TMP environment variables
Make Sure PATH have no spaces or ()


Enable UAC:

1. Run secpol.msc from the command prompt.
2. Select Security Settings > Local Policies > Security Options.
3. Set the User Account Control:Run all Administrator in Admin Approval Mode option to enabled.
4. Restart the host.

Download those files (login to OTN and Metalink first):
Install JDK64

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

Weblogic 10.3.6
http://www.oracle.com/technetwork/middleware/ias/downloads/wls-main-097127.html

Forms 11.1.2.2
http://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html
Windows (64-bit)


WebUtil:
How to Configure Webutil in Forms 11g
Jacobe for 11g: 
http://sourceforge.net/projects/jacob-project/files/jacob-project/1.14.3/jacob-1.14.3.zip/download

sign_webutil.bat: jarsigner: attempt to rename ... failed

Try to close the Forms Builder.

Weblogic EM timeout

In the Console:
"Domain Structure" box ->
  "em" ->
    "Configuration" tab ->
        "Session Timeout (in seconds):" = set the value as you like.
Save
"OK" in the "Save Deployment Plan" page
Activate Changes

Enable the next-generation Java Plug-in

In most cases it is best to deSelect the "Enable the next-generation Java Plug-in" check-box at the Java control panel -> Advaned Tab -> Java Plug-in -> Enable the next-generation Java Plug-in

You can do it automatically:

"C:\Program Files\Java\jre6\bin\ssvagent.exe" -high -jpisetup –old

or revert it back by:

"C:\Program Files\Java\jre6\bin\ssvagent.exe" -high -jpisetup –new

The application's digital signature cannot be verified

Walkaround:

1) Import the certificate into the user repository

• Accept the message on one PC 
• Copy "trusted.certs" (C:\Documents and Settings\\Application Data\Sun\Java\Deployment\security)  
• Paste in all profiles on the new PC's

Warning... will overwrite content that individuals may have added to their certificate repository. 

2) Import the certificate into the browser repository

• Accept the message on one PC  
• Launch the java control panel -> security tab -> certificates button
• Select the certificate & Export the certificate as .cer
• In the problematic PC Import the certificate into the browser repository:  Internet Explorer -> Tools -> Content -> Certificates -> Trusted Publishers -> Import. 

3) Sign jar files using a known 'trusted' certificate signing authority. 

See Note 1207184.1 Enhanced Signing of Oracle E-Business Suite JAR Files in Oracle Support





4) Change the order of the JAR files


A workaround is to change the order of the jar files listed in webutilArchive parameter in the formsweb.cfg file. Ensure jacob.jar is listed before frmwebutil.jar. (Please let me know if it worked)

Java has discovered application components that could indicate a security concern

Here is where I went wrong, maybe you can benefit:

I had an icon.jar file and I needed to add one more icon so I just went and used winrar without thinking.

What you need to do is to use the jar command to wrap up the file:

JAVA_HOME\bin\jar cvf icnFileName.jar *.gif


Don't forget to resign the file.

Tracing A Forms User

Tracing A Forms User 10g - quick and dirty

Let the user run the regular link + record=forms&tracegroup=0-199
ie:
http://machine:port/forms/frmservlet?config=myConfig&record=forms&tracegroup=0-199

You will get a trace file in the following location:

%ORACLE_HOME%\forms\trace\forms_xxx.trc where xxx is the forms session ID.


Open CMD window and do the following:

set ORACLE_HOME=[oracle home location]

set PATH=%ORACLE_HOME%\jdk\bin;%PATH%

set CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.zip;%ORACLE_HOME%\forms\java\frmxlate.jar

java oracle.forms.diagnostics.Xlate datafile=%ORACLE_HOME%\forms\trace\forms_xxx.trc outputfile=%ORACLE_HOME%\forms\trace\html_xxx.html outputclass=WriteOutHTMLoutputclass parameter:
WriteOutHTML = HTML output

WriteOut = XML output

you will get a file html_xxx.html in your %ORACLE_HOME%\forms\trace directory.

In grater details:

http://docs.oracle.com/cd/B25016_04/doc/dl/web/B14032_03/tracing.htm#i1012933

ShowJobs parameters for Oracle Reports

ShowJobs parameters for Oracle Reports

http://[serverName]/reports/rwservlet/showjobs?queuetype=past&count=100000&startrow=0&statusformat=xml

/reports/rwservlet/showjobs[n] - The refresh number n is optional. When it is specified, the report's queue status will be updated every n seconds.

[?]

[server=server_name]

[&authid=username/password]

[&queuetype={current|past|future}]

[&startrow=start_position_in_job_queue]

[&count=number_of_jobs_to_display]

[&statusformat={html|xml|xmldtd}]

Separate the Java client instances

Those parameters will separate the Java client instances so that they will not depend on each other:

[PARAM NAME="separate_jvm" value="true"]

separate_jvm="true"

Oracle forms Fonts explained

Oracle forms Fonts explained:
http://docs.oracle.com/javase/1.3/docs/guide/intl/addingfonts.html

Oracle Forms Hierarchical Tree

 SELECT 1, LEVEL, last_name ||' '|| first_name , '', employee_id
   FROM employees
  START WITH manager_id IS NULL
CONNECT BY PRIOR employee_id = manager_id

Select 5 columns:
I -    Status (0, 1)
II -   Hierarchical Level (Oracle LEVEL pseudo column)
III -  Label
IV -  Icon file name (or null)
V -   Value

Get the new frmwebutil.jar after 10.1.2.3 patch

Find the patch instalation directory


open CMD and go to:
[patchDir]\Disk1\stage\Patches\oracle.developer.forms.builder\10.1.2.3.0\1\DataFiles

run:
[$ORACLE_HOME$]\jdk\bin\jar xf webutil2.2.jar frmwebutil.jar

rename frmwebutil.jar0 to frmwebutil.jar

backup:
[$ORACLE_HOME$]\forms\java\frmwebutil.jar

copy the new frmwebutil.jar from
[patchDir]\Disk1\stage\Patches\oracle.developer.forms.builder\10.1.2.3.0\1\DataFiles
to
[$ORACLE_HOME$]\forms\java\

in the CMD go to:
[$ORACLE_HOME$]\jdk\bin

make sure to take down the apps server (using the EM)

run:
[$ORACLE_HOME$]\forms\webutil\sign_webutil.bat [$ORACLE_HOME$]\forms\java\frmwebutil.jar

restart the app server

Change ias_admin password

Open file in:

%ORACLE_HOME%\sysman\j2ee\config

file name:

jazn-data.xml

find: ias_admin credentials

Make sure you put ! befor the new password.

Restart the EM:

%ORACLE_HOME%\bin\emctl stop iasconsole

%ORACLE_HOME%\bin\emctl start iasconsole

Find Bind Data

10g:
SELECT sql_text, NAME, value_string, datatype_string
FROM v$sql_bind_capture
JOIN v$sql
USING (hash_value)
WHERE sql_text LIKE '%select *%';

ClientDPI

ClientDPI

Specifies the dots per inch (DPI) and overrides the DPI setting returned by the JVM, allowing you to manage varying DPI settings per platform. For example, a form developed on the Win32 platform may not display properly on the UNIX platform due to varying DPI values. The clientDPI value can be any positive integer. Oracle recommends that you use an integer between 50 and 200.

Remove an Oracle Reports server

Assume %OMH% is Oracle Middle Tier Home

Go to %OMH% /sysman/emd

Open file targets.xml for editing.

Check for [Target] tag where its attribute "NAME" should matches as follows:
“[ias_instance_name]_Reports_Server: [reports_server_to_be_removed]”
In our example it is oracleas.dbserver_Reports_anand
Where
"oracleas.dbserver" is ias_instance_name
"anand" is reports server name
Select from Starting Tag [Target..] to ending tag [/Target] and delete selected lines.
[Target TYPE=”oracle_repserv” NAME=”[ias_instance_name]_Reports_Server: [reports_server_to_be_removed]” …]…[/Target]

Save and Close targets.xml file.

Now open console and go to %OMH%/dcm/bin

Give following commands to update and resync console with new configuration:

1. dcmctl updateconfig -ct opmn -v -d
2. dcmctl resyncinstance -v -d

Once done without any error, go to %OMH%/bin
Give following commands to restart the console:

1. emctl stop iasconsole
2. emctl start iasconsole
That's it, Report Server is removed now!

You can also delete from:
ORACLE_HOME/opmn/conf/opmn.xml
the:
ias-component id="MyRepServerName" .....

Create a New Report Server

%OMH% = Oracle Middle Tier Home
Open command prompt:
C:\>rwserver server=%newreportserver_name% start
Shut down the opmn:
C:\>%OMH%\opmn\bin\opmnctl stopall
Add new server target to opmn.xlm
C:\>%OMH%\bin\addNewServerTarget.bat %newreportserver_name%
The DOS window will close automatically.

Open command prompt again:

Update the config with new settings
C:\>%OMH%\dcm\bin\dcmctl.bat updateconfig -ct opmn -v -d
C:\>%OMH%\dcm\bin\dcmctl.bat resyncinstance -v -d
Close the report server window if it's opened

Start the opmnC:\>%OMH%\opmn\bin\opmnctl startall