FRM-92102 Network error on forms client in AS10g

Recently, I got a complaint from my AS10g users, that they are facing frequent disconnection with the server. May be due to network distruption.

The error stack was:

FRM-92102: A network error has occurred.The Forms Client has attempted to reestablish its connection to the Server 5 time(s) without success.Please check the network connection and try again later.Details...Java Exception:oracle.forms.net.ConnectionException:500at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)at oracle.forms.net.HTTPNStream.getResponse(Unknown Source)at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)at oracle.forms.net.HTTPNStream.flush(Unknown Source)at java.io.DataOutputStream.flush(Unknown Source)at oracle.forms.net.StreamMessageWriter.run(Unknown Source)

I got an usefull hint on forums.oracle.com for the same problem.

It suggested to change the ping timeout to a higher value.

I had to do the following changes to opmn.xml under $ORACLE_HOME/opmn/conf

Find the process-type tag with id="OC4J_BI_FORMS" module-id="OC4J". Under this process-type tag, go to the category tag with the id="urlping-parameters". Replace the line

data id="/reports/rwservlet/pingserver?start=auto" value="200"

with

data id="/forms90/l90servlet" value="200"

Then, under the line

restart timeout="720" retry="2"

add:

ping timeout="300" interval="20" (as xml tag)

After doing the changes, restart the opmn.

I got this hint in

http://forums.oracle.com/forums/thread.jspa?threadID=323306&start=15&tstart=0

But, they have provided this solution for forms 9i. We have to change a few parameters according to AS10g environment.

Post your suggestions/feedback.

Determine ports used by opmn process

To determine the port values used by opmn processes, use this command:

prompt> opmnctl status -l
This also list the uid of the processes, which used to enables you to stop or restart an individual Oracle Application Server process.

Example:
prompt> opmnctl stopproc uniqueid= uid-of-particular-process

For more info:
http://download.oracle.com/docs/cd/B14099_19/core.1012/b13996/intro.htm#i1026303

  Find below few useful scripts for  Performance  Management:: # Important MOS notes for TRACING: There are several ways to trace a particul...