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.
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