Can not login to OAM after moving envirnoment to another hardware having different IP address of App
Hi Experts,
I have a Customer who had copied his ebs environemnt to another server,
difference is only in apps and database ip addresses
the EBS Application 11.5.10.2 is working normally
But OAM has the following error:
Analysis of the problem:
After the logon attempt (when username and password is correct), inside database number of session keeps increasing up to limit of max sessions init parameter - what you can see below:
select a.sid,a.serial#,a.logon_time,a.sql_address,a.prev_sql_addr,b.sql_text SQL_TEXT ,c.sql_text PREV_SQL_TEXT
from v$session a , v$sql b,v$sql c
I have a Customer who had copied his ebs environemnt to another server,
difference is only in apps and database ip addresses
the EBS Application 11.5.10.2 is working normally
But OAM has the following error:
Analysis of the problem:
After the logon attempt (when username and password is correct), inside database number of session keeps increasing up to limit of max sessions init parameter - what you can see below:
select a.sid,a.serial#,a.logon_time,a.sql_address,a.prev_sql_addr,b.sql_text SQL_TEXT ,c.sql_text PREV_SQL_TEXT
from v$session a , v$sql b,v$sql c
Tagged:
0