Return
-
Title
How to use tnsnames.ora file not located in Oracle Client location -
Description
Is it possible to indicate where the tnsnames.ora is located? -
Resolution
1.Place the tnsnames.ora in the desired location
2.Close Toad for Oracle3.Create a TNS_ADMIN entry to force Toad to look for the tnsnames.ora file from a specified location:1. Right-click on the My Computer icon on the Desktop and select Properties.
2. Select the Advanced Tab.3. Click Environment Variables button.4. Under "System Variables" | click New | under Variable Name, type: TNS_ADMIN | under Variable Value, type the path to your tnsnames.ora file i.e. C:\oracle\product\19.0\client_1\NETWORK\ADMIN\ and click OK.4. Start Toad