This discussion is archived
4 Replies Latest reply: Aug 28, 2013 5:13 AM by EdStevens RSS

System account locked often

967023 Newbie
Currently Being Moderated

Hello all,

 

my database version:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE    10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

 

We have Export job which is running daily - But the job is failing due to following error

 

EXP-00056: ORACLE error 28000 encountered

ORA-28000: the account is locked

EXP-00030: Unexpected End-Of-File encountered while reading input

EXP-00000: Export terminated unsuccessfully

 

I know the system password is locked in the database - So i want to find root cause like - Who is locking my system account ..? - Is there any query to find what are the jobs that depend on System account..?

 

If so it would be easy to see which scripit/job is making the system account locked

 

Please help me.

  • 1. Re: System account locked often
    thtsang Journeyer
    Currently Being Moderated

    Use auditing, like

     

    AUDIT SESSION WHENEVER NOT SUCCESSFUL;

  • 2. Re: System account locked often
    967023 Newbie
    Currently Being Moderated

    Thank you for reply - but we are not using audit

    Is there any way to find what are dependent jobs in system account ?- So that i can verify job itself

  • 3. Re: System account locked often
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated

    I'd try first to check what are the system's profile password settings (failed attempts, grace period...). By the way, why run a job with system Oracle user ?

     

    Nicolas.

  • 4. Re: System account locked often
    EdStevens Guru
    Currently Being Moderated

    967023 wrote:

     

    Thank you for reply - but we are not using audit

    So what is preventing you from using it now?  You have a problem.  Auditing can help solve the problem.

    Is there any way to find what are dependent jobs in system account ?- So that i can verify job itself

     

    I'd start with looking at whatever is scheduled in the OS job scheduler on the db server and any relevant apps servers ..  sometimes you just have to do the grunt work, though if you are on a *nix system, combinations of 'find' and 'grep' could help in this case.

     

    But yo could also have an app doing this from within its own system.  Really comes back to auditing being your best tool

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points