I have Oracle9.1 running under Win2K. We are experiencing database crashes where the Oracle service suddenly crashes out. The only message is in the system event log for Service Manager that the service has crashed. No other peculier messages are present in any Oracle logs either. We have not been able to determine any events or activities that consistently preceed the crash. We have moved to another server with a fresh OS installation and the problem persists.
The crash frequency is also not consistent. It works for a month and then crashes a few times and then works. The system is not overloaded and we have monitored the system parameters preceeding the crash and no peculiar patterns were evident.
We have VB applications accessing the database and have observed that once when the application was restarted the DB service crashed but this is not consistent.
I am now all out of options.
I've never seen the Oracle database crash suddenly like you mention without issuing some sort of trace or error information. Make sure you fully examine your Alert log for clues to the crash. Also check the USER_DUMP_DEST, BINARY_DUMP_DEST, and CORE_DUMP_DEST directories for any trace files. Also check %ORACLE_HOME%database directory for any information. You might also want to consider patching to Oracle 18.104.22.168 as this may fix known bugs.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.