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.
Just based on your paths you have two installed clients as you suspect Toad and dbforge are tools, not clients so your terminology is a bit off.
One bit, the other bit. It appears that Toad is bit based on its installation path, but execute it and go to Help Support Bundle. Toad Toad will only see the Oracle client that is for the same platform as it.
So your bit client is irrelevant for Toad's sake. Active 10 months ago. Viewed 26k times. Where can I find this file or otherwise configure my TNS names? Alexis Eggermont Alexis Eggermont 6, 15 15 gold badges 52 52 silver badges 87 87 bronze badges. Did you check this? TNS: Connect timeout occurred sounds more like a network problem or firewall issue, not a missing tnsnames.
Show 2 more comments. Active Oldest Votes. LuckyLikey 3, 1 1 gold badge 29 29 silver badges 48 48 bronze badges. Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook. That's okay, though: a default file from Oracle would not have the server information we want to connect to since the information in the file is server-specific.
Download the file here. When the Oracle client is installed for the first time, it does not come with a TNSnames. Add the file to your Oracle driver's home directory; you may need administrative access on your machine to access these folders. The Oracle home directory will have a path similar to this:. If you have both and bit Oracle clients installed, be sure to add the TNSnames.
0コメント