RE: shared tnsnames ??? How to support a large number of users using the client

RE: shared tnsnames ??? How to support a large number of users using the client

 

  

Two options seem to work pretty well. Right now, we're using the second
one (as we're not sure we want the added security and complexity
concerns of OID). For you, OID might be the best solution:

1) Look at Oracle Internet Directory (an LDAP Server with Oracle
extensions).

2) Look at the registry setting TNS_ADMIN or environment variable
TNS_ADMIN:
[ HKEY_LOCAL_MACHINE\Software\Oracle ]
TNS_ADMIN="\\my_network_path\directory\"
and if you're using the newer 9i client,
[ HKEY_LOCAL_MACHINE\Software\Oracle\OraHomewhatever ]
TNS_ADMIN="blah"

Cheers!
Jason McIntosh

On Thu, 2003-02-27 at 13:49, Fedock, John (KAM.RHQ) wrote:
> I am looking for info on how you support a large number of PCs (200+)
> and keep each ones tnsnames.ora file in sync. It seems that most
> people do not touch them. Some try to modify them and when new
> databases are created, the tnsnames.ora files must be changes as
> well. It seems to be that a shared tnsnames.ora file on a network
> drive may work. I remember a thread awhile back about the order of
> resolution (home directory, then OH/network/admin ....). Again, I am
> asking about people using the Oracle client to connect to 15+
> databases (v7.3.4 - 9.0.x) on 10+ different servers. I have just
> started to think about this and posted here before I started my
> MetaLink search.
>
>
> TIA for any info.
>
> JF
>
>
>
> John Fedock
> "K" Line America, Inc.
> www.kline.com
> * john.[Email Address Removed]

--
Jason McIntosh
Programmer/Analyst
University of Missouri
573-884-3865

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.2.1 (GNU/Linux)

mQGiBD5AMRERBACcxAJ7hiB6udEDefnAksb49o6BDVC2bxdUTwkxP9jS0BmLqbQL
egYYt09WjEJtn4eRuVdkku7A0fi/G8NIsXnE9oMKnWkqg2tjQ8q65D64Cass5zEU
WG6j8qABpxpZNP9HGSTqm0yeYTR9f0dGaS6jZbxgme6hU0XDOGH3ug6/qwCg0j1h
gYkkNl3jbPuwtpCrTIxSUYsD/0J18alKrswomFJfoRgjA7S9AezlV7YJoU3dCLSV
6D19SAVwmseTRltJm0S8e8Yf6Bq9l+1OdsJCHtT+HYBVuB0PmL8PDhJg6vAzIZlt
5c3hkfJrSSCssRSMBIr+8Hl2HBU4tKB79L2cI3Nrij+5DJTVzIa5QpvsFDAIO2Cp
Ma/hA/9vOPY2PyoAWKb3JAQV8T2h7/rjzePxOv0WYI2/6THdgh2lLUP+GJ4FdH76
I/8d+qtiAzul/Zq2LkFvpejnu41dDZn+yhgsVTkz/xTRKWQX9sOud0QjvyN0nHD9
KqisFRgs1ByINQcWNK8KpwgLcBRLVS4EALDn5R6yL6AT6poT7bQ8SmFzb24gTWNJ
bnRvc2ggKFByb2dyYW1tZXIvQW5hbHlzdCkgPE1jSW50b3NoSkBtaXNzb3VyaS5l
ZHU+iF8EExECAB8FAj5AMREFCQHhM4AECwcDAgMVAgMDFgIBAh4BAheAAAoJEGZP
+3FaGjd1P9IAoJQL5kaHEjG1TNVSt20bAXDx/DzmAJ4pVTDnpWUPNCxk+/kMBlGe
bO97ObkCDQQ+QDEfEAgAjl6vRTDWrMTUfXyngnWAgU/3wRZmjcKONhCGcpqFOFR/
2CiMeeJOnNXgSzrPxIfUJphlh00vBm1K/ngllg3MGFI9hOffuLuHXiw8e/Yc87uz
YdtglWHeUz/9YQCe4ndKohtk7nZHUoxQd5OspJxYJH5J5cysSuH2V839NtNPJKBZ
ai0VhyTFZKD3v9xTC8ZyMEO022bpkhWz1cs/9l5z4g2eg7mOwe+hJstMQFHk77Zr
GbkPwi+gWwM/b2pxigz1xhQpHpR5HrO/4yM8zWYZHUbUGwxiuTJqKktFEVUKUFDD
xopIpOAMOy0qVs+wXS5buJSduSgDxPmKq0xZFsJiZwADBwgAi66pXMCTolMQzn50
MAs9KRK6+3XphI+InmzfN+/OVknwzkAkGhRfisYI0DyN/26wSkn+zyoE87NBuUQt
xtcNOpwwxS2WCqBx3PhtpVJ6yvaeFmSe3QC2lUf8418B2C6GR/e6IOPNhVW1cnhP
IR0/yY8c8zQrJxEZNhBtj2SrkLY6Ps7j97lI8n+u21YC2/a5P3TPCa3x0w0m0APB
zJrhXuNGwPcNtxqKZDz7m9KuROSijx0Xm1buQkGfDZqkqA1D8ljN2vdA+jx/v1eq
H27iXk2iZ+i8bOyoiflniKh6nrd2UlVPvzmLscpiUf0rEGQuBV0Sq5AUUqO7MQM+
L8jCYYhMBBgRAgAMBQI+QDEfBQkB4TOAAAoJEGZP+3FaGjd1yhMAnjAwU37EIok3
WZu1BXhaD9y1ryjBAKC7fnv7AdrVrxdXkmdgdA5jxUFXOg==
=ueqZ
-----END PGP PUBLIC KEY BLOCK-----

Oracle LazyDBA home page