oracle resets the sys password

  • 2020-12-10 00:54:40
  • OfStack

How do I reset the password for oracle 10g SYS
After installing oracle 10g, I even forgot the system password set at the time of installation. With the help of colleagues, solve the problem through 1 method.
1. The password file for oracle exists in: oracle_home/database/pwd < sid > .ora
2. Reset the SYS password using orapwd
C:oracleproduct10.2.0db_1database > orapwd
Usage: orapwd file= < fname > password= < password > entries= < users > force= < y/n >
C:oracleproduct10.2.0db_1database > 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 sys user password for oracle
1. Search the PWD database instance name.ora file under the oracle installation directory
2. Backup 1 copy of password file (1 make sure to avoid accidents)
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= numeric value
Note: file represents the full path to the password file (to match the 1 just found)
password stands for new password
entires represents the largest number of users logged on to sys
If you want the new password to take effect, you need to restart the database instance
In particular, enter orapwd under dos for detailed instructions.

Related articles: