Oracle-L: RE: Database just stops

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Tue, 14 Oct 2003 12:39:24 -0800
Message-ID: <F001.005D3153.20031014123924@fatcity.com>

Hi Ron...

You need to poke it and find out what's it's doing... I'd start with the following Metalink notes...

Note 175006.1
Note 215858.1
Note 61552.1

They cover diagnosing database hanging issues...

SYSTEMSTATE AND HANGANALYZE DUMPS OH MY! Good luck...

Tim

-----Original Message-----
Sent: Tuesday, October 14, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L

I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops.

When I restart the database it goes through crash recovery but comes up fine.

Anyone have any ideas?

Thanks!
Ron Smith

--

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

Author: Johnston, Tim
INET: TJohnston_at_quallaby.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 Tue Oct 14 2003 - 15:39:24 CDT