Oracle forgot the sys/system/scott user password. How can I reset the oracle password ?, Scottoracle

Oracle forgot the sys/system/scott user password. How can I reset the oracle password ?, Scottoracle

I used the oracle database today, but I found that I forgot my previous password. I did not enter the correct password. So I found some information on the Internet, fixed the problem, and shared it with you.

 

I. Problems encountered:

1. Forget the logon password of a user except SYS and SYSTEM.

2. Forget the password of the SYS user or the SYSTEM user.

3. If the passwords of SYS and SYSTEM users are forgotten or lost.

 

Ii. solution:

1. Forget the logon password of a user except SYS and SYSTEM.

Log On As a sys (or SYSTEM) user and use the following statement to modify the user's password.

CONN SYS/PASS_WORD AS SYSDBA;ALTER USER SYSTEM IDENTIFIED BY newpass;

 

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

 

2. Forget the password of the SYS user or the SYSTEM user.

(1) 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;

 

(2) 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. If SYS and SYSTEM users forget or lose their passwords. This is particularly important. 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.orapassword=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.