Seyed_G wrote:enable AUDIT CREATE SESSION
We are running Oracle 10g. We have a problem with the ‘SYSTEM’ user ID getting locked occasionally. Is there a way to see what causes this account to get locked? I found out about this when a stored procedure that uses DBLink to delete data from two different databases failed with “ORA-28000: the account is locked”.
Thank you in advance,
Seyed_G wrote:It is fine until SYSTEM account goes locked again, again.
Thank you for your input. I believe, our organization has opted to leave the AUDIT off. The reasons is that our load jobs are taking too long to run and turning audit on would make matters worse. With regards to wrong password, this stored procedure uses Invoker's rights and it never fails on production but occasionally fails on development. I just checked, our DBA unlocked the 'SYSTEM' user ID and my co-worker re-ran the stored procedure and it ran fine.