RE: What makes Oracle DB shutdown automatically?

[Naveen Nahata]

The database normally doesn't shutdown automatically. If there are errors which inhibit DB operations oracle shuts down the instance and writes the error in the <sid>alert.log file. This file can be found at the location specified by background_dump_destination init.ora parameter.   You can open the alert.log file in a text editor and scroll to see the error which resulted in the Shutdown. Then you can lookup the error in Oracle's Error Messages manual, which might give you the explanation of the error and a possible solution. If it doesn't you can search metalink/google for the error message or post it in this mailing list to get the solution.   Regards Naveen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject: What makes Oracle DB shutdown automatically? Dear all DBAs,   I wonder what're the possible reasons that make Oracle DB shutdown automatically? Linux is running well. It first running very slow and suddenly shutdown.   Running Oracle 8.0.5 on Linux.   Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA.   Thanks in advance.