user always gets lock [message #393673] |
Tue, 24 March 2009 01:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 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 #393704 is a reply to message #393673] |
Tue, 24 March 2009 02:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 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 #393838 is a reply to message #393673] |
Tue, 24 March 2009 10:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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
|
|
|