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. 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. That's a global override if you will that points to the folder containing your net configuration files. If you use a common set of connections for all of your tools I'd delete all of your tnsnames.
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.
All legitimate Oracle experts publish their Oracle qualifications. Oracle technology is changing and we strive to update our BC Oracle support information.
If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. All rights reserved by Burleson. Search BC Oracle Sites. Ask Question. Asked 9 years ago. Active 4 years, 5 months ago. Viewed k times. Improve this question. Add a comment. Active Oldest Votes. Improve this answer. Aaron Aaron 3, 2 2 gold badges 19 19 silver badges 32 32 bronze badges. DuffJ then something is wrong with your environment.
The default directory for a tnsnames. Mat 9, 3 3 gold badges 40 40 silver badges 40 40 bronze badges. Munchi Munchi 3 3 silver badges 12 12 bronze badges.
The default directory is nothing of the sort. It's completely up to the user where the software resides. Honestly it is the default on a linux system If you don't touch a thing it will be put there I have run Oracle on literally hundreds of Linux systems and that is NOT the default, nor is there such a thing.
0コメント