0

Just installed ODT, it wants tnsnames.ora, where should I put it?

user1443098
  • 6,487
  • 5
  • 38
  • 67

1 Answers1

1

The default location is at %ORACLE_HOME%/network/admin but you can put it in any folder. Use environment variable (or Registry Key) TNS_ADMIN to specify the folder.

Wernfried Domscheit
  • 54,457
  • 9
  • 76
  • 110
  • Thanks Wernfried! Unfortunately the ODT install did not set that environment variable and the instructions didn't say anything about it. Should it have been added? BTW do you know where that registry key should go? – user1443098 May 09 '17 at 15:38
  • Check this answer: http://stackoverflow.com/questions/28280883/determining-locatation-of-relevant-tnsnames-ora-file/28283924#28283924 – Wernfried Domscheit May 09 '17 at 16:56