Re: unable to authenticate session-R12

Posted by raiq1 on Jan 30, 2023; 7:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/unable-to-authenticate-session-R12-tp11528p11536.html

Hi Erman sir,

As per your advice, I have ran the queries for both PROD & DR apps server , and the output is same are PROD.

Basically we have a plan for switchover & switchback in coming weekend to test DR. Before doing this task, I have convert our DR to Snapshot database and configure apps in DR machine to check all configuration and EBS connectivity.


This issue is occurred after apps are configured with snapshot DR database.


Below are the output for your queries for both PROD & DR.


PROD
=====
SQL> select FND_SESSION_MANAGEMENT.getsessioncookiename() from dual;

FND_SESSION_MANAGEMENT.GETSESSIONCOOKIENAME()
--------------------------------------------------------------------------------
PROD


SQL> select SESSION_COOKIE_NAME from ICX_PARAMETERS;

SESSION_COOKIE_NAME
------------------------------



SQL > 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;

PROFILE_OPTION_NAME
--------------------------------------------------------------------------------
PROF_LEVEL
--------------------------------------------------------------------------------
PROFILE_OPTION_VALUE
--------------------------------------------------------------------------------
APPS_DATABASE_ID
SITE
PROD

SQL> select host_name, instance_name from v$instance;

HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME
----------------
proddb01
PRODCDB


DR MACHINE OUTPUT
===============

Below are the output of DR snapshot.


SQL> select FND_SESSION_MANAGEMENT.getsessioncookiename() from dual;

FND_SESSION_MANAGEMENT.GETSESSIONCOOKIENAME()
--------------------------------------------------------------------------------
PROD

SQL> select SESSION_COOKIE_NAME from ICX_PARAMETERS;

SESSION_COOKIE_NAME
------------------------------

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;

PROFILE_OPTION_NAME
--------------------------------------------------------------------------------
PROF_LEVEL
--------------------------------------------------------------------------------
PROFILE_OPTION_VALUE
--------------------------------------------------------------------------------
APPS_DATABASE_ID
SITE
PROD




SQL> select host_name, instance_name from v$instance;

HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME
----------------
proddr
PRODCDB



Kindly check the output for both queries and advice .

Reqards,
Raiq




SQL>