How to recover Oracle users who forget their usernames and passwords

First, cmd-sqlplusw

Common User Logon: User name: scott (Common User Name) password: tiger (common user password)

Administrator Logon: User name: system password: system (administrator password)

Note the following when a super Administrator logs on: User name: sys password: sys as sysdba (sys is password)

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

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

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

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.

Change the password.

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.

Change the password.

Alter user system identified by newpass;

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

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. ora

Password = newpass

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

\ Database 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.

4. view the user list in the Oracle System

Select * from all_users;