Knowledge Base : Set Windows TNS ADMIN

How to set Oracle Environment on Windows clients

On many Windows PC’s, a local version of the TNS_ADMIN configuration file has to be used.

To change the default TNS_ADMIN location to a different one, you have to change the TNS_ADMIN environment variable.

A quick check, wether TNS_ADMIN is set, can be done with SET in the DOS command window.
If TNS_ADMIN is not listed, is is not set.
In this case, tnsping will most likely also not find your database.

To set, open “regedit” from the command window.

In the registry editor, create a new entry in

HKEY_LOCAL_MACHINESOFTWAREOracleClient

and

HKEY_LOCAL_MACHINESOFTWAREOracleSQL Developer

If this registry location is not writable for you, TNS_ADMIN may also be set in

HKEY_CURRENT_USEREnvironment