RE: Database just stops, now 8.1.7 support

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Wed, 15 Oct 2003 06:44:30 -0800
Message-ID: <F001.005D33CB.20031015064430@fatcity.com>

Melanie,  

If we didn't have issues with CBO behavior differences, I would be pushing harder to move to 9.2.0.4. The only thing that saved a rollback to 8.1.7.4.6 was setting optimizer_features_enable=8.1.7.  

Paul

"Caffrey, Melanie" <mcaffrey_at_proximo.com> wrote: 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-----
Sent: Wed 10/15/2003 9:14 AM
To: Multiple recipients of list ORACLE-L Cc:

support for 8i has been extended to 12/31/2004

• "Caffrey, Melanie" 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: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 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." 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
  >
  

> - 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).

---

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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).


-- 
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).

---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.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 - 09:44:30 CDT