Sunday, 18 October 2020

OPW-00001: Unable to open password file

 When you try to create the password file in windows operating system for newly created database and for which we lost sys account password.

Here below I got error message, when I try to create password file:

C:\Users\oracle> orapwd file=C:\app\oracle\product\11.2.0\dbhome_1\database\pwddb02.ora password=manager entries=5 ignorecase=y

OPW-00001: Unable to open password file

cause:

1. missing privileges for oracle user.

2. missing proper grants to dba_ora group.

Solution:

add oracle user to dba_ora group.

correct the access levels for oracle home directory:


now you can create the password file.