Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tnsnames.ora General Question

mateoc15Oct 17 2006 — edited Oct 17 2006
We are experiencing a problem that many different users seem to have many different versions of tnsnames.ora. We want to create our "gold" version and ensure that everyone uses the same one. Two questions:

1. Is the "alias" that you give each connection case sensitive? For instance if I name one connection Prod is that the same as PROD?

2. At another place I worked I was under the impression that most applications (PL/SQL Developer for sure) uses the Windows PATH environment variable to locate tnsnames.ora by going through all directories listed in the variable and using the first occurrence of tnsnames.ora that it found. Through a little testing and renaming and such I have found that this doesn't appear to be the case. We are using ADI, Discoverer, different development tools, etc and would like to avoid having more than one location where the file is stored. What is the best way around that or is there a way? I assume that it depends somewhat on each application.

Thanks in advance for the help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2006
Added on Oct 17 2006
5 comments
365 views