When trying to open (or mount) a database the following error is generated:ORA-01991: invalid password file '...PWDOrcl.ora'Where ‘Orcl’ is the SID of the database instance.Cause:
Typically some corruption of the password file, or possibly the password file is for another database instance?Possible Remedies:
If encountered when creating the database then it is because Oracle expects to create the password file but it already exists. In this instance database creation will have failed. Delete the password file and try again.If it is suspected that the password file is corrupt then try deleting it and recreating it:Delete the existing password file.Create a new/replacement password file:orapwd file=<path>\PWD<sid>.ora password=oracleUse the same path as given in the Oracle error. The password specified will be the new internal password.
--------------------------------------------------------------------------------
Typically some corruption of the password file, or possibly the password file is for another database instance?Possible Remedies:
If encountered when creating the database then it is because Oracle expects to create the password file but it already exists. In this instance database creation will have failed. Delete the password file and try again.If it is suspected that the password file is corrupt then try deleting it and recreating it:Delete the existing password file.Create a new/replacement password file:orapwd file=<path>\PWD<sid>.ora password=oracleUse the same path as given in the Oracle error. The password specified will be the new internal password.
--------------------------------------------------------------------------------
遭到破坏或不存在,解决办法:
先将PWDgdsmart.ORA剪切到其它地方(等数据库启动成功后再删除),
运行下面命令建立密码文件:
c:\orapwd file=d:\Oracle\Ora81\DATABASE\PWDgdsmart.ORA
password=password entries=10 /**其中参数password与entries可以修改。**/
再启动数据库。