Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dual homes on application clients

RE: Dual homes on application clients

From: Brady, Mark <Mark.Brady_at_Constellation.Com>
Date: Thu, 10 May 2007 10:25:44 -0400
Message-ID: <72AB68B424526641A8514835270C2EB576E99C@EXM-OMF-21.Ceg.Corp.Net>

I whole-heartedly agree with Niall that, "In nearly all cases I've found upgrading clients an extremely problematic exercise"  

And of course I'm referring to windows. But to answer your question, it is common to have multiple homes. AFAIK, Discoverer requires its own home, so we've had more than one home on hundreds of PCs for quite a while. But the formula to get this working wasn't easy. We got it down to things had to be installed in a precise order to get it working - and wound up not using the installer at all for parts of the install, just writing it ourselves.  

[] On Behalf Of Niall Litchfield Sent: Wednesday, May 09, 2007 6:26 AM
Cc: Oracle-L
Subject: Re: Dual homes on application clients  

In the past I've tended to go with the old client until required for some reason to upgrade it. Reasons for upgrade I've encountered.  

  1. New db version doesn't support connection from old clients (10g from 8i clients, 8/9 from Oracle 7 clients)
  2. New app requires newer drivers (eg 10g ODP.Net).

In nearly all cases I've found upgrading clients an extremely problematic exercise.  

In addition if you are on Windows clients then make sure that the environment (the PATH and CLASSPATH) is set correctly. Multiple OH can occasionally cause conflicts on this platform (though to be fair I've only recently seen this running 2 db versions and 3 app server installs on the same laptop :) )  


On 5/8/07, Bryan Wells <> wrote:

My mentors:  

we are in the midst of migrating from 9i to 10g. we are a small shop, and unfortunatly are bound to the old hardware for the applications hitting the new database. My question is, for our regression testing scenarios. we want to be able to set up multiple client homes on the applications/web etc...? the idea is to utilize 9i for existing requirements, then use the 10g client to test against the new 10g database environment.  

is this common practice?  



Niall Litchfield
Oracle DBA <> 

>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2 --
Received on Thu May 10 2007 - 09:25:44 CDT

Original text of this message