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
...
..
.