Forget oracle database username or password

 

Forget oracle database username or password

Recover oracle database username and password

Step-1: open sqlplus.

Step-2: type- connect / as sysdba   and password will be blank so just enter.

Step-3: Now you can see SQL> 

Step-4: To get all user type following query-

    SQL> select username,password from dba_users;

now find the user which you have created from the shown list and reset password by following query-

    SQL> alter user username identified by password;

Here username is the user for which you want to reset the password.

Create new user-

Step-1: open sqlplus.

Step-2: type- connect / as sysdba   and password will be blank so just enter.

Step-3: Now you can see SQL> 

Step-4 :To create new user type following query-

create user NewUserName identified by password

note: if you get "create user invalid common user or role name" error then just change the session by type following query-

    alter session set "_ORACLE_SCRIPT"=true;   

and try again to create user by step-4.

Step-5: Grant Previlage to oracle user (With DBA power)-

    GRANT CONNECT, RESOURCE, DBA TO NewUserName;

To grant all role to user-

    GRANT ALL PRIVILEGES TO NewUserName;