How to reset the password of oracle 10g SYS
After installing oracle 10 Gb, the system password set during installation is forgotten. Solve the problem with the help of a colleague.
1. The oracle password file exists in: oracle_home/database/pwd <sid>. ora
2. Use orapwd to reset the SYS Password
C: oracleproduct10.2.0db _ 1 database> orapwd
Usage: orapwd file = <fname> password = <password> entries = <users> force = <y/n>
C: oracleproduct10.2.0db _ 1 database> orapwd file = PWDorcl. ora password = 20120020
Entries = 5 force = y
Where
File-name of password file (mand ),
Password-password for SYS (mand ),
Entries-maximum number of distinct DBA and force-whether to overwrit
E existing file (opt ),
OPERs (opt ),
There are no spaces around the equal-to (=) character.
Reset the oracle sys User Password
1. Search for the PWD database instance name. ora file in the oracle installation directory.
2. Back up a password file (Be sure to avoid exceptions)
3. generate a new password file and enter the command in the dos Console
Orapwd file = PWD database instance name. ora file path \ PWD database instance name. ora password = new password entires = Value
Note: file indicates the full path of the password file (consistent with the one just found)
Password indicates the new password.
Entires indicates the user with the most logon sys
If you want the new password to take effect, restart the database instance.
Note: The input of orapwd in dos has a detailed prompt.