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)