Thursday, 2 April 2015

SYSADMIN Error Login failed. Please verify your login information or contact the system administrator.


Error:
Login failed. Please verify your login information or contact the system administrator.   


Solution:

Check the guest user name is correct and then sysadmin password.


SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
Y


==> this should return Y,If its N.then there is some issue with password.

Once the above is succesfull. 
Check for system whom you are login.

SQL> select fnd_web_sec.validate_login('SYSADMIN','PASSWORD_') from dual;

In my case it return N,So there is some corruption in the password or some change.So i changed the password using FNDCPASS

$ FNDCPASS apps/<appspawd> 0 Y system/manager USER SYSADMIN <Passwd>

No comments: