The Release 12.0.4 instance was cloned
from another identical instance.
When we try to login, the login page
does not display
Have tried clearing the cache
(_pages). Have tried recompiling jsps and bouncing however the problem still
persists.
Cleared all the Apache and related logs and found an interesting
error.
It is in the following log file:
$INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log
08/08/21 15:17:00.601 10.1.3.0.0
Started
08/08/21 15:17:02.769 html: 10.1.3.0.0
Started
08/08/21 15:17:33.132 html:
oracle.apps.fnd.security.LeakDetectionFilter.initialized:1219349853132
08/08/21 15:17:33.132 html:
LeakSetting:
global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
ignoring:null
08/08/21 15:17:34.859 html: chain
failed
javax.servlet.ServletException:
java.lang.RuntimeException: Unable to create user session. Please contact your
System Administrator.
at
com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0)
].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:780)
Solution:
Enable FND debug
The FND debug log had the below error:
Oracle error
-1654: ORA-01654: unable to extend index APPLSYS.FND_LOGINS_N2 by 16 in
tablespace APPS_TS_ARCHIVE has been detected in FND_SIGNON.AUDIT_USER.
Check if the APPS_TS_ARCHIVE
Tablespace is full.
Increase the size of tablespace
APPS_TS_ARCHIVE / add a datafile to the tablespace.
This will resolve the
issue.
No comments:
Post a Comment