donderdag 13 oktober 2011

Forms 11g - Windows Java client hangs with message "The application's digital signature cannot be verified."

After modifying the webconfiguration values for the paremeters "webutilArchive" and "archive", I had a very annoying problem.
When I activated the application url, I got the following popup message and I couldn't accept/deny this message.

Warning - Security
The application's digital signature cannot be verified.
Do you want to run the application?

Name:      ... 
Publisher: ... 
From:      ... 
[ ] Always trust content from this publisher. 

[Run] [Cancel]

Although, there is a checkbox in the message and 2 buttons, I couldn't do anything else than shutting down my browser through the Windows Task Manager.

There are 2 solutions for this problem:

(1) Using this sequence of jar-files for webutilArchive
webutilArchive=jacob.jar, frmwebutil.jar
More info on Oracle Support:
WebUtil Form HangsWhen Acknowledging Security Warning - The application's digital signature cannot be verified [ID 1328039.1]

(2) Applying patch 9463433 if the archive parameter is the cause of the problem
More info on Oracle Support:
Windows Java Client Hangs On Accepting Not Verified Signature Of jar Files [ID 1173365.1]

Installing Forms/Reports 11g on SUSE Linux Enterprise Server (SLES) 11 SP 1

I want to share some issues to you about installing Forms/Reports on SLES11 SP1.

* Every OUI must be executed with the -ignoreSysPrereqs option
./runInstaller -ignoreSysPrereqs
./ -ignoreSysPrereqs

More info:

* On the Oracle website, you'll find the list of rpm's that must be installed on the OS before installing the Oracle software.
In fact, they forgot 2 rpm's: gcc-32bit-4.3-62.198 and gcc43-32bit-4.3.3_20081022-11.18
If you don't install these rpm's first, you will encounter errors during the Oracle software installation.

More info:

P.S.: Like on SLES 10 (see one of my previous posts) you'll have to delete the lok- and DAT-files before starting the servers.

vrijdag 7 oktober 2011

Deassociating OID from Reports 11g

At a customer site, I faced this problem when trying to activate the showjobs-url of the reports server.
The installation was done by someone else. On the server machine (OS: Windows Server 2008 SP2), the IDM 11g Suite was first installed and then the Fusion Middleware 11g Suite. During the configuration, they associated the OID to the Reports components.
When I arrived a few months later to do some other configuration changes, the customer wanted to deassociate the link between OID and Reports. When we did the deassociation, we received this error in the showjobs-url:
REP-52266: The in-process Reports Server rep_wls_name failed to IDL:oracle/reports/RWException:1.0

In the rwserver_diagnostics.log file, we found these 2 errors:
* REP-50125 : An internal exception occurred: Could not find the key specified.
* REP-50125 : An internal exception occurred: JPS-01050: Opening of wallet based credential store failed. Reason PKI-02002: Unable to open the wallet. Check password.

We could solve this issue by commenting some tags:
(1) -> we commented the oidconnection-tag
(2) rwserver.conf -> we commented the security-tag

After that, we stopped our environment and restarted all the processes. Result: everything worked fine!

donderdag 6 oktober 2011

Maximum Number Of Open Files (Soft/Hard) on Linux when installing Forms/Reports 11g

One of the prerequisite checks during the installation is verifying the maximum number of open files.
By default this is, both for hard and soft nofile, 1024.
These values can be retrieved by executing these commands;
for hard number of files:
ulimit -Hn
for soft number of files:
ulimit -Sn
The returned values are applicable for the current user.

At least, for the user who executes the installer, these values must be 4096.

The user root can apply a different value for each user separately or for all users.
This can be done by modifying the file "/etc/security/limits.conf".
For example, if the user "oracle" executes the installer, these lines must be added to the file at the end:
oracle soft nofile 4096
oracle hard nofile 4096