With Oracle 8.0.6 and 8.1.7 versions running in support services, we had to change the TNS names in individual systems (about 30 of them), every time there was a change in host ip or any other parameter which are globally applicable
C:\Oracle\Ora806\Net80\Admin\TNS Names and
C:\Oracle\Ora817\Network\Admin\TNS Names
But one can have these TNS Names in a centralized location to avoid its change in every client system.
Create an environment variable with name: TNS_ADMIN, value for which would be the centralized location (eg. a mapped drive) containing TNS Names file. So, on the client system, it uses this variable to connect Oracle db. The local TNS Names become redundant!!!
Tuesday, December 16, 2008
Centralized TNS names on network
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment