TriniDBA

Problem:

When trying to log on to the newly cloned TEST instance as sysadmin user, the following error appears:

You have insufficient privileges for the current operation. Please contact your System Administrator.

Solution:

Used URL:

http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp

to compare differences between TEST and PROD. Noticed that JSP Ping not working on both.

In Metalink, searched for error:

java.lang.StringIndexOutOfBoundsException: String index out of range: -1

Checked document: Subject:  Troubleshooting Login (Doc ID:  Note:178437.1), “3. Login: java.lang.StringIndexOutOfBoundsException when log into jtflogin.jsp”

In SQL*Plus, executed the following code:

select SESSION_COOKIE_DOMAIN from icx_parameters;

update icx.icx_parameters set SESSION_COOKIE_DOMAIN = ‘.support.com’;

commit;

select SESSION_COOKIE_DOMAIN from icx_parameters;

Tested logon on ebusinesstest, working now.

Reference:

Subject:  Configuring and Troubleshooting the Self Service Framework 5.5.2 with 11i (Doc ID:  Note:177095.1)