Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database just stops

RE: Database just stops

From: Caffrey, Melanie <mcaffrey_at_proximo.com>
Date: Wed, 15 Oct 2003 04:39:28 -0800
Message-ID: <F001.005D33AA.20031015043928@fatcity.com>


Paul,  

My question is a little off-topic here, but since Ron has already discovered the source of his problem ...  

You state below that Oracle has "extended support for a year of 8.1.7".  

What do you mean exactly? For instance, when does support actually end, then?  

The reason I ask is that the word from Ken Jacobs in September was that 8i would only be supported through the end of this calendar year.  

This is incredibly relevant information, for I will have to guide my clients accordingly.  

Regards,
Melanie

	-----Original Message----- 
	From: Paul Drake [mailto:discgolfdba_at_yahoo.com] 
	Sent: Tue 10/14/2003 4:59 PM 
	To: Multiple recipients of list ORACLE-L 
	Cc: 
	Subject: Re: Database just stops
	
	
	Ron,
	 
	Its highly likely that if you were to open a TAR on this, that the analyst would recite the following:
	 

"please apply the currently supported patchset" - which would be 8.1.7.4.1.
Unfortunately, there are numerous security fixes that have been made available that are not in a full patchset release (one that can be applied with OUI) - e.g. patchset 8.1.7.4.12. I'd recommend having the security fixes in place, but Oracle is less than wonderful about how they word the use of one-off patchsets. So, if you're risk-averse in terms of applying patchsets instead of being risk-averse in terms of some user running load<something> with a long username/password and crashing the instance (security), at least apply the 8.1.7.4.1 patchset. There is exploit code in the wild (shipped by oracle) that can crash an instance. You should be able to find an entry in the listener.log file for this. It is highly unlikely that this is causing the crash, however. (email me backchannel, as I don't want to IMHO: Oracle should release an 8.1.7.5.x patchset so that the security fixes are in a full patchset release. Now that they've extended support for a year of 8.1.7, there really isn't an excuse not to. Unless you get lucky, you're going to have to apply a patchset. So why not just apply the patchset (properly, after reading the release notes, full backups, exports, etc) and see if that takes care of the problem? More often then not, the issue has been encountered by some other user, they filed a tar >> bug report >> bug fix >> patch (a lengthy process). hth. Paul
"Smith, Ron L." <rlsmith_at_kmg.com> wrote:
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

	Do you Yahoo!?
	The New Yahoo! Shopping <http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail>  - with improved product search

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Caffrey, Melanie
  INET: mcaffrey_at_proximo.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 Wed Oct 15 2003 - 07:39:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US