Monday, January 5, 2015

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

PRCA-1057 : Failed to retrieve the password file location used by ASM asm
PRCR-1097 : Resource attribute not found: PWFILE

After upgrading your grid infrastructure 11g to 12c, you will notice that executing command “srvctl config asm” returns abovementioned error messages. This is because from 12.1 onwards, ASM instance registered as a resource “ora.asm” with GI, has an attribute named PWFILE which is currently not configured, because this ora.asm resource is upgraded from 11g where this PWFILE attribute did not exist. To resolve this problem, you would need to remove and add back the ASM to GI using following steps.


$ crsctl stop resource -all
$ srvctl remove asm -force
$ srvctl add asm -listener <listener> -spfile <spfile> -pwfile <orapwasm> -diskstring <path>

Before executing these steps, notedown your ASM spfile location on ASM by logging in to ASM from sqlplus and executing command “show parameter spfile”. You should also know your disk discovery path (diskstring) which needs to be specified while registering the ASM. Since I am using oracleASMLib, my diskstring path would be ‘ORCL:*’

[grid@salman1 ~]$ crsctl stop resource -all
CRS-2500: Cannot stop resource 'ora.db11g.db' as it is not running
CRS-2500: Cannot stop resource 'ora.diskmon' as it is not running
CRS-2500: Cannot stop resource 'ora.ons' as it is not running
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'salman1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'salman1'
CRS-2673: Attempting to stop 'ora.evmd' on 'salman1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'salman1'
CRS-2677: Stop of 'ora.CRS.dg' on 'salman1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'salman1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'salman1'
CRS-2677: Stop of 'ora.evmd' on 'salman1' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'salman1' succeeded
CRS-2677: Stop of 'ora.asm' on 'salman1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'salman1'
CRS-2677: Stop of 'ora.cssd' on 'salman1' succeeded
CRS-4000: Command Stop failed, or completed with errors.

[grid@salman1 ~]$srvctl remove asm –force

[grid@salman1 ~]$srvctl add asm -listener LISTENER -spfile +CRS/asm/asmparameterfile/registry.253.867318133 -pwfile $ORACLE_HOME/dbs/orapw+ASM -diskstring 'ORCL:*'

Now you can see that ASM is properly configured with GI

[grid@salman1 ~]$srvctl config asm
ASM home: <CRS home>
Password file: /u02/app/grid/product/12.1.0/grid/dbs/orapw+ASM
ASM listener: LISTENER
Spfile: +CRS/asm/asmparameterfile/registry.253.867318133
ASM diskgroup discovery string: ORCL:*

[grid@salman1 ~]$srvctl start asm


No comments: