sysadmin user not logging in r12
I am trying to logging in sysadmin user of one of our UAT system, It’s simply loading but not logging in.
I checked the sysadmin user credentials valid. Yes it’s Valid.
select fnd_web_sec.validate_login(‘SYSADMIN’,’password’) from dual;
I checked any blocking session in database, Yes it’s there . So I kill those sessions afterwards I can able to login.
select l1.sid, ‘ IS BLOCKING ‘, l2.sid
from v$lock l1, v$lock l2 where l1.block =1 and l2.request > 0
and l1.id1=l2.id1 and l1.id2=l2.id2