Which tnsnames.ora is active

Click OK to close window. Feel free to ask questions on our Oracle forum. 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. On UNIX operating systems, the global configuration directory. Pete Holberton You are entirely correct. Thanks for the posting. Not direct answer to your question, but I've been quite frustrated myself trying find and update all of the tnsnames files, as I had several oracle installs: Client, BI tools, OWB, etc, each of which had its own oracle home.

I ended up creating a utility called TNSNamesSync that will update all of the tnsnames in all of the oracle homes. The easiest way is probably to check the PATH environment variable of the process that is connecting to the database. Most likely the tnsnames. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 13 years, 3 months ago. Active 5 years, 7 months ago. Viewed k times. What's the best way to figure this out?

Improve this question. Mark Harrison. Mark Harrison Mark Harrison k gold badges silver badges bronze badges. Add a comment. Active Oldest Votes. All rights reserved. Improve this answer. The example files below are relevant for an Oracle installation and instance with the following values.

The "listerner. Here is an example of a basic "listener. Notice the reference to the hostname "myserver. If this is incorrect, the listener will not function correctly. After the "listener. The listener defined above doesn't have any services defined. These are created when database instances auto-register with it. In some cases you may want to manually configure services, so they are still visible even when the database instance is down.

If this is the case, you may use a "listener. The "tnsnames.