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.