Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Saturday, 24 March 2012

FRM-92101 there was a failure in form Server startup

There was on error in accessing ERP Forms though all per-requisites exists on the system.

I've encountered this issue on freshly configured system.

In earlier post I've discussed about this issue:


http://appsdbaworkshop.blogspot.com/2011/02/frm-92101-there-was-failure-in-forms.html


This issue will solved only if yo will Install same version of openmotif as mentioned in Installation document. If you have higher version of rpm then its simply not going to workout.

Required version of openmotif rpm - openmotif21-2.1.30-11.EL5.i386.rpm


Actual version exists on system - openmotif22-2.2.3-18.EL5.i386.rpm


If you do not want to Install the old version of rpm and want to access the forms using the same rpm "openmotif22-2.2.3-18.EL5.i386.rpm" then this is the post/article which you're looking for :

Form error message:



Application Error log:




12/03/24 13:56:12.509 formsweb: Forms session <1> aborted: runtime process failed during startup with errors /u01/applR12/PR
ODERP/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No s
uch file or directory

12/03/24 13:56:12.510 formsweb: Forms session <1> exception stack trace:
oracle.forms.engine.RunformException: Forms session <1> failed during startup: no response from runtime process
at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletReq
uestDispatcher.java:713)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(S
ervletRequestDispatcher.java:370)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRe
questHandler.java:871)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequ
estHandler.java:453)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.ja
va:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.ja
va:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(Rel
easableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
12/03/24 14:02:56.466 formsweb: 10.1.3.4.0 Stopped



Its looking for the library file "libXm.so.2" in /usr/lib which does not exists on the server.

The rpm openmotif22-2.2.3-18.EL5.i386.rpm will deliver the higher version of library file then expected:




[root@erpappl2 lib]# ls -l libXm.so*
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so -> libXm.so.4.0.1
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so.3 -> libXm.so.3.0.2
-rwxr-xr-x 1 root root 2542828 Jun 6 2007 libXm.so.3.0.2
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so.4 -> libXm.so.4.0.1
-rwxr-xr-x 1 root root 2637260 Nov 3 2010 libXm.so.4.0.1



If we Install rpm openmotif21-2.1.30-11.EL5.i386.rpm then it will generate library libXm.so.2.


Solution:



copy library file

[root@erpappl2 root]#cd /usr/lib

[root@erpappl2 lib]#cp libXm.so.3.0.2 libXm.so.2.0.2

create link

[root@erpappl2 lib]#ln -s libXm.so.2.0.2 libXm.so.2




After modification restart your middle tiers your forms access should work as expected with no more error messages.

Happy troubleshooting :)

thanks,
Zaheer Syed

5 comments:

shaji said...

Assalamualaikum

I followed the above steps and resolve the error.Thanks for the perfect solution.

Anonymous said...

i follow the mentioned steps and finally the problem has been solved.
special thanks

Syed Zaheer said...

Hi,

Thanks for reading my blog.

Its good to know that issue has been solved :)

regards,
Syed Zaheer

Bvn Reddy said...
This comment has been removed by the author.
Anonymous said...

We are getting the same error but already libXm.so.2 exists.please suggest and it is not working after clone.

[root@host lib]# ls -l libXm.so*
-rwxrwxrwx 1 root root 332785 Sep 21 22:12 libXm.so.2

[root@host lib]# rpm -q openmotif
openmotif-2.3.3-5.el6_3.x86_64