Tuesday, December 2, 2014
How to solve Oracle Forms timeout parameters (or should I say FORMS_TIMEOUT) FRM-92102 – A network error has occured
Besides the above timeout parameters there are additional reasons that forms maybe disconnecting that are not timeout based but network related. Ususally they are prefaced by error . This parameter specifies the number of times the Forms client should try reconnecting to the middle-tier before finally timing out. The Oracle Forms network connection to the server is a little picky it does not like being ignored. So as such if it tries to reach the server more than 5 times without response it dies. Although this would seem logical most of the time 5 seconds is just too little if we take into consideration that there maybe database performance issues or network waits.
To add tolerance to Forms patience thay have added a great parameter called ‘networkRetries’ to the forms configuration file $ORACLE_HOME/forms/server/. Set the value of the networkretries parameter to a suitable number according your network characteristics needed. For example, networkRetries=30. If the error continues to occur even after setting up an appropriate value for networkRetries, you should check firewall and proxies that maybe blocking the applications server ports.