A. Forget the login password for users other than SYS and system users.
Log in 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 a number start. Otherwise it will appear: ORA-00988: Password is missing or invalid
Second, forget the SYS user, or the password of the system user.
If you forget the password of the system user, you can log in with the SYS user. Then change the password with alter USER Chitian.
CONN Sys//pass_word as SYSDBA;
ALTER USER SYSTEM identified by Newpass;
If you are forgetting the password of the SYS user, you can log in with the system user. Then change the password with alter USER Chitian.
CONN System//pass_word;
ALTER USER SYSTEM identified by Newpass;
Third, if the Sys,system user's password is forgotten or lost.
You can use the ORAPWD.EXE tool to modify the password.
Start menu, run as input ' CMD ', open a 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 regenerates the password file for the database. The location of the password file is under the/database directory in the Oracle_home directory.
This password is the password that modifies the SYS user. Passwords for other users except SYS and system will not change.
Oracle forgets the workaround for username and password