Multiple Oracle homes on client to support different applications?

From: Ray Porter <ray_porter_at_unc.edu>
Date: Mon, 10 Feb 2003 07:59:06 -0500
Message-ID: <3e47a22c$1@news.unc.edu>

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

Received on Mon Feb 10 2003 - 06:59:06 CST