From george@omniti.com Thu, 23 Aug 2001 11:17:57 -0700 From: "George Schlossnagle" Date: Thu, 23 Aug 2001 11:17:57 -0700 Subject: Re: database upgrade policy? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Sure.  We seemed to be suffering from bug 1904199 or a variant.  We experienced frequent deadlocks on resources:   Sat Aug 4 08:03:21 2001Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:ORA-00060: deadlock detected while waiting for resourceSat Aug 4 08:03:25 2001Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:ORA-00060: deadlock detected while waiting for resourceSat Aug 4 08:03:29 2001Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:ORA-00060: deadlock detected while waiting for resourceSat Aug 4 08:03:34 2001Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc:ORA-00060: deadlock detected while waiting for resourceSat Aug 4 08:03:38 2001Errors 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 2001Errors 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 2001Error 600 happened during db open, shutting down databaseUSER: terminating instance due to error 600Instance terminated by USER, pid = 14226ORA-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: ORACLE-L@fatcity.com ; george@omniti.com 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 >>> george@omniti.com 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 ona non-critical database, but that puts me off it for a while.George----- Original Message -----To: "Multiple recipients of list ORACLE-L" Sent: Thursday, August 23, 2001 1:27 PMGood for you, David.  We are moving in that direction, too.  I convincepeople by saying 9i is really 8.2.Paul BaumgartelMortgageSight Holdings, LLCpbaumgartel@mortgagesight.com-----Original Message-----Sent: Thursday, August 23, 2001 12:41 PMTo: Multiple recipients of list ORACLE-LOkay, 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 morebuggy 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 atleast 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 AMTo: Multiple recipients of list ORACLE-LPaul,        No it's more like, "Hey, I heard there is a new version of thedatabaseout, do we have it yet?  Why not?  Can we have it?  Yeah let's do it, thatwould be cool.  Oh and by the way I installed a beta service pack on mymachine, that's ok right?"...crap like that:)KK-----Original Message-----Sent: Wednesday, August 22, 2001 6:56 PMTo: Multiple recipients of list ORACLE-LKevin,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 -0800Reply-To: ORACLE-L@fatcity.comOrganization: Fat City Network Services, San Diego, CaliforniaTo: Multiple recipients of list ORACLE-L I have people here who just want to upgrade for the sake ofupgrading...rriiiiggghhhhtttt..ok.:)KK-----Original Message-----Sent: Wednesday, August 22, 2001 5:01 PMTo: Multiple recipients of list ORACLE-LWell, we wanted to upgrade from 8.0.4 to 8.1.6 last year because it hadbeendesupported.  We got most of the machines upgraded except for the mainproduction machine.  I wanted to upgrade that last September.  I havefinally gotten permission to tentatively schedule the for next month(oneyear later), just in time for the 8.1.6 desupport notice.  Sigh.-----Original Message-----Sent: Wednesday, August 22, 2001 3:36 PMTo: Multiple recipients of list ORACLE-LLisa,You need some work to do....Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?ROR mô¿ôm>>> lisa.koivu@efairfield.com 08/22/01 12:45PM >>>Don't upgrade unless there is a very good reason.All of these are candidates1.  current oracle version is unstable2.  specific bug addressed by an upgrade/patch, as identified by support3.  need to utilize new feature4.  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 KoivuCertifiable Gimp Monkey (and DBA)Ft. Lauderdale, FL, USA> -----Original Message-----> From: Mark Marsden [SMTP:mark.marsden@hyde-housing.co.uk]> 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> helpdesk@hyde-housing.co.uk, 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: mark.marsden@hyde-housing.co.uk>> 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: ListGuru@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.com--Author: Ron Rogers  INET: RROGERS@galottery.orgFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Miller, Jay  INET: JayMiller@TDWaterhouse.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Kevin Kostyszyn  INET: kevin@dulcian.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Paul Drake  INET: drake@psscorp.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Kevin Kostyszyn  INET: kevin@dulcian.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: David Wagoner  INET: dwagoner@arsenaldigital.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Paul Baumgartel  INET: pbaumgartel@mortgagesight.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: George Schlossnagle  INET: george@omniti.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).