Re: Multiple Oracle homes on client to support different applications?

From: Frank <fvanbortel_at_netscape.net>
Date: Mon, 10 Feb 2003 22:54:54 +0100
Message-ID: <3E481FAE.60402@netscape.net>

DA Morgan wrote:

> Ray Porter wrote:
> 
> 

>>We have an in-house application that uses the Oracle 9i client. One of our
>>departments has a vendor supplied application that is still at 8.1.6. I've
>>installed the Oracle 9i client in a different home but my application
>>appears to be finding the TNSNAMES file from the earlier version and is
>>unable to resolve the net service name I created. What is the correct
>>formula to make everything work in this situation? The vendor plans to
>>upgrade their application in the next few months but we need all
>>applications to work in this department now.
>>
>>--
>>================================
>>Ray Porter
>>Applications Analyst Programmer
>>Administrative Information Services, UNC-CH
>>Phone: (919) 966-5878
>>Fax: (919) 962-5840
>>Email: ray_porter_at_unc.edu
>>Web: http://www.unc.edu/~dragon

> 
> 
> Set the TNS_ADMIN environment variable. You can find information on it at
> tahiti.oracle.com.
> 
> Alternatively ... just make an entry in the tnsnames.ora file it is finding.
> 
> Daniel Morgan
> 

tns_admin would make things worse... It is genarlly used to point to a single directory from all oracle homes. The reason is, the new installation put the new path up front. Change the path setting and you will be OK.

You could use tns_admin, and merge the new, 9i, and the old network config files into one set...

BTW, the 9i tnsping utility shows which files are actually used to resolve an alias - very helpful to see if the above applies in your situation.

Frank Received on Mon Feb 10 2003 - 15:54:54 CST