Forgot Oracle username and password, how to retrieve?

Question

I have forgotten my Oracle username and password and hence not able to use it. My Oracle version is 11.2.0.1.0(11g). I consulted Internet. They asked me to execute commands like ‘SYSDBA’ but I was unable to do it as once I give ‘SYSDBA’ on Command Prompt screen, it takes the command as the username and next asks for password. I cannot execute any commands suggested by them as whatever I enter is taken as the username, subsequently password is asked and error occurs.

Answer 1

1. Open your SQL command line and type the following:

   SQL> connect / as sysdba
   

2. Once connected,you can enter the following query to get details of username and password:

   SQL> select username,password from dba_users;
   

3. This will list down the usernames,but passwords would not be visible.But you can identify the particular username and then change the password for that user. For changing the password,use the below query:

   SQL> alter user username identified by password;
   

4. Here username is the name of user whose password you want to change and password is the new password.

Answer 2

Go to SQL command line:- type:

sql>connect / as sysdba;

then type:

sql>desc dba_users;

then type:

sql>select username,password from dba_users;

If sysdba doesn't work then try connecting with username:scott and password: Tiger

You will be able to see all users with passwords. Probably you might find your's. Hope this helps