Error while opening EBS url after cloning - " You are trying to access a page that is no longer active."

 

Recently for one of my customer, I was doing a new R12.1.3 clone into a new server which was outside of their production domain. So after the cloning when tried to open the EBS url from browser it showed error saying  You are trying to access a page that is no longer active.
- The referring page may have come from a previous session. Please select Home to proceed.


So after doing a bit of google, I found a document from oracle support suggesting a possibility that if the server hostname container underscore (_) such behaviour is observed. But in our case hostname contained no underscore so this was not the case.

So I did the following to resolve the issue

Login to database as apps user

sqlplus apps/xxxx

SQL> select session_cookie_domain from icx_parameters;

 

SESSION_COOKIE_DOMAIN

------------------------------

.olddomain.co.in

 

The session_cookie_domain column is still looking for olddomain.co.in

 

So I nulled the value

 

SQL> update icx_parameters set session_cookie_domain=null;

1 row updated.

 

SQL> commit;

Commit complete.

 

SQL> select session_cookie_domain from icx_parameters;

SESSION_COOKIE_DOMAIN

------------------------------

 

 

 

After this I bounced the apache services.

 

[applmgr@ebsr122 ~]$ cd $ADMIN_SCRIPTS_HOME

 

[applmgr@ebsr122 scripts]$ adapcctl.sh stop

 

[applmgr@ebsr122 scripts]$ adapcctl.sh start

 

Then I checked the url again , and it logged in without any error.


No comments:

Post a Comment