| Multiple client versions on same machine [message #245771] |
Mon, 18 June 2007 14:11  |
mhibist
Messages: 2
Registered: June 2007
|
Junior Member |
|
|
I'm an Oracle newbie, and need to understand the client setups. We are currently engineering an upgrade to a Citrix farm, and want to use Oracle for the datastore.
Widows 2003 SP1 for the Citrix servers. Citrix datastore on Solaris 10, running on Sun T2000s.
Oracle version for the Citrix datastore is 10g. The question revolves around an app that uses Oracle 7 (I believe). Will the two clients conflict, and if so, is there any way to work around it?
A re-working of the app may be out of the question due to timeframes.
Thanks in advance!
tw
|
|
|
|
|
|
|
|
| Re: Multiple client versions on same machine [message #245861 is a reply to message #245822] |
Tue, 19 June 2007 01:47  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I'm not a DBA either, but I *believe* that OUI (Oracle Universal Installer) takes care about adding all directories into path variable(s).
What you might do - at least, what makes my life easier - is to maintain only one copy of the TNSNAMES.ORA file (which holds aliases to all databases available to you). Every new Oracle installation creates its own \network\admin directory with its own copy of this file. So, whenever you add a new DB alias, you have to do that in every TNSNAMES.ORA file. To avoid this pain, choose a directory (you might even create a new one and name it, for example, 'oracle_cfg') and store this file (and, perhaps, PLL's etc.) in there. Tell Oracle to look for TNSNAMES.ORA there by setting a system environment variable called TNS_ADMIN and point it to this directory:C:\> SET TNS_ADMIN = C:\ORACLE_CFG |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
