RAC node crashed due to High CPU usage of ONS process
One node of our RAC database was showing high CPU utilisation against the ons process. Eventually the instance crashed. DB version is 10.2.0.3.0. Below are the ons log entries. Could some one throw some light into the reasons and provide solution for fixing this issue?
ORA_DEBUG=0 540 /u01/app/oracle/product/10.2.0/crs/bin/onsctl ping
2012-12-11 07:55:51.654: [ RACG][2540285184] [2019][2540285184][ora.xxxx.ons]: clsrcexecut: rc = 99, time = 540.080s
2012-12-11 07:55:51.654: [ RACG][2540285184] [2019][2540285184][ora.xxxx.ons]: end for resource = ora.jsdb1.ons, action = start, status = 1, time = 1080.200s
2012-12-11 07:57:21.646: [ RACG][2540285184] [24058][2540285184][ora.xxxx.ons]: onsctl: shutting down ons daemon ...
timeout: killed the spawned process
Regards
Rajeev