Unable to authenticate session oracle ошибка

Unable To Authenticate Session or Unable to create session is one of the most common errors in R12 instance

ERROR
-----------------------
"Unable to authenticate session"

This can happen after the instance is cloned or any changes happened to the system with wrong parameter

The first log which you should check in case of this error is

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

Here are some common errors which you might see

Error 1
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) Error 2
oracle.apps.fnd.framework.OAException: Could not load application module
'oracle.apps.fnd.sso.login.server.MainLoginPageAM'.
Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: ICX_SESSION_FAILED.

How to solve the issue

(1) First check if the R12.0/R12.1  is in maintenance Mode .If it is still in Maintenance mode.

Disable it

sqlplus apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

Bounce all the services

$ADMIN_SCRIPTS_HOME/adopmnctl.sh stopall $ADMIN_SCRIPTS_HOME/adopmnctl.sh startall

(2)   Check the database for error in alert_log.it might be possible some APPS% tablespace are full and session creation is a failing

How to check free space in Oracle Tablespace

select sum(BYTES/1024/1024) 
from dba_free_space where TABLESPACE_NAME like '&1'
;

Add the space

alter tablespace <tablespace name> add datafile '+DATA' size 1000M;

(3) Guest user may be end-dated

SELECT user_name,TO_CHAR(start_date,'DD-MON-YYYY'),
TO_CHAR(end_date,'DD-MON-YYYY') 
FROM FND_USER WHERE user_name = 'GUEST';

If it is end dated, remove it  and bounce the services

You might also want to check if GUEST user is working fine

select fnd_web_sec.validate_login('GUEST','ORACLE') from dual;

(4) The profile Initialization SQL Statement — Custom  may be wrongly set. Please check the oracle profile option at the site level,user level

set linesize 140
set pagesize 132
column SHORT_NAME format A30
column NAME format A40
column LEVEL_VAL format 999999999
column VALUE format A60 wrap
set lines 200;
col SHORT_NAME format a30;
col NAME format a35;
col VALUE format a30;
select
p.profile_option_name SHORT_NAME,
n.user_profile_option_name NAME,
decode(v.level_id,
10001,'Site',
10002,'Application',
10003,'Responsibility',
10004,'User',
10005,'Server',
10006,'Organization',
'UnDef') LEVEL_SET,
v.level_value LEVEL_VAL,
v.profile_option_value VALUE
from fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
and upper(n.user_profile_option_name) like upper('%&profile_name%')
and v.level_id= &LEVEL;

(5) Look for invalid in the database

set lines 120
set pages 5000
select owner,object_name,status
from dba_objects
where status !='VALID';

Compile the APPS schema using adadmin utility and bounce the services.
Related Article
How to Compile Invalid objects in Oracle

(6) Try compiling jsp

 cd $COMMON_TOP/_pages
find . -name "*" -exec rm -rf {} \;cd $FND_TOP/patch/115/bin
./ojspCompile.pl --compile --flush -p 5
logfile set: /xyz/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
enumerating jsps...8000
parsing jsp...8000
writing deplist...8000
initializing compilation:
eliminating children...5912 (-2088)
translating and compiling:
translating jsps...5912/5912 in 1m40s
compiling jsps...5912/5912 in 4m19s
Finished!

(7) Look into FND_NODES and check if we have duplicate entries for SERVER_IP

 select NODE_NAME, SERVER_ID, NODE_ID
from FND_NODES;

(8) Check the DBC in $FND_SECURE and find out if it is correct

Sometimes APPLSYSPUB password may be wrong in dbc files. correct it and bounce the services and try again

(9) Look for all the Important schema name and their password

APPS
APPLSYS
APPLSYSPUB

You can try login into these schema with the password and verify them

(10) If it is some configuration issue. Autoconfig might help. Try running autoconfig  and check the result again

I hope this helps in Unable To Authenticate Session problem .Please do let me know if I can help in some way

Related Articles

How to assign User management Responsibility to user in R12
Guest User password in oracle 11i/R12
APPLSYSPUB schema
oacore services not coming up
log file locations in oracle apps
User Preferences of your E-Business Suite homepage
JRE not found message while running runInstaller
https://en.wikipedia.org/wiki/Oracle_Applications

Sometimes while using IE8 Browser you may get the below error instead of the login page

 ‘Unable To Authenticate Session”

You may see such issue on IE9 also.

