Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Tuesday, May 31, 2011

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.

4 comments:

Anonymous said...

Thanks for the blog, very helpfull, could not find any info on metalink but google did the trick

ANAND REDDY AVUTALA said...

Hi Vikram,

Oracle has suggested to set the parameter java_jit_enabled to FALSE instead of the default value TRUE ..
Ref: 1316906.1.

Regards
Anand

ANAND REDDY AVUTALA said...

Hi Vikram

Oracle has suggested to set the parameter java_jit_enabled to FALSE instead of TRUE


Ref : 1316906.1

Tanta Café said...

Hi Team

We have the similar error:

SQL> select fnd_web_sec.URLEncrypt('hello', 'world') from dual;
select fnd_web_sec.URLEncrypt('hello', 'world') from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 19612
Session ID: 472 Serial number: 16665


GCL