OraFAQ Forum: Security » Accounting: Cause of Oracle user being locked.

Home » RDBMS Server » Security » Accounting: Cause of Oracle user being locked. (Oracle 11, Solaris 10)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Accounting: Cause of Oracle user being locked. [message #569256]

Tue, 23 October 2012 13:22

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

Report message to a moderator

Re: Accounting: Cause of Oracle user being locked. [message #569261 is a reply to message #569256]

Tue, 23 October 2012 13:58

Littlefoot
Messages: 16994
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.

Report message to a moderator

Re: Accounting: Cause of Oracle user being locked. [message #569278 is a reply to message #569256]

Wed, 24 October 2012 01:39

Michel Cadot
Messages: 54226
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 07:04:02 CDT 2013

Total time taken to generate the page: 0.10295 seconds