RE: database upgrade policy?

[JOE TESTA]

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