9i OEM event not triggering
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 9i OEM event not triggering

  1. #1
    Join Date
    Oct 2006
    Posts
    17

    9i OEM event not triggering

    ok 2 questions in one day.

    We have set our default profile to lock accounts after 10 failed logins. and I set up an even that runs every 5 min in 9i oem that does a user defined sql test

    SELECT COUNT(*)
    FROM dba_users
    WHERE account_status = 'LOCKED(TIMED)'

    operator is >= 1

    i then force an account to lockout after 10 failed attempts but it never triggers the event? Any ideas?

    Regards,
    SMD

  2. #2
    Join Date
    Sep 2007
    Posts
    36
    >>and I set up an even that runs every 5 min in 9i oem that does a user defined sql test

    How are you doing this? DBMS_JOB?

    I'm assuming that you're trying to generate some auto-notification about this event, right?

    >>but it never triggers the event

    Are you saying the account never gets locked after ten failed attempts, or you don't receive the notification?
    J

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width