Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Multiple Oracle homes on client to support different applications?
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 Received on Mon Feb 10 2003 - 11:04:39 CST