Cry about...
Oracle Troubleshooting

ORA-01990: Error opening password file ...

Symptom:

When creating the database (or at other times) the following error is generated:

ORA-01990: Error opening password file '...PWDOrcl.ora'

Where ‘Orcl’ is the SID of the database instance.

Cause:

Oracle indicate that this error is generated if the instance/SID specific password file does not exist and the init.ora parameter ‘REMOTE_LOGIN_PASSWORDFILE’ is set to ‘EXCLUSIVE’ or ‘SHARED’.

Possible Remedies:

• Edit the init.ora file and set the parameter ‘REMOTE_LOGIN_PASSWORDFILE’ to ‘NONE’, i.e.:

REMOTE_LOGIN_PASSWORDFILE = NONE

Be aware that this indicates to Oracle that there is no password file and therefore all uses must be authenticated using Operating System Authentication.

• Alternatly, create the password file:

orapwd file=<path>\PWD<sid>.ora password=oracle

Use the same path as given in the Oracle error.

Be aware that the Oracle database creation scripts may contain a command to delete the password file. Accordingly if this error is generated during database creation it may be worth adding this ‘orapwd ...’ line immediately after the ‘oradim ...’ command that creates the Oracle SID.