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!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!i42g2000cwa.googlegroups.com!not-for-mail
From: "Oracle_User" <oracle_user@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: 9i Client Against 10g and Upgrade Gotchas
Date: 8 Aug 2006 20:13:14 -0700
Organization: http://groups.google.com
Lines: 40
Message-ID: <1155093194.066762.207990@i42g2000cwa.googlegroups.com>
References: <1155091979.887342.91230@i42g2000cwa.googlegroups.com>
   <1155092560.486344@bubbleator.drizzle.com>
NNTP-Posting-Host: 202.92.75.130
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155093199 16619 127.0.0.1 (9 Aug 2006 03:13:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 9 Aug 2006 03:13:19 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 apac-nc02 (NetCache NetApp/6.0.1)
Complaints-To: groups-abuse@google.com
Injection-Info: i42g2000cwa.googlegroups.com; posting-host=202.92.75.130;
   posting-account=l6HfOQ0AAADujgpSc5RKoVbSTRHQzUlb
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272413

Daniel

Thanks for the reply - does that mean the 9i client won't work against
10g or is it that it will just cause me problems?

Also in your experience is it safe to do an in place upgrade (having
taken appropriate backups) or would you do a clean build and then move?

Chris

DA Morgan wrote:
> 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