ORA-01991错误

来源：互联网发布：优学院软件下载编辑：程序博客网时间：2024/06/04 23:18

SQL> startup mount;
ORACLE instance started.

Total System Global Area 171966464 bytes
FixedSize                  787988 bytes
VariableSize            145488364 bytes
DatabaseBuffers          25165824 bytes
RedoBuffers                524288 bytes
ORA-01991: ???????'d:\oracle\product\10.1.0\db_1\DATABASE\PWDmyoracle.ORA'

Alertlog:

ORA-1991 signalled during: ALTERDATABASE MOUNT...

应该是当你重建了控制文件或数据库 ,remote_login_passwordfile=EXCLUSIVE or SHARED并且密码文件已经存在时会引起这个错误。

ORA-01991: invalid password file '/9.0.1/dbs/orapwv901' *****************************************************

When : After startup of instance Additional : Alert file shows:ORA-1991 signalled during: ALTER DATABASE MOUNT Database does notmount

Cause : Incorrect passwordfile

Solve : Restore original passwordfile to $ORACLE_HOME/dbs orrecreate it Also check Note 118367.1 and bug 994821 OR

When : After recreating controlfile or database Additional :remote_login_passwordfile=EXCLUSIVE or SHARED and passwordfilealready exists Alert file shows: ORA-1991 signalled during: ALTERDATABASE MOUNT Database does not mount Cause : Not correctlydocumented before 8.1.5 [BUG:507683]

Solve :

1. Set init.ora remote_login_passwordfile = NONE

2. Starting instance to create the database/controlfile

3. Recreate the passwordfile

重建密码文件：

C:\Documents and Settings\Administrator>orapwdfile=PWDmyoracle.ora password=tes
t entries=5;
生成的文件在当前目录下,拷贝放到D:\oracle\product\10.1.0\db_1\database下

Startup;

正常启动

0 0