OPW-00021: Failed to retrieve DB password file location from the CRS resource

When create Oracle password file in ASM, the following errors occur:

$ orapwd file='+DATA1/TESTDB/PASSWORD/pwdTESTDB' dbuniquename='TESTDB'

Enter password for SYS:

OPW-00021: Failed to retrieve DB password file location from the CRS resource

RESOLUTION

Add database and instances into CRS by running ‘srvctl’, but do not specify “-pwfile ‘+DATA1/TESTDB/PASSWORD/pwdTESTDB’:

$ srvctl add database -d TESTDB  -oraclehome /u01/app/oracle/product/19.0.0/dbhome_1  -dbtype RAC  -domain world  -spfile +DATA1/TESTDB/PARAMETERFILE/spfileTESTDB.ora   -role PRIMARY  -startoption OPEN  -stopoption IMMEDIATE

then

$  orapwd file='+DATA1/TESTDB/PASSWORD/pwdTESTDB' dbuniquename='TESTDB'

Enter password for SYS:
SQL> select * from v$pwfile_users;

Run the following commnad, we can see ‘-pwfile ‘+DATA1/TESTDB/PASSWORD/pwdTESTDB’ has been added into configuration automatically when we create password file.

$ srvctl config database -d TESTDB
...
Database unique name: TESTDB
Database name:
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA1/TESTDB/PARAMETERFILE/spfileTESTDB.ora
Password file: +DATA1/TESTDB/PASSWORD/pwdTESTDB
Domain: world
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
...
..
.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.