# Changing tnsnames

**URL:** <https://forums.toadworld.com/t/changing-tnsnames/33564>\
**Category:** SQL Navigator\
**Created:** [June 23, 2015, 1:20pm UTC](https://forums.toadworld.com/t/changing-tnsnames/33564 "2015-06-23T13:20:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kthomas\_21425](https://avatars.discourse-cdn.com/v4/letter/k/41988e/32.png) [@kthomas\_21425](https://forums.toadworld.com/u/kthomas_21425)\
**Post date:** [June 23, 2015, 1:20pm UTC](https://forums.toadworld.com/t/changing-tnsnames/33564/1 "2015-06-23T13:20:59Z")

</div>

I’ve just installed SQL Navigator 7.2, and it’s picking up 2 of my 3 Oracle homes. I like to keep a separate tnsnames.ora file in a different location than any of the homes. But I can’t edit the location in the connect menu. Where can I change and specify the tnsnames.ora file I want to use to make connections?

---

<div class="post-metadata">

**Author:** ![vliu](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vliu/32/72_2.png) [@vliu](https://forums.toadworld.com/u/vliu)\
**Post date:** [June 23, 2015, 6:12pm UTC](https://forums.toadworld.com/t/changing-tnsnames/33564/2 "2015-06-23T18:12:53Z")

</div>

You can add a Windows system variable TNS\_ADMIN pointing to the location where you store tnsnames.ora file. Please restart SQL Nav to apply the change.

![](http://04j0.mj.am/o/04j0/7901d3b0/jtljmk8e.gif)

---

<div class="post-metadata">

**Author:** ![kthomas\_21425](https://avatars.discourse-cdn.com/v4/letter/k/41988e/32.png) [@kthomas\_21425](https://forums.toadworld.com/u/kthomas_21425)\
**Post date:** [June 24, 2015, 5:54am UTC](https://forums.toadworld.com/t/changing-tnsnames/33564/3 "2015-06-24T05:54:55Z")

</div>

Works, thanks.