Possible Solution 1 : One solution which is documented in the Oracle note id can help ( R12: Using IE8 to access two EBS Instances runs in error “Unable To Authenticate Session” [ID 1098563.1])

According to it , the  new ‘Session Merging’ feature within IE8 and IE9 is creating the issue and can be easily tackled by adding                   -noframemerging parameter.

Right click on your IE icon and add -noframemerging to the end of the link in the Target field e.g.”C:\Program Files\Internet Explorer\iexplore.exe” -noframemerging (shown below)

ie_properties

Possible Solution 2 : Clearing the Cache helped me many times in getting through these errors while working on EBS with  IE browsers.

A) Go to Tools >Internet Options > Click on delete browsing Cache (shown below)

ie_cache-233x300

B) Go to Start > Control Panel > Java >  Settings > Delete temp files > OK (shown below)

java_cache1

java_cache2

java_cache3

After clearing the cache, Close the browser, start again and try opening the EBS link.

  • Author
  • Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

expertoracle.com

Brijesh Gogia

Post Views: 259

EBS login Error:- Unable to Authenticate Session in ebs r12.|  In this post we will cover how to clear browser cache and history and resolve unable to autothenticate session error in R12.

When user try to login to E-Business Suit R12.*.*. with two different instances in same browser. Suddenly error will be generated as ‘Unable to authenticate session‘.

If you receive an ‘Unable to authenticate session’ error in your browser when running multiple sessions using the JRE Plugin architectuire, set the -noframemerging option as outlined in the Multiple Oracle E-Business Suite Java Sessions (JRE Plugin).

Create a new IE icon, adding the -noframemerging parameter as follows:

Start > Program Files

Right-click on the Internet Explorer icon and select Properties

unable to authenticate session

unable to authenticate session

Add -noframemerging to the end of the link in the Target field. For example:

“C:Program FilesInternet Exploreriexplore.exe” -noframemerging or

“C:Program Files (x86)Internet Exploreriexplore.exe” -noframemerging

unable to authenticate session in ebs r12

unable to authenticate session in ebs r12

Click the OK button to close the window.

This icon may then be copied to the desktop if desired.

Step to clear browser cache.

If this does not resolve the problem, or you are not running multiple sessions, clear your browser cache by deleting the ‘Temporary Internet Files’ as follows:

👉 Stop all Browser sessions.

👉 Tools > Internet Options > General (tab) > Browsing History > Delete (button).

👉 Start a new Browser session and logon to the Instance.

unable to authenticate session

Note: Oracle recommend that Oracle E-Business Suite is run through the ‘Trusted Sites’ zone, with a ‘Medium’ Security Setting.

Useful Post:-

  • PRCD 1119 failed to create database while using dbca
  • How to fix ORA-00020: maximum number of processes 150 exceeded 


Unable to authenticate session – EBS R12

EBS login error:

“Unable to Authenticate Session”




Start the Internet Explorer with the option ‘-noframemerging‘, as described in Note 389422.1 — ‘Recommended Browsers for Oracle E-Business Suite Release 12’ under the Known issues.

 
SOLUTION 1:

1. Clear the Browser cache.
2. Stop all Browser sessions.
3. Start a new Browser session and logon to the Instance.

Go to Tools >Internet Options > Click on delete browsing Cache (shown below)

SOLUTION 2:



1) Start > Program Files
2) Right click on the Internet Explorer icon and select Properties
3) Add -nomerge to the end of the link in the Target field i.e.
“C:\Program Files\Internet Explorer\iexplore.exe” -noframemerging
4) Click the OK button to close the window






R12: Using IE8 to access two EBS Instances runs in error «Unable To Authenticate Session» [ID 1098563.1]
R12 — logon to a cloned Instance is failing with error ‘Unable to Authenticate Session’ [ID 744086.1]
Unable To Authenticate Session Error When Login to Different R12 Instance in Same IE Session [ID 1159313.1]
Unable To Authenticate Session When Trying To Get To Main Login Screen [ID 1353483.1]








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.

Check Also

NewsAndUpdates-d5668652

Applying EBS Latest CPU through ECPUC

Applying EBS Latest CPU JUL-2023 through EBS Critical Patch Update Checker (ECPUC)   Hello everyone, …

Понравилась статья? Поделить с друзьями:
  • Unable to acquire jdbc connection ошибка
  • Unacr dll вернул код ошибки 12
  • Ulo ошибка на контроллере холодильника
  • Unaarc dll вернул код ошибки 11
  • Unable to write ibec ошибка