RE: database upgrade policy?
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...rrggg..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
RE: database upgrade policy?
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...rrggg..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
RE: database upgrade policy?
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...rrggg..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
RE: database upgrade policy?
you are crazy :) but i like it anyways. since i'm running it on a non -supported platform anything i find wouldnt be any good anyways :) we'll look forward to you sharing your experiences :) joe [EMAIL PROTECTED] 08/23/01 12:40PM 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 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: [EMAIL PROTECTED]Organization: Fat City Network Services, San Diego, CaliforniaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]I have people here who just want to upgrade for the sake ofupgrading...rrggg..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 doCertifiable 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 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:[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
RE: database upgrade policy?
I am not going to say anything. That's cool, you'll find all of the bugs and report them back to us:) hehehe...whoo ho!!! Just kidding Dave, good luck!! Kev -Original Message- Wagoner 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...rrggg..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
RE: database upgrade policy?
but the banner says 9.0.1 :) joe [EMAIL PROTECTED] 08/23/01 01:27PM Good for you, David. We are moving in that direction, too. I convincepeople by saying 9i is really 8.2.Paul BaumgartelMortgageSight Holdings, LLC[EMAIL PROTECTED]-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: [EMAIL PROTECTED]Organization: Fat City Network Services, San Diego, CaliforniaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]I have people here who just want to upgrade for the sake ofupgrading...rrggg..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 doCertifiable 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 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:[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)
RE: database upgrade policy?
A co-worker tried 9i for a while and used automatic rollback semgent management. We started getting database locks on SMON. NO ONE was on the system and we were routinely getting system locks and ORA-600s in the middle of the night. We scraped the idea and moved back to 8.1.6 for our reporting database. -Original Message- Baumgartel Sent: Thursday, August 23, 2001 1:27 PM To: Multiple recipients of list ORACLE-L 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...rrggg..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
RE: database upgrade policy?
Some people say that 8.1.7 was really the first beta release of 9i and that Oracle called it 8.1.7 so people wouldn't be afraid to implement it as 9i. If that's true then 9.0.1 is really the second release of 9i. david -Original Message- Sent: Thursday, August 23, 2001 1:37 PM To: Multiple recipients of list ORACLE-L I am not going to say anything. That's cool, you'll find all of the bugs and report them back to us:) hehehe...whoo ho!!! Just kidding Dave, good luck!! Kev -Original Message- Wagoner 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...rrggg..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
Re: database upgrade policy?
On Thu, Aug 23, 2001 at 09:11:56AM -0800, JOE TESTA wrote: you are crazy :) but i like it anyways. since i'm running it on a non -supported platform anything i find wouldnt be any good anyways :) we'll look forward to you sharing your experiences :) -- What doesn't kill you will make you stronger. -- some dead guy === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
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 ona 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 PMGood for you, David. We are moving in that direction, too. I convincepeople by saying 9i is really 8.2.Paul BaumgartelMortgageSight Holdings, LLC[EMAIL PROTECTED]-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: [EMAIL PROTECTED]Organization: Fat City Network Services, San Diego, CaliforniaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]I have people here who just want to upgrade for the sake ofupgrading...rrggg..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 doCertifiable 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 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:[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
Re: database upgrade policy?
what was the bug 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 10:52:29 -0800 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...rrggg..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
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. - 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 ona 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 PMGood for you, David. We are moving in that direction, too. I convincepeople by saying 9i is really 8.2.Paul BaumgartelMortgageSight Holdings, LLC[EMAIL PROTECTED]-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: [EMAIL PROTECTED]Organization: Fat City Network Services, San Diego, CaliforniaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]I have people here who just want to upgrade for the sake ofupgrading...rrggg..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 doCertifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?ROR mô¿ôm [EMAIL PROTECTED] 08/22/01
Re: database upgrade policy?
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...rrggg..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
RE: database upgrade policy?
In the case of 816, it is desupported in October, so get to 817 ASAP. In the case of patches, try to watch for problems noted in MetaLink. Things like SQL*Net Demial Of Service fixes, I like to get them in right away. Otherwise, most client make me implement if it is not broken, do not patch it. And remember: the patch and even the README file may have errors too. In the case of 9i, I beleive you should have a test instance up now to test and learn. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Wed, 22 Aug 2001 08:02:56 Christopher Spence wrote: Highly depends. I tend to stay back from the latest versions for some time. I also tend to upgrade for functionality, and upgrade when I have existing problems that are told to be fixed. Sometimes if I start falling back versions and have no reason either way, I will upgrade my development database and slowly trickle them to production if things work well. A lot of it depends on the environment, if it is a 24/7 very large system, then you only really want to upgrade when you have a good reason to. Or a good maintenance window. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 22, 2001 11:45 AM To: Multiple recipients of list ORACLE-L 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: Christopher Spence 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 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: database upgrade policy?
George, Can you go into details about the error please? We are starting testing on 9i, and I AM interested ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! 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 *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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).
Re: database upgrade policy?
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...rrggg..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
RE: database upgrade policy?
George, Can you tell us the specific problem you had that caused you the total lost of database under 9i? Thanks. Bing -Original Message- Sent: Thursday, August 23, 2001 11:52 AM To: Multiple recipients of list ORACLE-L 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...rrggg..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
Re: database upgrade policy?
At 03:16 PM 8/23/2001, George Schlossnagle wrote: 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. i think that wins my vote for understatement of the month!;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. Meets quality standards: Compiles without errors. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
RE: database upgrade policy?
8.1.7 is no where near the likes of 9i (in my opinion), I couldn't imagine this to be true, although I have nothing here nor there to back it up, just a comment I feel. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 23, 2001 2:42 PM To: Multiple recipients of list ORACLE-L Some people say that 8.1.7 was really the first beta release of 9i and that Oracle called it 8.1.7 so people wouldn't be afraid to implement it as 9i. If that's true then 9.0.1 is really the second release of 9i. david -Original Message- Sent: Thursday, August 23, 2001 1:37 PM To: Multiple recipients of list ORACLE-L I am not going to say anything. That's cool, you'll find all of the bugs and report them back to us:) hehehe...whoo ho!!! Just kidding Dave, good luck!! Kev -Original Message- Wagoner 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...rrggg..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
Re: database upgrade policy?
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
Re: database upgrade policy?
If the version remained at 8.x, developers would be restricted in what they can do, mostly bug fixes, and minor new features. But when the versioning was changed, the software would have been checked out of 8.x and checked into 9.x. With a major release, the developers are free to check in new and wonderful (and undocumented) features into the new version. .. [EMAIL PROTECTED] 08/24/01 06:52AM 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...rrggg..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
RE: database upgrade policy?
Highly depends. I tend to stay back from the latest versions for some time. I also tend to upgrade for functionality, and upgrade when I have existing problems that are told to be fixed. Sometimes if I start falling back versions and have no reason either way, I will upgrade my development database and slowly trickle them to production if things work well. A lot of it depends on the environment, if it is a 24/7 very large system, then you only really want to upgrade when you have a good reason to. Or a good maintenance window. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 22, 2001 11:45 AM To: Multiple recipients of list ORACLE-L 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: Christopher Spence 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).
Re: database upgrade policy?
On Wed, Aug 22, 2001 at 07:45:27AM -0800, Mark Marsden wrote: 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. Doc ID: Note:123178.1 Product / Platform: Oracle8i, Release 2 (8.1.6) Error Correction Support ends on: 31 October 2001 Oracle8i, Release 2 (8.1.6.) = 8.1.6.3.1 One the upside, all my ORA-600/ORA-7445 went away with 8.1.6.3.1 (which after you apply your version says 8.1.6.3.0, but that is another weasel altogether) 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
RE: database upgrade policy?
Title: RE: database upgrade policy? 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).
RE: database upgrade policy?
We were running 8.1.6.0.0 and just recently encountered the ORA-7445 errors, which caused core dumps and invalidated the referential integrity of our database. Oracle recommended the 8.1.6.3 patchset. We decided to skip that and go for 8.1.7 but for some reason Oracle mailed us the 9i CDs. I guess they are pushing it on everyone now. Anyway, we are in the process of upgrading our test databases to 9i (using Sun SPARC Solaris 8). If all is well we will upgrade production to 9i. David Wagoner Oracle DBA -Original Message- Sent: Wednesday, August 22, 2001 11:45 AM To: Multiple recipients of list ORACLE-L 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: 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).
RE: database upgrade policy?
a a glutton for punishment. Dev, sure why not, just dont let the developers get to attached to the new features, prod?, i wouldnt update any prod database(unless forced to by oracle corp) until 9.1 at earliest, yes there are some kewl things, but heck the latest 8.1.7 patchset has 22 pages of "bug fixes", i just wouldnt trust the x.0 version with my prod database yet. joe Who has lived thru 6.0, 7.0, 8.0 versions of the database :) [EMAIL PROTECTED] 08/22/01 01:11PM We were running 8.1.6.0.0 and just recently encountered the ORA-7445 errors,which caused core dumps and invalidated the referential integrity of ourdatabase. Oracle recommended the 8.1.6.3 patchset. We decided to skip thatand go for 8.1.7 but for some reason Oracle mailed us the 9i CDs. I guessthey are pushing it on everyone now. Anyway, we are in the process ofupgrading our test databases to 9i (using Sun SPARC Solaris 8). If all iswell we will upgrade production to 9i.David WagonerOracle DBA-Original Message-Sent: Wednesday, August 22, 2001 11:45 AMTo: Multiple recipients of list ORACLE-LHi ListersI'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 errorsor only upgrade if you have problems?Do you upgrade to major versions (7 to 8.0 to 8.1) for increasedfunctionality, 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 DisclaimerThe information in this email is strictly confidential and may be legallyprivileged.It is intended solely for the addressee only. Access to this email by anyoneelse is unauthorised.If you are not the intended recipient and you have recieved this email inerror you must take no actionon its contents, nor must you copy or show them to anyone, or make use ofthe information therein.Please reply to the email immediately, or forward to[EMAIL PROTECTED], highlightingthe error and confirming that it has been deleted from your system.SECURITY WARNING: Please note that this email has been created with theknowledge that the Internetis not a 100% secure communications medium. We advise that you understandand observethis lack of security when e-mailing us.VIRUSES: Although we have taken steps to ensure that this email andattachments are freefrom any virus, we advise that in keeping with good computing practise therecipient should ensurethat 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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).
RE: database upgrade policy?
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).
RE: database upgrade policy?
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
RE: database upgrade policy?
I have people here who just want to upgrade for the sake of upgrading...rrggg..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]
RE: database upgrade policy?
Just for the PLEASURE of using OUI! -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 6:07 PM To: Multiple recipients of list ORACLE-L Subject: RE: database upgrade policy? I have people here who just want to upgrade for the sake of upgrading...rrggg..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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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).
RE: database upgrade policy?
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...rrggg..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 --