Where is tns ora file located

Active Oldest Votes. Improve this answer. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 5 years, 11 months ago. Active 9 months ago. Viewed 19k times. Where can I find this file or otherwise configure my TNS names? Improve this question.

I know this by systematically renaming all but one of the tns files and then checking to see if the connection names read from the file are available when trying to create a new connection from with the app. However, TOAD seems to only recognize the tnsnames. Being that it was a 32 bit program, I did not expect it to recognize the tns file in location 2 and that was the case. Other colleagues do not have a tns file in location 3 on their machines. I'm not sure why I do. When I run Toad, it shows the following 2 Home, with the 32 bit Home as being the active one.

Q3: If I leave on the tns file in location 3, both dbForge and TOAD work but I'd like to know why so I can accurately understand how to move tns info from one machine to another.

According Oracle these locations are searched for tnsnames. I got this list from Oracle Document In order to be on the safe side, check also your registry values. Another note, you don't have to "play" with your tnsnames. With Process Monitor from Microsoft Sysinternals you can monitor each file access, i.

Maybe it also depends on the Oracle version. Another example, for ODP. In official documentation 12c Release 4 However, based on some tests I made with ODP. NET Managed Driver 4. You will need administrator access on your machine to follow the instructions below:. Navigate to your TNSnames. Edit the entry with the details you received for connecting to InfoAccess or copy the details from the above linked TNSnames. Search the file for DWHP.