What should I do if I forget my Oracle password?

Solution for forgotten oracle password: First log in to the operating system where the oracle database server is installed; then look for the setting of the environment variable [ORACLE_SID]; finally enter the command [sqlplus/as sysdba] and log in as sysdba. Can.

Solution for forgotten oracle password:

1. Log in to the operating system where the oracle database server is installed. Open the command window: (My demonstration machine is windows)

2. Check the setting of the environment variable ORACLE_SID:

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 in: set ORACLE_SID=orcl

4. Type the command: sqlplus/as sysdba

to sysdba Log in to oracle with your identity!

Under Linux system, if you cannot find the sqlplus command, please switch to the oracle user.

5. Execute the command in the sqlplus window:

alter user you_username identified by you_password;

to change your user’s password~

Related learning recommendations: oracle database learning tutorial

The above is the detailed content of What should I do if I forget my Oracle password?. For more information, please follow other related articles on the PHP Chinese website!