Friday, January 23, 2009

Forms Server (frmsrv) crashing

Hi,

We were in the process of setting up a new instance by way of cloning. The apps version was 12.0.4 and database was 10.2.0.3 on linux. After the cloning process was complete, the services were started. We have configured the forms server in socket mode. The adformsrvctl.sh would start the forms server executable (frmsrv) but any connections would fail with FRM 92050. The forms executable would crash without leaving any messages in socket.log. No errors logged elsewhere too. The issue was with the library file libXm.so.2. This is apparently a motif file and I am not sure which rpm brings this in.

Troubleshooting tips:

1. set the environment
2. manually start the forms server with the following command
frmsrv host hostname port 9091 pool 1 exe frmweb log /apps/local/Instance_Name/inst/apps/INSTANCENAME_ServerNAME/logs/ora/10.1.2/forms/socket.log
3. The above command will throw the library could not be found error.
4. Ascertain the issue: ldd frmweb | grep 'not found'
5. The library libxm.so.2 should be made available under /usr/X11R6/lib/
6. The above path should be part of the $LD_LIBRARY_PATH
7. once the library file has been installed, relink the forms executable using the following command: make -f $ORACLE_HOME/forms/lib/ins_forms.mk install
8. Ascertain the executable is able to find the library file: ldd frmweb |grep 'not found'
9. Telnet from your desktop to the forms server (in this case on port 9091) and the frmsrv should not crash.

-Aravind Kamath Posral

No comments: