Forgot Oracle 11g Username and Password

In this post we will learn how to recover Forgot Oracle 11g Username and Password. Recently i have installed Oracle 11g on my system, after installation finish. When i try to login credentials i remember, i found that i have forgotten my credentials.

In my case i do not remember username, to retrieve my username i follow this step:

1. Open command prompt.

2. connect to SQLPLUS as sysdba. Got username from dba_users table as mentioned below.

sqlplus / as sysdba

select username,password from dba_users;

Now run following command to reset your username password.

alter user sysman identified by mann;

Here sysman is username and mann is password. Here we reset sysman password to mann.