I doctor became too big to forget the Oracle SYS user and system user password, and after several attempts to log on to system, the system is locked.
After some attempt, finally solved. The process is as follows:
First, rebuild the sys password file. The Reconstruction method is:
1. Open cmd Command window;
2, execute orapwd command, its usage is:
C:\windows\system32>orapwd Usage:orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n> where File-name of password file (required), Password-password for SYS would is prompted if not specified at command line, Entries-maximum number of distinct DBA (optional), Force-whether to overwrite existing file (optional), Ignorecase-passwords is case-insensitive (optional), Nosysdba-whether to shut out of the SYSDBA logon (optional Database Vault only). |
The file option is the full path of the files, and the file name is pwd+ DB instance name + ". Ora". Password The password for the new setting.
The command format I executed is as follows:
C:\windows\system32>orapwd File=d:\oracle\product\11.2.0\dbhome_1\database\pwd****.ora password=****** Entries =5 Force=y |
(Note that it is a good idea to back up the original file before executing the Rebuild password file command)
After the command is executed, the new password file overwrites the original password file.
After restarting the Oracle database service, you can log in to sys with a new password.
The next step is to troubleshoot system user lockout issues.
In the CMD command window, connect to the database with Sqlplus.
C:\Documents and Settings\administrator>sqlplus sys/***** as Sysdba |
where * * Part is the login password.
Then execute the command to unlock the system.
Sql>alter user System account unlock; |
Finally, modify the password for the system user.
Sql>alter user system identified by **********; |
where the * * * section is the new password.
The system is unlocked and can be logged in with a new password.
Original link: http://www.lhtry.net/Blog/Detail?id=19
What if the Oracle database forgets SYS and the system password and system is locked?