Oracle

PRCA-1057 : Failed to retrieve the password file location used by ASM

Posted Anand

After the Oracle Restart (Grid Infrastructure) upgrade from 11.2. to 12.1.0.2 , you might encounter the below lines in the ASM alert log file

Tue Jun 23 01:16:01 2015
WARNING: unknown state for ASM password file location resource, Return Value: 3
WARNING: unknown state for ASM password file location resource, Return Value: 3

After the upgrade, below command can get the error

[[email protected] ~]$ srvctl config asm
ASM home: <crs home=''>
PRCA-1057 : Failed to retrieve the password file location used by ASM asm
PRCR-1097 : Resource attribute not found: PWFILE
[[email protected] ~]$

This issue is unpublished bug 19449701.From 12.1 onwards ASM instance has a new attribute called PWFILE.
So , the solution is

[[email protected] ~]$
[[email protected] ~]$ crsctl stop resource -all
[[email protected] ~]$ crsctl stat res -t
[[email protected] ~]$ srvctl remove asm -force
[[email protected] ~]$ srvctl add asm -listener LISTENER -spfile "+DATA/asm/asmparameterfile/registry.201.883099876" -pwfile "/oracle/grid/product/12.1/dbs/orapw+ASM" -diskstring "/dev/mapper/*p1"
[[email protected] ~]$ crsctl start resource -all
[[email protected] ~]$ srvctl config asm
ASM home:
Password file: /oracle/grid/product/12.1/dbs/orapw+ASM
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.201.883099876
ASM diskgroup discovery string: /dev/mapper/*p1

Reference :- Oracle Restart: WARNING: unknown state for ASM password file location resource, Return Value: 3 (Doc ID 1935891.1)

Leave a Reply