Link to home
Start Free TrialLog in
Avatar of bkreynolds48
bkreynolds48

asked on

oracle 11g find out who locked an account

Databases are 11g  11.2.0.4
Several applications connect to the database - they changed the main account password.  Now some application keeps locking the account.  In 10G I would find out who did that in the listener log.  How do I find out who did this in 11G since the listener log is now an xml file.  Auditing is not turned on
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>I find out who did this in 11G since the listener log is now an xml file

There is still a text version.  Look under the trace folder.  The original listener.log file format is in there.
Avatar of bkreynolds48

ASKER

I looked in the trace directory - the only .log file there is the alert log
Look in the tnslsnr\trace folder under diag.

From a CMD prompt:
lsnrctl status

This will tell you where to look.
thanks
I found the listener.log but can't find the user who locked the account - how do I find that?
I can open a new question if I need to
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That is what I was afraid of - thanks for the clarification