• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

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
0
bkreynolds48
Asked:
bkreynolds48
  • 4
  • 3
1 Solution
 
slightwv (䄆 Netminder) Commented:
>>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.
0
 
bkreynolds48Author Commented:
I looked in the trace directory - the only .log file there is the alert log
0
 
slightwv (䄆 Netminder) Commented:
Look in the tnslsnr\trace folder under diag.

From a CMD prompt:
lsnrctl status

This will tell you where to look.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
bkreynolds48Author Commented:
thanks
0
 
bkreynolds48Author Commented:
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
0
 
slightwv (䄆 Netminder) Commented:
No need for a new question.  It would be a duplicate.

I'll re-open this one so the discussion can continue.

In the original question you stated " In 10G I would find out who did that in the listener log"

I assumed you knew how to locate the information from the log.

You can see who made attempts from the listener log correct?

Other than that, I'm afraid you'll need to turn on auditing.
0
 
bkreynolds48Author Commented:
That is what I was afraid of - thanks for the clarification
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now