Oracle-L: RE: Database just stops

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 14 Oct 2003 13:24:27 -0800
Message-ID: <F001.005D315C.20031014132427@fatcity.com>

Thanks for the replies. The server admin fessed up and said he had bounced the server a few times to do some software installs.

Thanks!
Ron

	-----Original Message-----
	From: Stephane Paquette


[mailto:stephane.paquette_at_standardlife.ca] 

	Sent: Tuesday, October 14, 2003 4:10 PM
	To: Multiple recipients of list ORACLE-L
	Subject: RE: Database just stops
	
	
	If the archive destination is full then for sure the database
will stop but it will not crash.
	It's probably a bug, you should probably go to 8.1.7.4.
	 
	Talking about database stop, I just did an audit at a client
site, during my spare time. 
	The top 3 SQL:
	The first one was run 20 times per second and has 1280 gets
	The second one was run 14 times per minute and each execution
has 78091 gets
	The third one was run 1 per minute and each execution has 965637

gets.

	The database was really stopped !!!
	Of course the application vendor was talking about adding more

hardware ...

Stephane

		-----Original Message-----
		From: ml-errors_at_fatcity.com


[mailto:ml-errors_at_fatcity.com]On Behalf Of Oracle-L

		Sent: 14 octobre, 2003 16:40
		To: Multiple recipients of list ORACLE-L
		Subject: Re: Database just stops
		
		
		When you mean by "stops" - do u mean you are not able to

connect any more from sql*net ? or even the current sessions hang ?

Are you running this in archivelog mode ? Is it possible that the database is in archivelog more and the archiver is not running ?

Babu

Original Message ----- From: Smith, Ron L. <mailto:rlsmith_at_kmg.com> To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Tuesday, October 14, 2003 3:14 PM Subject: Database just stops

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: Smith, Ron L.
  INET: rlsmith_at_kmg.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 - 16:24:27 CDT