ERROR

Unable to authenticate session in Oracle apps R12 (12.0.4): Login Issue

It is in the following log file:

$INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log

15/09/19 05:45:20.601 10.1.3.0.0 Started

15/09/19 05:45:30.769 html: 10.1.3.0.0 Started

15/09/19 05:45:35 .132 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1219349853132

15/09/19 05:45:38.132 html: LeakSetting:

global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false

ignoring:null

15/09/19 05:45:45.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

1.Enable FND debug

The FND debug log would have 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.

2.Check if the APPS_TS_ARCHIVE Tablespace is full.

3.Increase the size of tablespace APPS_TS_ARCHIVE by adding a datafile to the tablespace.