Xref: alice comp.databases.oracle.server:77518
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!cam-news-hub1.bbnplanet.com!news.gtei.net!newscon02!news-k12.news.prodigy.com!prodigy.com!not-for-mail
From: "Steve" <schen@prodigy.net>
Newsgroups: comp.databases.oracle.server
Subject: What Option to Upgrade?
Date: Sun, 12 Dec 1999 16:49:49 -0500
Organization: Prodigy Internet http://www.prodigy.com
Lines: 21
Message-ID: <831539$21q8$1@newssvr03-int.news.prodigy.com>
X-Trace: newssvr03-int.news.prodigy.com 945035177 2884785 209.156.43.6 (12 Dec 1999 21:46:17 GMT)
X-Complaints-To: abuse@prodigy.net
NNTP-Posting-Date: 12 Dec 1999 21:46:17 GMT
X-Newsreader:  Microsoft Outlook Express 5.00.2314.1300
X-MSMail-Priority:  Normal
X-Priority:  3
X-Mimeole:  Produced By Microsoft MimeOLE V5.00.2314.1300


I need to upgrade Oracle server from V7.3.2 to V.7.3.4 (not ready for V8 for
client OS limitation).       There are two options to choose:
1)  upgrade with separate $ORACLE_HOME directory
2)  upgrade with the same $ORACLE_HOME directory

Because it is too much to rename dbfiles later and/or change client login
SID if using different SID to upgrade, option #1 seems to have too much
work.     But option #2 has no chance to test after upgrade.

Question is:
1)  if using option #1, does SID has to be different one?
2)  if using option #2, how big chance of something got wrong considering it
only upgrades from 7.3.2 to 7.3.4?

Please help.

Thanks,

Steve