ORA-01991 invalid password file

来源：互联网发布：大数据培训机构靠谱吗编辑：程序博客网时间：2024/05/22 12:41

开发报过来一个错误，建库一看数据库在mount状态，alter日志也显示为mount，然后就停库起库。结果出问题了。

SQL> startup mount;
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
ORA-01991: ' /paic/g4cs2030/stg/9i/otzj9i/app9i/oracle/product/9.2.0/dbs/orapw'

查看alert日志：

ORA-1991 signalled during: ALTER DATABASE MOUNT...

查了下ORACLE文档

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

Cause : Incorrect passwordfile

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

When : After recreating controlfile or database Additional : remote_login_passwordfile=EXCLUSIVE or SHARED and passwordfile already exists Alert file shows: ORA-1991 signalled during: ALTER DATABASE MOUNT Database does not mount Cause : Not correctly documented 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

看来是remote_login_passwordfile=EXCLUSIVE or SHARED这个引起的。修改为remote_login_passwordfile=NONE，或者重建一下密码文件，删除原来的，将重建的密码文件改为原来的名字即可。

$ orapwd file=/paic/g4cs2030/stg/9i/otzj9i/app9i/oracle/product/9.2.0/dbs/orapwSID' password=sys entries=10;

$ mv orapw orapw.bak

$ mv orapwSID orapw

然后起库就可以了。