Solving the bug – ORA-07445 [KFKPROCESSREQ()+429] in ASM instance
Posted by Kamran Agayev A. on July 10th, 2012
Today, one of the instances of 2 node RAC went down with ORA-07445 error. After checking metalink, I found out that this is a bug:
Bug 10422354: ORA-07445 [KFKPROCESSREQ()+429] [SIGSEGV] ON ASM INSTANCE
And it happens after the upgrade of RAC to 10.2.5 patchset. Unfortunately there was no workaround suggested by support. After checking ASM log file again, I find the following error:
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
The ASM instance was not mounting. The instance wasn’t able to find the shared storage, so I changed asm_diskstring parameter as follows:
[php]asm_diskstring=’/dev/mapper/*'[/php]
It was a test RAC environment, both ASM instances were using different initialization parameter files (however, both database instances were using the same shared initialization parameter file)
I’ve created new server parameter file from the existing one, put it in the shared folder, changed parameter file of each instance (pfile=’/shared_folder/spfile+ASM.ora’) and started the failed ASM instance. Fortunately, it has started. Then I restarted the second ASM instance to make it use the shared parameter file and both instances were up
July 10th, 2012 at 1:36 pm
Hi Kamran,
Yesterday we applied 10.2.0.5.6 PSU on 10.2.0.4 on PROD database, luckly we didn’t faced this issue since we are not using ASMLib else i would have been running pillar to post for workarounds
Thanks for the post.
Raheel Syed
July 11th, 2012 at 7:59 am
Thanks for shared experience!
Mahir