What if I forget the password of the Oracle database user?

What if we forget the user's password for the Oracle database and do not know the password of the user who is larger than the user's rights?

Don't worry, as long as you have installed the database server operating system users, then you can easily solve, and the method described in this article is very general Oh ~

In fact, the principle is very simple, is to take advantage of Oracle's operating system authentication method.

Steps:

1. Log on to the operating system where the Oracle database server is installed.

2, check the environment variable ORACLE_SID settings:

Windows:echo%oracle_sid%

Linux:echo $ORACLE _sid

3. Set the value of the environment variable ORACLE_SID to the SID of the Oracle instance you want to log on to:

Set ORACLE_SID=ORCL

4. Type the command: Sqlplus/as SYSDBA

You can log in to Oracle as a SYSDBA!

Under Linux, if the Sqlplus command cannot be found, switch to the Oracle user.

5. Execute the command in the Sqlplus window:

Alter user you_username identified by You_password;

You can change your user's password ~

What if I forget the password of the Oracle database user?