Friday, May 3, 2013

Forms Launching Error, After Fresh R12.1.1 Installations on Linux x86 32 bit

I faced issue while launching forms on newly installed R12.1.1 Oracle Applications.

FRM-92101:  formsweb: Forms session <1> aborted: runtime process failed during startup with errors /apps/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

While chekcing the Web Forms log file. in $LOG_HOME/ora/10.1.3/j2ee/<forms>/<forms>_<default_group_1>/application.log
 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(ServletRequestDispatcher.java:713)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java: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(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:619)


Cause:

The issue is caused by the openmotif21 package which is missing from the system.
For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is:
openmotif21-2.1.30-11.EL5.i386.rpm.

Solution:

1. Install package openmotif rpm.
For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is:
openmotif21-2.1.30-11.EL5.i386.rpm.
2. Bounce the services.(both Apps+DB)
3. now able to launch the forms.

Ref Doc: FRM-92101: Forms Server [ID 1192205.1]

Error in Installing R12.1.1 Oracle Applications in Final Step 5

Recently faced the issue while installing R12.1.1 installtion. After final steps of R12.1.1 installations, Faced the below error in Final Screenshot.

HTTP
-----
   checking URL = http://localhost.localdomain:8000
   RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page
----------
checking URL = http://localhost.localdomain:8000/OA_HTML/help
   RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory
------------------
   RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP
----
   checking URL = http://localhost.localdomain:8000/OA_HTML/jtfTestCookie.jsp
   RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page
-----------
   RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.


I checked the application installation log file(/apps/inst/apps/TEST_localhost/logs/05030038.log).the above error was there.. while again investing the log file, observed that
the autoconfig was failing. So checked the autoconfig logfile (/apps/inst/apps/TEST_localhost/admin/log/05030620/adconfig.log), The below error was found.

[CVM Error Report]
The following report lists errors encountered during CVM Phase
      <filename>  <return code where appropriate>
  /apps/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl  -1
No of scripts failed in CVM phase: 1
AutoConfig is exiting with status 1


I didn't find the exact hit on support.oracle.com , so plan to run the perl scripts manually which was failing..SO ran the perl scripts and it autoconfig got successful.and click the
retry button of R12 Installtion screen, it got successful.

[applmgr@localhost bin]$ perl adgentns.pl contextfile=/apps/inst/apps/TEST_localhost/appl/admin/TEST_localhost.xml  appspass=apps
##########################################################################
                   Generate Tns Names
##########################################################################
Logfile:  /apps/inst/apps/TEST_localhost/admin/log/05030918/NetServiceHandler.log
        Classpath                   : /apps/apps/apps_st/comn/java/lib/appsborg2.zip:/apps/apps/apps_st/comn/java/classes
Updating s_tnsmode to 'generateTNS'
UpdateContext exited with status: 0
adgentns.pl exiting with status 0
ERRORCODE = 0 ERRORCODE_END