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!!!
preventing Moodle time-outs
5 days ago