Table of Contents

About

TNS_ADMIN is a environment variable value which give the directory where the file tnsnames.ora must be searched.

It's really helpful when you have more than one Oracle Client Product installed. It takes precedence on the windows PATH environment variable.

Example :

C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN