What should I do if I forget my Oracle password?

What should I do if I forget my Oracle password? Sometimes we may forget the password of a user, but we need to do some operations with this user, and we cannot modify the password of this user. At this time, we can use some tips, to complete the operation. You can change the password as follows:

1. open cmd, enter sqlplus/nolog, press enter, enter "conn/as sysdba", and enter "alter user sys identified by new password". Note: it is best to start the new password with a letter, otherwise the error Ora-00988 may occur. With this method, as long as you have administrator permissions on the oracle server, you do not have to worry about the Oracle password. You can change the password at will.

2. Execute the following command on the command line: sqlplus "/@ service name as sysdba", and then alter user sys identified by new password in sqlplus;
Alter user system identified by new password;

3. Run the command to the C root directory.
1) input: SET ORACLE_SID = your SID Name
2) input: sqlplus/nolog
3) input: connect/as sysdba
4) input: alert user sys identified by sys
5) input: alert user system identified by system
6) The password is the initial password of the Oracle database. In this way, you can modify the Oracle password if you forget it.

4. first, enter SQLPLUS/NOLOG in CMD, and then enter CONN/as sysdba in the displayed interface. In this way, the user logged on to the local system will trust the user to access the database. there are two ways to solve this problem: alter user username) identified by "password", which can change the USERNAME Password. of course, this USERNAME must already exist.
The other method is: create user (USERNAME) identified by "password"; the command to Change USER Permissions is grant roles tousername); the above two methods are for the ORACLE 9I version.

5.use the orapwd.exe command to modify the command. Even if the Oracle password is forgotten, it can be changed many times.
Orapwd file = '/oracle/pwdsid. ora' password = 123456 this command is used to change the password of the sys user. You overwrite the original password file. The password of other users except sys and system will not change.

6. su-oracle
Sqlplus/nolog
Conn/as sysdba
Startup (start if the database is not in the startup status)
Alter user sys identification by 123456
Then you can use the sys user password to log on.

1. Oracle password cracking for Database Administrators
2. Oracle Password File learning experience
3. FAQs about Oracle password security
4. Two solutions for Oracle password loss
5. Five key points of Oracle password management