Oracle-L: RE: What makes Oracle DB shutdown automatically?

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Mon, 25 Nov 2002 01:49:02 -0800
Message-ID: <F001.0050A7F9.20021125014902@fatcity.com>

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-----
Sent: Monday, November 25, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L

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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Naveen Nahata
INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Nov 25 2002 - 03:49:02 CST