Tuesday, July 19, 2011

System Hangs or Errors Seen in Event Viewer or /var/log/messages for FRMWEB When Forms Session Closed Using Browser

Applicable to :

Oracle Forms - Version: 10.1.2.0.2 and later   [Release: Oracle10g and later ]
Linux x86-64

Warning or Error Message :

In /var/log/messages :
kernel: frmweb[16576]: segfault at 000000006974655e rip 00000000081d3ca9 rsp 00000000ffff9d2c error 4
(most numbers are not significant, they will likely differ on your system)
On Unix, huge core files can also be generated, possibly causing a system hang or various problems.

Reason for occurance : 

The users are closing the Forms sessions using the browser and not by using the exit mechanisms in the Forms.

Answer :
To prevent these error messages, close the Forms application normally before closing the browser.

The correct procedure to
--  Close a form   --   F4
-- Query a form  --  F11
--  Find the query  -- Ctrl + F11


If using Internet Explorer, you can pop-up a message window when users attempt to close the browser by following indications from NOTE 605327.1 - How To Trap Attempts At Closing The Parent Browser Running A Forms Application given in the oracle metalink

On Unix, setting "ulimit -c" to "0", for example before launching the "opmn" processes, will prevent writing of further "core" files. This can avoid completely the risk of a huge frmweb "core" file possibly impacting the system in case a user would close his browser without exiting Forms first:

ulimit -c 0
opmnctl startall

No comments:

Post a Comment

Oracle Database & Applications R12.2 Log file locations

Many times, we forget the path for the log files since there are too many.  Below is the list of frequently used log files which can help us...