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?

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Oracle 9iR2 and HP-UX 11i
Next Topic: Crontab Scheduler issue?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 16:12:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.