RE: Database just stops
Oh, OK. I just looked at Metalink and saw that this announcement took place less than
a week ago.
I guess the original announcement of desupport panicked quite a few people. Hence the
extension.
Anyway, since I've already recommended upgrades to 9i, I'm going to stick with it.
No reason to encourage anybody to stick with old technology unless they are in dire
financial straits ...
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]
Sent: Wed 10/15/2003 9:14 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: Database just stops
support for 8i has been extended to 12/31/2004
--- "Caffrey, Melanie" <[EMAIL PROTECTED]> wrote:
> 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:[EMAIL PROTECTED]
> 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 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." <[EMAIL PROTECTED]> 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
RE: Database just stops
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:[EMAIL PROTECTED] 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 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." <[EMAIL PROTECTED]> 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%3A15443%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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: guidance
lude 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).
> > >
> >
> >
> >
> >
> > Note:
> > This message is for the named person's use only.
> It may contain
> confidential, proprietary or legally privileged
> information. No
> confidentiality or privilege is waived or lost by
> any mistransmission.
> If
> you receive this message in error, please
> immediately delete it and all
> copies of it from your system, destroy any hard
> copies of it and notify
> the
> sender. You must not, directly or indirectly, use,
> disclose,
> distribute,
> print, or copy any part of this message if you are
> not the intended
> recipient. Wang Trading LLC and any of its
> subsidiaries each reserve the
> right to monitor all e-mail communications through
> its networks.
> > Any views expressed in this message are those of
> the individual
> sender,
> except where the message states otherwise and the
> sender is authorized
> to
> state them to be the views of any such entity.
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> > INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
> >
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: <[EMAIL PROTECTED]
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Cary Millsap
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"
_
RE: RE: Oracle Press OCP exam guide frustrations
-- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rajesh Dayal > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Express yourself with MSN Messenger 6.0 -- download now! http://www.msnmessenger-download.com/tracking/reach_general -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Caffrey, Melanie INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
