How to reset the sys password in oracle

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.