R12 AppsLocalLogin shows blank page

This issue has already been reported to me twice, so I am documenting this for future:

R12 AppsLocalLogin shows blank page

A check of logs shows this:

cd $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1
vi application.log
Go to the end of the file

11/05/31 15:38:07.918 html: LeakSetting:
global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
ignoring:null
11/05/31 15:39:40.810 html: chain failed
javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816)
at _AppsLocalLogin._jspService(_AppsLocalLogin.java:303)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.5.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
at java.lang.Thread.run(Thread.java:662)


Start an sqlplus session

SQL> conn apps/appspassword
Connected.
SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') FROM DUAL;
select fnd_web_sec.validate_login('GUEST','ORACLE') FROM DUAL
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Check the Database Alert Log
Tue May 31 15:50:51 2011
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x108250218, ioc_pin_shared_executable_object()+1240] [flags: 0x0, count: 1]
Errors in file /appsr1213/oracle/11.2.0/admin/vision_vision/diag/rdbms/vision/vision/trace/vision_ora_10944.trc (incident=121312):
ORA-07445: exception encountered: core dump [ioc_pin_shared_executable_object()+1240] [SIGSEGV] [ADDR:0x0] [PC:0x108250218] [Address not mapped to object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue May 31 15:50:54 2011
Sweep [inc][121312]: completed

If you open two unix sessions side by side:

First session: connect to sqlplus as apps and execute
select fnd_web_sec.validate_login('GUEST','ORACLE') FROM DUAL;

Second session: tail Database alert log

You'll notice that whenever this sql is executed in first session, the alert log will immediately log an ORA-07445 error.

This is an 11.2.0.2 bug. The workaround is to bounce the database and listener. Once I learn more about this bug, I'll update this post.