| MYSTERY ORACLE MULTIPLE HOME [message #185609] |
Wed, 02 August 2006 10:47  |
faisal.ali@capita.co.uk
Messages: 2
Registered: August 2006
Location: UK
|
Junior Member |
|
|
I have 2 oracle homes installed on my citrix server oracle 8i and oracle 9i using Oracle home selector I can switch to either database. Both client works fine and talks to backend database from citrix server. However citrix (thin) client always talk to on users machine always talk oracle 8i client even I have made 9i my primary home using oracle home selector. If I delete all TNS names from 8i client then I get TNS name incorrect message on client machine, no matter what I do my client always look for oracle 8i client and completely ignore 9i client. I have also created TNS_ADMIN environment variable pointing to oracle9i client on citrix server but still my client look oracle 8i client.
Can some body please help me and tell me what could be wrong in oracle client setup or system/environment variable.
Please your post reply ASAP.
|
|
|
|
| Re: MYSTERY ORACLE MULTIPLE HOME [message #186134 is a reply to message #185609] |
Sun, 06 August 2006 06:51  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
|
The database you get will depend on the profile settings (ORACLE_HOME, ORACLE_SID, ...) when you log in to your citrix server and yes, the tnsnames.ora that user sees. Also which port you connect to and other things.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
