How to retrieve the Oracle user password

If you know about the Oracle user password, I would like to brief you here. You are welcome to join me in learning the Oracle user password.

1. Forgot the user logon password except for the Oracle sys and system users

Log On with Oracle sys and system users.

Conn sys/PASS_WORD as sysdba;

Use the following statement to modify the user password.

Alter user user_name identified by newpass;

Note: The password cannot be full of numbers. It cannot start with a number. Otherwise: ORA-00988: Password missing or invalid

Ii. Forget the Oracle user password

If you forget the password of the system user, you can use the sys user to log on. Then, use the alter user password command to change the password.

Conn sys // PASS_WORD as sysdba;

Alter user system identified by newpass;

If you forget the password of the SYS user, you can use the SYSTEM user to log on. Then, use the alter user password command to change the password.

Conn system // PASS_WORD;

Alter user system identified by newpass;

3. It is especially important to forget or lose the Oracle user password..

You can use ORAPWD. EXE to change the password.

Start Menu-> Run-> enter 'cmd', open the Command Prompt window, and enter the following command:

Orapwd file = D: \ oracle \ product \ 10.2.0 \ db_1 \ database \ pwdctcsys. ora

Password = newpass

This command re-generates the Database Password File. The password file is located in the \ database directory under the ORACLE_HOME directory.

This password is used to change the password of the sys user. The password of other users except sys and system will not change.

1. Oracle user password Modification Scheme
2. Oracle user password Modification
3. Easily fix Oracle user password changes
4. How to use Java stored procedures to communicate SQL statements in Oracle databases
5. Description of Oracle Database heterogeneous service principles