'Install' Oracle TNS file

Preamble

allow Oracle db SQL clients to be aware of predefined DUK SQL connection settings

Requirements

Local Admin rights on target Machine
access to DUK network share: \\gs1dukfilv01\shared$\CIS_Support\useful_progs\oracle + subfolders

Steps

copy \\gs1dukfilv01\shared$\CIS_Support\useful_progs\oracle\network\admin
- to C:\Oracle\network\admin - this is location of TNS file
fig1 On the desktop Right-click on 'This PC' and select Properties > Advanced tab
Click the Environment Variables button
In the System variables section click the New button
Enter a variable name of TNS_ADMIN then enter a variable value of the path to the TNSNAMES.ORA file that will be used as the default
Variable Name TNS_ADMIN
Variable Value C:\Oracle\network\admin
fig 2 Click OK
Fire up cmd.exe and issue echo %tns_admin%
fig 3 'TNS_ADMIN' system variable is set to right location
DONE

fig 1

fig 2

fig 3