ORACLE.EXE Hangs using 100% CPU - reboot needed
Posted on 2003-11-18
We've been having a problem with our Production Oracle database where the ORACLE.EXE process will consume 100% of the CPU. At this point, we are unable to use and/or make any connections to the database at all, nor can we cleanly shutdown the instance... our only solution is to reboot the server, at which point it works fine again.
This has happend with both 126.96.36.199 and 188.8.131.52.1. The server is a Windows 2000 Advanced Server w/ clustering, service pack 3, Quad 900Mhz CPUs and 8GB ram.
The problem first happend on 8/27 the day after we had installed McAfee Anti-Virus on all our servers including this one. We immediately disabled all of the McAfee services, but this problem has happend again on 9/9 at 5pm, 10/17 at 3pm, 11/10 at 6am, and this morning 11/18 at 5a while hot backups were still running. We don't get anything useful in the Alert logs or Trace files that has pointed us to a specific problem.
If anyone has any suggestions on what to look at next that would be very helpful.