how to obtain tnsnames.ora location from registry

how to obtain tnsnames.ora location from registry.

for the install shield I need to know whether the tnsnames already exist on the local machine or what. depening on it the new tnsnames would be copied over backedup .... etc.
agatagogAsked:
Who is Participating?
 
ramkbConnect With a Mentor Commented:
Hi,

It actually depends on the ORACLE_HOME variable.  B'coz you can have multiple version set of products installed in different ORACLE_HOMEs and potentially using different TNSNAMES.ORA

Under HKLM\SOFTWARE\ORACLE, there may be HOMEx (Eg. HOME0, HOME1) representing each ORACLE_HOME.  You can get the ORACLE_HOME variable from there.  You should append "NETWORK\ADMIN" to that value.

The catch is there is another variable TNS_ADMIN which can be set by the user which overrides the default location.  If this variable is set, Oracle looks for network configuration files (TNSNAMES.ORA, SQLNET.ORA) at this location.

Hope this helps..
- Ramesh
0
 
wandidj1Commented:
if you work with windows NT - oracle, you just search for the file name - tnsnames.ora on your oracle_home directory.
it will produce 2 result - one of it is the real one - the other is the sample.
The real will be in network or net8/admin and the sample will be in net8/admin/sample.


wandi
0
 
RMZCommented:
HI
loccalmachine-software-oracle-net80
---rmz---
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
soraCommented:
Check if a reg entry called TNS_ADMIN is defined in your reg under Software/Oracle. If so, this entry points to the location. If not, it should be Net80/Admin or Network/Admin (as other have already pointed out)


sora
0
 
agatagogAuthor Commented:
Thanks
I already new it more or less you just confirmed my knoledge.but depdening on the oracle version ... 8.05 or 8.1.7 the locations are different. there for I thought that there is a key that specificaly holds the location of tnsnames.ora. I guess not. so I do have to have different "if's" depending on oracle version looking for it in //oracle/ora81/network/admin
or //orant/net80/admin.
are there any other options of tnsnames.ora location with any newer or older oracle versions ? like 7.or 9.?
0
 
agatagogAuthor Commented:
Thanks
I already knew it more or less you just confirmed my knoledge.but depdening on the oracle version ... 8.05 or 8.1.7 the locations are different. there for I thought that there is a key that specificaly holds the location of tnsnames.ora. I guess not. so I do have to have different "if's" depending on oracle version looking for it in //oracle/ora81/network/admin
or //orant/net80/admin.
are there any other options of tnsnames.ora location with any newer or older oracle versions ? like 7.or 9.?
0
 
agatagogAuthor Commented:
Thanks
I already knew it more or less you just confirmed my knowledge. But depending on the oracle version ... 8.05 or 8.1.7 the locations are different. Therefore I thought that there is a key that specifically holds the location of tnsnames.ora. I guess not. So I do have to have different "if's" depending on oracle version looking for it in //oracle/ora81/network/admin or //orant/net80/admin.
Are there any other options of tnsnames.ora location with any newer or older oracle versions? Like 7.or 9.?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.