From oracle-l-bounce@freelists.org Tue Apr 5 11:03:09 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j35G2sBC018825 for ; Tue, 5 Apr 2005 11:03:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j35G2gem018780 for ; Tue, 5 Apr 2005 11:02:53 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1EB9D9119F; Tue, 5 Apr 2005 10:00:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26108-08; Tue, 5 Apr 2005 10:00:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9C04F911EB; Tue, 5 Apr 2005 10:00:07 -0500 (EST) X-Server-Uuid: E0B1BF51-395A-4DA9-AAC2-7A2E8F889826 To: oracle-l@freelists.org Subject: Multiple installed versions of Oracle MIME-Version: 1.0 Message-ID: From: "Tracy Rahmlow" Date: Tue, 5 Apr 2005 09:55:21 -0500 X-MIMETrack: Serialize by Router on AXPOSMTP01/SVR/AEXP(5012HF433 | October 14, 2003) at 04/05/2005 07:57:49 AM, Serialize complete at 04/05/2005 07:57:49 AM X-MMS-Spam-Filter-ID: A2005040504 X-WSS-ID: 6E4C78E13N8378204-16-01 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 18054 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tracy.rahmlow@aexp.com Precedence: normal Reply-To: tracy.rahmlow@aexp.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: We are in the process of upgrading several databases from 8i on AIX 4.3.3 to 9 on AIX 5.2 or 10g on AIX 5.2. The target version depends upon whether or not the application is supported on 10g or not. If not will be migrating toward 9. The manager of the unix area has indicated that he has seen issues at his previous shop with co-locating multiple versions of Oracle on the same server and is basically not allowing the practice. I have never seen or heard of this issue, but am trying to remain open-minded to his concern. Here are his statements verbatim: Several occasions where server and db crashed due to dba administering db in an incorrect manner. IE mistook one version for the other. Applied the incorrect maintenance patch to the incorrect instance. Several occasions where db versions did not play nice together 7.3.4 and 8i. All occasions impacted SLA's and one instance required restore of db due to corrupt data. I also contacted two DBA Manager friends and they are aware Oracle supports this strategy, however, both shops have standards in place that do not permit this practice - due primarily to the above incidents and to keep the environments simple / less complex. Does this make the planning of upgrades and maintenance a little more difficult - yes, but they both agreed that this best practice has solved many headaches and saved many hours of work. Prior to his arrival we did have success running 7 and 8 on the same server. Frankly, I do not think the restriction is warranted. So what are your thoughts? And if you agree with me help me make a case for changing his mind. To complicate matters, he has more authority than me. Thanks Tracy Rahmlow The American Express Property Casualty companies 3500 Packerland Drive DePere, Wisconsin 54115-9034 tel: 920-330-5164 fax: 920-330-5350 American Express made the following annotations on 04/05/05 07:58:11 ------------------------------------------------------------------------------ ****************************************************************************** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." ****************************************************************************** ============================================================================== -- http://www.freelists.org/webpage/oracle-l