[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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