How to change the Oracle user password

If you do not know the password of the oracle database, you can use a simple command line to modify the password.

1. Open cmd

2. In the displayed Command Prompt window, enter set oracle_sid = Database Name (instance) and press Enter. For example, if the database name (Instance) is orcl, enter

Set oracle_sid = orcl and press Enter.

3 InputSqlplus'/As sysdbaOracleBackground Management Interface

4. ModifyOracleDatabaseSystemThe user password is manager.

Statement:Alter user system identified by manager;

Test whether the changed password can be properly logged on.

Statement: connect system/manager

 

You only need three codes to modify the password of a database user.

If you need to change the specified user password, or you need to restore the password after changing the password. This is the following step.

1. Open cmd

2. In the displayed Command Prompt window, enter set oracle_sid = Database Name (instance) and press Enter. For example, if the database name (Instance) is orcl, enter

Set oracle_sid = orcl and press Enter.

3 InputSqlplus'/As sysdbaOracleBackground Management Interface

4 inputSelect username, password from dba_users; find all user names and passwords.

Save the password of the user name to be restored after modification;

5. ModifyOracleDatabaseSystemThe user password is manager.

Statement:Alter user system identified by manager;

Test connect system/manager

 

6. Restore the system user password after use

Statement isAlter user system identifiedValues 'password you saved earlier ';