| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: database upgrade policy?
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.
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
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
>>> <A
href="mailto:george_at_omniti.com">george_at_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" <ORACLE-L_at_fatcity.com>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_at_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_at_fatcity.comOrganization:
Fat City Network Services, San Diego, CaliforniaTo: Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>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_at_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_at_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 HousingAssociation - 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_at_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: <A href="http://www.orafaq.com">http://www.orafaq.com> --> Author: Mark Marsden> INET:
-------------------------------------------------------------------->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: <A
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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: <A
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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: <A
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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: <A
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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: <A
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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: <A
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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: <A
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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: <A
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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). Received on Thu Aug 23 2001 - 13:17:57 CDT
 |
 |