Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newshub.sdsu.edu!nx02.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Tue, 08 Aug 2006 20:02:41 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: 9i Client Against 10g and Upgrade Gotchas References: <1155091979.887342.91230@i42g2000cwa.googlegroups.com> In-Reply-To: <1155091979.887342.91230@i42g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1155092560.486344@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 28 X-Complaints-To: abuse@csolutions.net Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272412 Oracle_User wrote: > Fairly new to Oracle and my boss is asking me to upgrade 8i (8.1.7) and > 9i (r1 and 2)databases to 10g. I'm going to read the upgrade guides!! > but a couple of questions > > 1. Can the 9i client be used against 10g and if so will it cause me > any problems > 2. Are there any docs beyond the oracle provided stuff that will > prepare me for any upgrade problems I might hit? > > Thanks 1. Upgrade the client. 2. Not really. But if you are using any non-basic technologies such as AQ, RAC, or such ask questions specific to that technology and your operating system and hardware platform. Equally important is which methodology you plan to use. Upgrade the existing databases in place or build a clean 10gR2 and then move the schemas? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org