Home » Infrastructure » Unix » Multiple Oracle client
Multiple Oracle client [message #98406] Thu, 16 September 2004 03:22 Go to next message
Don
Messages: 24
Registered: June 2001
Junior Member
I need to have both Oracle 8 and Oracle 9 clients installed on Solaris server. Certain programs need to connect to Oracle 7 and others need to connect to Oracle 9.

Would someone have info on how to specify which Oracle  client that a UNIX account would use as its default?
Re: Multiple Oracle client [message #98407 is a reply to message #98406] Thu, 16 September 2004 21:45 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Install the different Oracle Clients in different Oracle Homes. After that in each user profile set the ORACLE_HOME & PATH variables to appropriate paths of oracle which that client is going to be connected.

Daljit Singh.
Re: Multiple Oracle client [message #98408 is a reply to message #98407] Fri, 17 September 2004 14:08 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
If you only want to maintain a single tnsnames.ora, you can set up the environment variable "TNS_ADMIN" to point to that file.
Previous Topic: Oracle 9iR2 and HP-UX 11i
Next Topic: Crontab Scheduler issue?
Goto Forum:
  


Current Time: Fri Nov 29 09:12:02 CST 2024