Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

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

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

 

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.

 

 

Related Posts
Write a comment