Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Account lock cause

3035820Feb 11 2016 — edited Feb 12 2016

Hi,

User has asked us to unlock the account and wants to know who has locked the account because he is facing this issue frequently.

Currently, auditing is enabled at OS level as below. is this still possible to find the information? Could you please comment on this?

SQL> show parameter audit

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

audit_file_dest                      string      /app/rq040/01/admin/RQ040A

                                                 /audit

audit_sys_operations                 boolean     FALSE

audit_syslog_level                   string

audit_trail                          string      OS

Oracle -- 11.2.0.3.0

OS     -- AIX

This is QA DB.

This is standalone DB

Regards,

Bala

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2016
Added on Feb 11 2016
8 comments
1,838 views