Forget the login password for users other than SYS and system users.
Log on with the SYS (or system) user.
CONN Sys/pass_word as SYSDBA;
Use the following statement to modify the user's password.
ALTER USER user_name identified by Newpass;
Note: Passwords cannot be all numbers. and cannot be the beginning of a number. Otherwise, it will appear: ORA-00988: Password missing or invalid
The forgotten sys user, or the password of the system user.
If you are forgetting the password for the system user, you can log in with the SYS user. Then use the Alter USER's
Modify the password.
CONN Sys//pass_word as SYSDBA;
ALTER USER SYSTEM identified by Newpass;
If you are forgetting the password for the SYS user, you can log on with the system user. Then use the Alter USER's
Modify the password.
CONN System//pass_word;
ALTER USER SYSTEM identified by Newpass;
If the password of the Sys,system user is forgotten or lost.
This is particularly important.
You can use the ORAPWD.EXE tool to modify your password.
Start Menu-> Run-> enter ' CMD ', open a Command Prompt window, enter the following command:
Orapwd File=d:\oracle\product\10.2.0\db_1\database\pwdctcsys.ora
Password=newpass
This command regenerates the password file for the database. The location of the password file is in the Oracle_home directory
In the \database directory.
This password is the password that modifies the SYS user. Passwords for other users except SYS and system will not change.