Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I had a user in my oracle DB with some 'x' password for sometime. Without notifying my team I changed the password to 'y'. But my team members tried to connect to the machine with the old passowrd 'x' and as the limit was set, the user account got locked. I know how to set the resource limit for the login.

It would be helpful if anyone can help in finding who and all has tried to connect to the DB. As a administrator I would like to view from where the connection was from.

Thanks in advance.


share|improve this question

migrated from Oct 23 '09 at 5:08

This question came from our site for professional and enthusiast programmers.

The password 'x' is known to everyone and not the password 'y'.

share|improve this answer

From your command prompt, type sqlplus "/ as sysdba"

Once logged in as SYSDBA, you need to unlock the locked account (eg. scott) SQL> alter user scott account unlock; SQL> grant connect, resource to scott; SQL> commit;

share|improve this answer

In the listener log, you will get the IP address of the incoming connection. The Oracle username you already know, as it is the one that is locked, but Oracle will not see the Unix username of the user until they are connected (in v$session). You may be able to correlate that IP address to your user's machine.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.