| user always gets lock [message #393673] |
Tue, 24 March 2009 01:11  |
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  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
