Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Multiple Oracle homes on client to support different applications?

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

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 10 Feb 2003 09:04:39 -0800
Message-ID: <3E47DBA7.190CA805@exesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US