ORA-15040 ORA-15042 with EXTERNAL redundancy Diskgroup

A colleague was working on an ASM issue (Standalone one, Version 11.2.0.3 on AIX) at one of the customer sites. Later on, I also joined him. The issue was that the customer added few news disks to an existing diskgroup. Everything went well and the rebalance kicked in. After some time, something happened and all of a sudden the diskgroup was dismounted. While trying the mount the diskgroup again, it was giving ...

November 3, 2017 at 11:27 PM · 4 min · 715 words · Amardeep Sidhu

ERROR: SPFile in diskgroup <> does not match the specified spfile

Just a stupid error. Posting it so that someone else googling for the same thing can get a clue. An ASM instance running with default parameters (no pfile, no spfile). Updated spfile for the instance with asmcmd spset command and bounced crs. After reboot also, it still wasn’t using spfile. Got puzzled and checked GPnP settings again. All looked good. Then in alert log came across this [text]ERROR: SPFile in diskgroup <> does not match the specified spfile +DATA/asm/asmparameterfile/registry.253.769187275[/text] ...

September 20, 2016 at 10:12 PM · 1 min · 120 words · Amardeep Sidhu