Skip to main content

Good day.

 

We are running APPS9 and encounter issues with the ifsapp locking.

This occurs in 2 or our production environments.

I have changed the password both through the login screen as well as through the db by altering username and setting a new password.

 

Is there a log file which may show me if another user is trying to login using the account which may be why its locking.

Or

Is there a way to determine if there is a running process requiring username & password of the ifsapp account to run.

 

We are not using SSO

If you have other suggestions of where to look, I would be truly appreciative.

 

Thank you

Hi @CUCSOLUTIONS

 

Try to use following trigger and check oracle alert logs:

create or replace trigger logon_denied_to_alert
  after servererror on database
declare
  message varchar2(4000);
begin
  IF (ora_is_servererror(1017)) THEN
    select '^^^^^^user=' ||NVL(user, SYS_CONTEXT('USERENV', 'AUTHENTICATED_IDENTITY')) ||' ip=' || sys_context('userenv', 'ip_address') ||
           ',host=' || sys_context('userenv', 'host') || ',osuser=' || SYS_CONTEXT('USERENV', 'OS_USER')
      into message from dual;
  
    message := to_char(sysdate, 'Dy Mon dd HH24:MI:SS YYYY') || ' logon denied for ' || message;
    sys.dbms_system.ksdwrt(2, message);
  end if;
  exception when others then null;
end;

Reply


Terms & ConditionsCookie settings