$ srvctl config asm ASM home: PRCA-1057 : Failed to retrieve the password file location used by ASM asm PRCR-1097 : Resource attribute not found: PWFILE
Check environment and password file:
$ echo $ORACLE_HOME /u01/app/grid/product/12.1.0/grid $ ls -l /u01/app/grid/product/12.1.0/grid/dbs total 28 -rw-rw---- 1 grid oinstall 2783 Jun 9 14:27 ab_+ASM.dat -rw-rw---- 1 grid oinstall 1544 Jun 9 14:27 hc_+ASM.dat -rw-r--r-- 1 grid oinstall 2992 Feb 3 2012 init.ora -rw-r----- 1 grid oinstall 8704 Jun 9 14:10 orapw+ASM -rw-r----- 1 grid oinstall 1536 Jun 9 14:27 spfile+ASM.ora
The password file was created and ORACLE_HOME is set correctly. Checked with DBA, the upgrade was done successfully. There was no errors/exceptions during upgrade.
Oracle Support explains that:
12c ASM instance has a attribute called PWFILE(password file), but 11g ASM does not. Looks like the upgrade utility does not create the new attribute for an ASM instance which is upgraded from 11g.
Try to manually re-create the ora.asm resource with -pwfile option:
$ crsctl status resource ora.asm NAME=ora.asm TYPE=ora.asm.type TARGET=ONLINE STATE=ONLINE on host01 $ srvctl stop asm PRCR-1065 : Failed to stop resource ora.asm CRS-2529: Unable to act on 'ora.asm' because that would require stopping or relocating 'ora.DATA.dg', but the force option was not specified $ srvctl stop asm -f $ $ srvctl config asm PRCR-1001 : Resource ora.asm does not exist $ $ srvctl add asm -listener LISTENER -spfile /u01/app/grid/product/12.1.0/grid/dbs/spfile+ASM.ora -pwfile /u01/app/grid/product/12.1.0/grid/dbs/orapw+ASM
Test if it is fixed:
$ srvctl sconfig asm ASM home: Password file: /u01/app/grid/product/12.1.0/grid/dbs/orapw+ASM ASM listener: LISTENER Spfile: /u01/app/grid/product/12.1.0/grid/dbs/spfile+ASM.ora ASM diskgroup discovery string: ++no-value-at-resource-creation--never-updated-through-ASM++
There is no error any more.
No comments:
Post a Comment