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
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
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.
From a CMD prompt:
lsnrctl status
This will tell you where to look.
ASKER
thanks
ASKER
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
I can open a new question if I need to
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is what I was afraid of - thanks for the clarification
There is still a text version. Look under the trace folder. The original listener.log file format is in there.