Home » RDBMS Server » Security » Accounting: Cause of Oracle user being locked. (Oracle 11, Solaris 10)
Accounting: Cause of Oracle user being locked. [message #569256] Tue, 23 October 2012 13:22 Go to next message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Team,

An Oracle user account got locked, how do I check, which program or session was the cause for it? Please let me know as how to fetch this details along with details like timestamp, ip address, program name....

Wanted to know for Oracle 11 version running on Solaris machine.

Thanks
Sunil Kumar
Re: Accounting: Cause of Oracle user being locked. [message #569261 is a reply to message #569256] Tue, 23 October 2012 13:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Account can be locked because of too many unsuccessful login attempts. Or, someone who is powerful enough, locked it manually. There may be some other reasons, but I don't know them (I'm sure that people who know it better will let you know).

How to get the details you mentioned? No idea either, sorry.
Re: Accounting: Cause of Oracle user being locked. [message #569278 is a reply to message #569256] Wed, 24 October 2012 01:39 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If people are connecting remotely, you can get these information in listener.log.

If this is important for you, I advice you to activate audit for this case:
AUDIT SESSION WHENEVER NOT SUCCESSFUL;

Regards
Michel
Previous Topic: CVE-2012-3132 and Express Editions of Oracle DB
Next Topic: oracle wallet creation and accessing
Goto Forum:
  


Current Time: Thu Mar 28 16:39:15 CDT 2024