Re: unable to authenticate session-R12

Posted by ErmanArslansOracleBlog on Jan 30, 2023; 6:15am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/unable-to-authenticate-session-R12-tp11528p11531.html

This seems like a cookie name problem.. Probably PROD and DR have the same cookie name..
It seems you already found the correct MOS note to deal with the issue.
-- Just want to remind.. After you do an update on the critical profile options like the one given in the MOS note, restarting the apps tier (and then retrying the problematic process) is a good idea.

1)Verify the cookie names on both of the instances;
select FND_SESSION_MANAGEMENT.getsessioncookiename() from dual;

select SESSION_COOKIE_NAME from ICX_PARAMETERS;

2) Are APPS_DATABASE_ID values the same on PROD and DR?

select p.profile_option_name,
decode(v.level_id,
10001,'SITE',
10002, (select 'App:'||a.application_short_name
from fnd_application a
where a.application_id = v.level_value),
10003, (select 'Resp:'||f.RESPONSIBILITY_KEY
from fnd_responsibility f
where f.responsibility_id = v.level_value),
10004, (select 'User:'||u.user_name
from fnd_user u
where u.user_id = v.level_value),
10005, (select 'Server:'||n.node_name
from fnd_nodes n
where n.node_id = v.level_value),
10006, (select 'Org:'|| o.name
from hr_operating_units o
where o.organization_id = v.level_value),
'NOT SET') PROF_LEVEL,
nvl(v.profile_option_value,'NOT SET') profile_option_value
from
fnd_profile_options p,
fnd_profile_option_values v
where
p.profile_option_id = v.profile_option_id (+)
and p.application_id = v.application_id (+)
and p.profile_option_name = 'APPS_DATABASE_ID'
order by 1, v.level_id;

3) It the outut of the following same on PROD and DR? This is not expected, but in some config people prefer to have the same host and instance names to be quickly up on DR in case of a failover or switch.

select host_name, instance_name from v$instance;

Note that,  a default cookie name is generated from the SQL  select host_name, instance_name from v$instance;

4)Make a general health check on your DR EBS.. Check tablespaces, invalid objects and everything.. (including the relevant logs --> oacore+apache+DB / FND log messages as well)  That error(unable to authenciate) may also be misleading.