The scary part is that it is (was I guess), a very low-concurrency fledgling
datawarehouse-type instance. The rest of our shop is very high-transaction
oltp.
Still, I just chalk it up to a lesson learned. It was built out on 9i as an
opportunity to try out 9i.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 3:36 PM
so if more than one person selects from a given object, you die?
they aren't particularly forthcoming on what the bug really is.
>From: "George Schlossnagle" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: database upgrade policy?
>Date: Thu, 23 Aug 2001 11:16:02 -0800
>
>Sure. We seemed to be suffering from bug 1904199 or a variant. We
>experienced frequent deadlocks on resources:
>
>Sat Aug 4 08:03:21 2001
>Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:
>ORA-00060: deadlock detected while waiting for resource
>Sat Aug 4 08:03:25 2001
>Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:
>ORA-00060: deadlock detected while waiting for resource
>Sat Aug 4 08:03:29 2001
>Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:
>ORA-00060: deadlock detected while waiting for resource
>Sat Aug 4 08:03:34 2001
>Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:
>ORA-00060: deadlock detected while waiting for resource
>Sat Aug 4 08:03:38 2001
>Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:
>
>followed by 7445s and 600s and then SMON terminating
>
>After one of these crashes, we were unable to reopen the database:
>
>
>Then one day on trying to reopen the database following
>
>Errors in file /opt/db/oracle/admin/report/udump/report_ora_14226.trc:
>ORA-00600: internal error code, arguments: [kteoprpect-1], [2], [1], [],
>[], [], [], []
>Sun Aug 12 21:38:45 2001
>Errors in file /opt/db/oracle/admin/report/udump/report_ora_14226.trc:
>ORA-00600: internal error code, arguments: [kteoprpect-1], [2], [1], [],
>[], [], [], []
>Sun Aug 12 21:38:45 2001
>Error 600 happened during db open, shutting down database
>USER: terminating instance due to error 600
>Instance terminated by USER, pid = 14226
>ORA-1092 signalled during: alter database open...
>
>Our support analysts saud that a fix was in progress and that there was no
>known way to recover, even an ALTER DATABASE OPEN RESETLOGS. A choice
>tidbit from the bug report:
>
>"This could be quite serious for customers as there is no simple way out of
>this scenario."
>
>Buyer beware.
>
>
>
> ----- Original Message -----
> From: JOE TESTA
> To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
> Sent: Thursday, August 23, 2001 2:08 PM
> Subject: Re: database upgrade policy?
>
>
> George, are you willing to expand on what it was, for the rest of us?
>
> joe
>
>
> >>> [EMAIL PROTECTED] 08/23/01 02:52PM >>>
> We just had a total database lost under 9i. Known bug, no workaround,
> better-luck-next-time type situation. Luckily for us we were testing it
>on
> a non-critical database, but that puts me off it for a while.
>
> George
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, August 23, 2001 1:27 PM
>
>
> Good for you, David. We are moving in that direction, too. I convince
> people by saying 9i is really 8.2.
>
> Paul Baumgartel
> MortgageSight Holdings, LLC
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> Sent: Thursday, August 23, 2001 12:41 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Okay, I know some of you are going to call me crazy but here goes...
>
> **We're now using 9i in Production**
>
> There, I admit it. But I have to ask you this- do you think 9i will be
>more
> buggy than the 8.1.6 that we were running that was causing core dumps,
> referential integrity violations, etc.? I'm betting that 9i will be at
> least a little bit better than that. Performance should be better too.
>
> I'll report back any gotchas (there are bound to be some!).
>
>
> david
>
>
>
> -----Original Message-----
> Sent: Thursday, August 23, 2001 9:46 AM
> To: Multiple recipients of list ORACLE-L
>
> Paul,
> No it's more like, "Hey, I heard there is a new version of the
> database
> out, do we have it yet? Why not? Can we have it? Yeah let's do it,
>that
> would be cool. Oh and by the way I installed a beta service pack on my
> machine, that's ok right?"...crap like that:)
> KK
>
> -----Original Message-----
> Sent: Wednesday, August 22, 2001 6:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Kevin,
>
> What do you mean?
> (running 8.1.7.2.1 on the destructo box, 8.1.7.1.5 on the development
>box,
> W2K Pro)
>
> Paul
>
>
> -------- Original Message --------
> Date: Wed, 22 Aug 2001 14:06:39 -0800
> Reply-To: [EMAIL PROTECTED]
> Organization: Fat City Network Services, San Diego, California
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>
> I have people here who just want to upgrade for the sake of
> upgrading...rriiiiggghhhhtttt..ok.:)
> KK
>
> -----Original Message-----
> Sent: Wednesday, August 22, 2001 5:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Well, we wanted to upgrade from 8.0.4 to 8.1.6 last year because it had
> been
> desupported. We got most of the machines upgraded except for the main
> production machine. I wanted to upgrade that last September. I have
> finally gotten permission to tentatively schedule the for next month
> (one
> year later), just in time for the 8.1.6 desupport notice. Sigh.
>
> -----Original Message-----
> Sent: Wednesday, August 22, 2001 3:36 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Lisa,
> You need some work to do....
> Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?
> ROR mô¿ôm
>
> >>> [EMAIL PROTECTED] 08/22/01 12:45PM >>>
> Don't upgrade unless there is a very good reason.
>
> All of these are candidates
>
> 1. current oracle version is unstable
> 2. specific bug addressed by an upgrade/patch, as identified by support
> 3. need to utilize new feature
> 4. desupport date coming up.
>
> If it works, don't fix it!
>
> Don't do it just for fun. Because it can turn into HELL.
>
> Lisa Koivu
> Certifiable Gimp Monkey (and DBA)
> Ft. Lauderdale, FL, USA
>
> > -----Original Message-----
> > From: Mark Marsden [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 22, 2001 11:45
> > To: Multiple recipients of list ORACLE-L
> > Subject: database upgrade policy?
> >
> > Hi Listers
> >
> > I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
> > as I get the occasional ORA-600/ORA-7445.
> >
> > Do you upgrade to the latest subversion as a matter of policy
> > (and not test very much) to prevent possible errors
> > or only upgrade if you have problems?
> >
> > Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
> > functionality, cos Oracle are desupporting (the main reason we
>upgrade)
> > or to improve the CV ;-) with the possible downside of instability.
> >
> > Mark.
> >
> >
> >
>**************************************************************************
> > ******************************************************
> > Hyde Housing Association - Email Disclaimer
> >
> > The information in this email is strictly confidential and may be
>legally
> > privileged.
> >
> > It is intended solely for the addressee only. Access to this email by
> > anyone else is unauthorised.
> > If you are not the intended recipient and you have recieved this email
>in
> > error you must take no action
> > on its contents, nor must you copy or show them to anyone, or make use
>of
> > the information therein.
> > Please reply to the email immediately, or forward to
> > [EMAIL PROTECTED], highlighting
> > the error and confirming that it has been deleted from your system.
> >
> > SECURITY WARNING: Please note that this email has been created
>with
> > the knowledge that the Internet
> > is not a 100% secure communications medium. We advise that you
>understand
> > and observe
> > this lack of security when e-mailing us.
> > VIRUSES: Although we have taken steps to ensure that this email
>and
> > attachments are free
> > from any virus, we advise that in keeping with good computing practise
>the
> > recipient should ensure
> > that they are actually virus free.
> >
>**************************************************************************
> > ******************************************************
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mark Marsden
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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.com
> --
> Author: Ron Rogers
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author: Miller, Jay
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author: Kevin Kostyszyn
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author: Paul Drake
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author: Kevin Kostyszyn
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author: David Wagoner
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author: Paul Baumgartel
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author: George Schlossnagle
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: George Schlossnagle
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
