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

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

[grid@oracle1 ~]$ 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
[grid@oracle1 ~]$

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

So , the solution is

[grid@oracle1 ~]$
[grid@oracle1 ~]$ crsctl stop resource -all
[grid@oracle1 ~]$ crsctl stat res -t
[grid@oracle1 ~]$ srvctl remove asm -force
[grid@oracle1 ~]$ 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"
[grid@oracle1 ~]$ crsctl start resource -all
[grid@oracle1 ~]$ 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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s