Home » RDBMS Server » Security » user always gets lock (solaris10-oracle10g)
user always gets lock [message #393673] Tue, 24 March 2009 01:11 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Dear All,

I have a Database User John.

Every morning when I come to office I must unlock this user.

Is there a way to know which user or which program or which process is locking the database user John.

When I query v$session from machine, I find only the DB server name.

Is is possible to know which PC (IP Address) is locking this user.


Thank you,
Dirish
Re: user always gets lock [message #393678 is a reply to message #393673] Tue, 24 March 2009 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58579
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there a way to know which user or which program or which process is locking the database user John.

Most of the time this is because of too much failed logons (see John's profile). In this case, execute:
audit create session by John whenever not successful;

You can also audit all "alter user" statements:
audit alter user;

Regards
Michel

[Updated on: Tue, 24 March 2009 01:34]

Report message to a moderator

Re: user always gets lock [message #393694 is a reply to message #393678] Tue, 24 March 2009 01:50 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
am facing the same problem as it message #255443
Re: user always gets lock [message #393695 is a reply to message #393694] Tue, 24 March 2009 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 58579
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post a link not a message number.
And did you try what I said and what is said in the topic you refer?

Regards
Michel

[Updated on: Tue, 24 March 2009 01:54]

Report message to a moderator

Re: user always gets lock [message #393696 is a reply to message #393695] Tue, 24 March 2009 01:55 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
I am confused with the solution you provided. Grateful if you can clarify.

Thank you
Re: user always gets lock [message #393700 is a reply to message #393696] Tue, 24 March 2009 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 58579
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does confuse you?
I gave you 2 statements to execute. You have to first refer to SQL Reference, audit statement, to know how to set up auditing.

Regards
Michel
Re: user always gets lock [message #393704 is a reply to message #393673] Tue, 24 March 2009 02:06 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hello,

Thank you for your reply.

People post their issues on this forum to find a solution and you are telling me to search how to set up auditing! Should I open a new forum?

Thank you
Re: user always gets lock [message #393705 is a reply to message #393704] Tue, 24 March 2009 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 58579
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I gave you a solution, I will not post a step by step which will only be a copy and paste of the documentation.
"Searching" AUDIT in SQL Reference TOC should not take you more than a couple of seconds.

Regards
Michel
Re: user always gets lock [message #393741 is a reply to message #393705] Tue, 24 March 2009 04:27 Go to previous messageGo to next message
babuknb
Messages: 1717
Registered: December 2005
Location: NJ
Senior Member

Quote:
Most of the time this is because of too much failed logons (see John's profile).


Are you using any user profiles? If Yes As per Mr Mic, Check your user profile first. If no then go with audit.

Babu


Re: user always gets lock [message #393838 is a reply to message #393673] Tue, 24 March 2009 10:37 Go to previous message
kafaween
Messages: 7
Registered: August 2007
Location: Jordan
Junior Member
Dear All;

I faced the same problem , but i solved it ...
Here we have two scenarios

One :if the user logged from sqlplus , use SYS_CONTEXT functions , i.e use IP Address , hostname , OS User ..etc

Two :if the user logged from oracle forms (applications) , then you need customization logon screen , firstlog on using hidden user (use userid parameter in formsweb.cfg in Oracle Application Server , i.e. userid=scott/tiger@db) , then put two text boxes in your form (username , password) insert the values of the user in your specified table , if the form success then logout from the scott user and logon using the entered user , else exit and go to table to check who is that (USING WebUtil Library).

Regards;

Mohammed Kafaween
Previous Topic: How to trace which user causing the account lock + auditing failed login via application server (mer
Next Topic: Transparent Data Encryption, Oracle Wallet
Goto Forum:
  


Current Time: Sat Jul 26 06:13:17 CDT 2014

Total time taken to generate the page: 0.22009 seconds