Last post Jun 02, 2014 11:46 AM by StrangerMike
Jun 02, 2014 09:54 AM|StrangerMike|LINK
I was in a program I have that uses Orcale and I am just refamiliarizing myself with the connection.
In my web cofig I have data soucrce connection that points in an entry in the tnsnames.ora file.
When I searched for this file on my local machine, I found it in mulitple locations. I must have reinstalled the client a few times because I have three tnsnames files in:
Admin C:\app\name\product\11.2.0\client_1\Network and it also resides in: C:\app\name\product\11.2.0\client_2\Network and C:\app\name\product\11.2.0\client_3\Network.
Is there a way to tell which one the program is using?
Jun 02, 2014 10:14 AM|bbcompent1|LINK
Check your windows path statement for the oracle path info and that should tell you which one is being used - this is just a guestimate :) .
Jun 02, 2014 10:35 AM|StrangerMike|LINK
am I looking in the right spot?
Here are some settings:
Version=220.127.116.11, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
Version=18.104.22.168, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
I don't see anywhere where the path to the tnsnames file is being referenced. But I suppose it has to be some where.
Jun 02, 2014 10:39 AM|bbcompent1|LINK
This would be the path on the windows machine itself where the site is hosted. If you drop to the command prompt and type in the word path, you will see all your shortcut paths listed there. It will look something like this:
PATH=c:\oracle\product\11.2.0\client_1\bin;C:\Program Files\Internet Explorer;C:\Program Files\Windows Kits\8.1\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program
Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;
C:\Program Files\Microsoft SDKs\TypeScript\1.0\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft\Web Platform Installer\
Jun 02, 2014 11:16 AM|StrangerMike|LINK
I saw this:
The directory stated Z:\>path. (on my local machine)...do I need to change directory? Not sure why when i brough up the command prompt it had Z in there.
Jun 02, 2014 11:27 AM|StrangerMike|LINK
I changed the directory to c and it gave me the same info.
So is it a correct assumption that it is using the tnsnames file from client_3?
I did it on the host server and it was pointing to client_1 (but that is the only one installed on the host server).
Jun 02, 2014 11:30 AM|bbcompent1|LINK
I think that it would be a correct assumption, depends on where it lands in the path statement on your machine. I think (again, from memory) that it takes the last location in line.
Jun 02, 2014 11:46 AM|StrangerMike|LINK
ok thanks very much.