Yep...My bad..
I found it in that manner. But there was no key pointing to a tns file.
I am totally stumped as to where it is pulling the correct information from to
do the ping with.
From: Matt Adams [mailto:MAdams@xxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, May 17, 2016 2:12 PM
To: Storey, Robert (DCSO); Oracle L
Subject: RE: tnsping phantom file
If it's a 32 bit client on 64 bit windows, then the ORACLE key will be in
HKEY_LOCAL_MACHINE -> SOFTWARE -> WOW6432NODE (at least that's where it is on
my PC)
From: Storey, Robert (DCSO) [mailto:RStorey@xxxxxxxxxxxxxxxxxx]
Sent: Tuesday, May 17, 2016 3:02 PM
To: Matt Adams; Oracle L
Subject: RE: tnsping phantom file
Sorry, forgot to add that I'm on windows.
I don't have TNS_ADMIN set as an environmental variable. My client was made
from an image, with the software already installed and setup (client only).
Interesting is that when I went into regedit to see what path was setup, Oracle
was not listed as a key within the SOFTWARE setup of HKEY_Local_machine
From: Matt Adams [mailto:MAdams@xxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, May 17, 2016 1:44 PM
To: Storey, Robert (DCSO); Oracle L
Subject: RE: tnsping phantom file
On various unix flavors, I've seen oracle pick up tnsnames.ora files in /etc,
/var/opt/oracle, and $HOME. See if there is an extra file in any of these
Also check to see of the TNS_ADMIN environmental variable is set.
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Storey, Robert ;(DCSO)
Sent: Tuesday, May 17, 2016 2:32 PM
To: Oracle L
Subject: tnsping phantom file
A simple thing, tnsping. However, its causing me much grief today.
Troubleshooting connectivity issue and so I immediately do a tnsping from the
client station. Tnsping returns the expected information. App still will not
connect.
I go look at the tnsnames.ora file and the service name does NOT exist in my
file. Yet, the tnsping is returning the proper values for the service name I
am asking for (which is the default service name for our app that we put on all
computers).
I added the service name via net manager but only setup 1 of the two ports we
normally used. I also created a different service name (Service B) with the
same information. Once I added the expected service name to my tnsnames file,
the app works.
However, a tnsping returns BOTH ports I normally configure for the service
name. Not just the one I configured new. Tnsping of Service B returns just
the one value.
The screen shows me it is using the TNSNAMES adapter, but, I have no idea where
it is finding the information.
Thoughts?
**** This communication may contain privileged and/or confidential information.
If you are not the intended recipient, you are hereby notified that disclosing,
copying, or distributing of the contents is strictly prohibited. If you have
received this message in error, please contact the sender immediately and
destroy any copies of this document. ****
**** This communication may contain privileged and/or confidential information.
If you are not the intended recipient, you are hereby notified that disclosing,
copying, or distributing of the contents is strictly prohibited. If you have
received this message in error, please contact the sender immediately and
destroy any copies of this document. ****