4

I have Oracle 10g installed on Windows. Currently, my tnsnames file is stored at %ORACLEHOME%\network\admin. However, I want to configure Oracle to look somewhere else for that file.

How can I do this?

Andrew L

AndrewL
  • 3,126
  • 5
  • 31
  • 33

1 Answers1

9

You can use the TNS_ADMIN environment variable to specify a custom location of TNSNAMES.ORA file. Check this wiki: http://www.orafaq.com/wiki/TNS_ADMIN

Chandu
  • 81,493
  • 19
  • 133
  • 134