Resolve ORA-01991 Error: rebuilding password file

Source: Internet
Author: User
Statistics server Test No problem, just the last time the system has a problem, so reload, configure security policy (recently in the study of how to configure a new server, the first time to configure the relevant security settings, and then write down).
For easy, direct cold backup Oracle data files, installed Oracle, directly restore to the original directory.
To start, to appear:

Sql> Startup
The ORACLE routine has started.

Total System Global area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database buffers 25165824 bytes
Redo buffers 667648 bytes
ORA-01991:??????? ' D:\oracle\ora92\DATABASE\PWDora9.ORA '

Workaround, the Oracle password file is rebuilt using ORAPWD because it is not running in archive mode:

C:\>orapwd/help
Usage:orapwd file= password=entries=

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.

Sql> Host del D:\oracle\ora92\DATABASE\PWDora9.ORA

Sql> host Orapwd File=d:\oracle\ora92\database\pwdora9.ora Password=oraclepass E
ntries=10

sql> ALTER DATABASE open;

The database has changed.

When you log in again, you should enter the old database password;

More specific and complete recovery can refer to:

Http://www.dbonline.cn/source/oracle/20031214/resume%20database%20example.html

In fact, more than a year to solve a lot of similar problems, including Linux, Oracle, Windows Server, Cisco routing, switches, application server ..., but many, online already have ready-made solutions can be found, it is rarely posted.

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.