sysadmin cannot connect

classic Classic list List threaded Threaded
2 messages Options
big
Reply | Threaded
Open this post in threaded view
|

sysadmin cannot connect

big
Hi,
On R12.2.9, DB 19c
Sysadmin cannot connect:



I changed his password
FNDCPASS apps/xxx  0 Y system/*** USER sysadmin *****
+----------------------------------------------------------------------------+
Working...
Password is changed successfully for user sysadmin.
FNDCPASS completed successfully.

+---------------------------------------------------------------------------+          
But problem perssiste and sysadmin cannot connect.

Any help please?

-Is ther any query to verify its account status?
-Is there any script, query to create another fnd user and try to connect with?

Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: sysadmin cannot connect

ErmanArslansOracleBlog
Administrator
This issue is generic.

Check the password with the following;

select fnd_web_sec.validate_login('SYSADMIN','<password of SYSADMIN>') FROM DUAL;
select fnd_web_sec.validate_login('<other EBS username>',<password of GUEST>') FROM DUAL;
select fnd_web_sec.validate_login('GUEST',<password of GUEST (**1)>') FROM DUAL;

Follow -> All User Can't Login to EBS by "Login failed. Please verify your login information or contact the system administrator" Even If Using a Right Password (Doc ID 2680955.1)

and check -> Unable To Login into EBS With SYSADMIN User After Migrating To New Machine (Doc ID 1903562.1)