xxxxxx-oracle/xxxxxx02 [3]: oerr ORA 472
00472, 00000, "PMON process terminated with error"
// *Cause: The process cleanup process died
// *Action: Warm start instance
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Other than 00472, 00000, "PMON process terminated with error", is there anything else ? I have no trace file generated. No error in the event viewer. I have to identify the cause but still fuzzy about what could go wrong. The only thing happen prior to the shutdown was someone was running several processes through Business Objects and Toad. Not sure if anything hang or not but the person who was running was the one called.
Please check Oracle's Alert Log around your ORA-00472 looking for other errors, also check if Oracle generated a Trace file around the time the instance crashed.
If some additional information is available chances are t was reported in the form of a Trace file.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Originally Posted by sfgaldba
Bookmarks