how to reset sys password in oracle

来源:互联网 发布:淘宝店铺招牌模板图 编辑:程序博客网 时间:2024/05/08 21:49
1. delete the old password file. path:oracle/product/10.2.0/db_1/database/PWD***.ora
2.start db instance
3.run the orapwd command in command line.

c:/>orapwd file=%oracle_home%/database/pwd%oracle_sid%.ora password=yournewpassword entries=5


usage:
C:/Documents and Settings/xl>orapwd
Usage: orapwd file=<fname> password=<password> entries=<users>

where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.