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!

oracle environment variable tns_admin instead tnsnames.ora

867928Jun 9 2011 — edited Jun 9 2011

Hi, I have a big trouble with the tns_name file. First of all I am working oracle with visual studio .net. I have the file tns_name in the following route C:\oracle\ora92\network\ADMIN\tnsnames.ora. If I delete this file, visual studio .net can still work properly. Then I figured out that it is taking the tnsnames from tns_admin in environment variables. It means visual studio .net is taking the tnsnames from tns_admin instead of C:\oracle\ora92\network\ADMIN\tnsnames.ora.

Can someone explain me why and how is the way to configure which file is used? Where can I configure it?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2011

Added on Jun 9 2011

#general-database-discussions

5 comments

3,549 views