Re: tnsping phantom file

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 17 May 2016 14:25:30 -0500
Message-ID: <CAP79kiSwTbNkE4dYuyA8U7ShmfyFQKHAkfjV0vATQftLHxC4sA_at_mail.gmail.com>

Make sure you're using regedit from c:\windows\syswow64 to easily find the 32-bit registry keys.

Chris

On Tue, May 17, 2016 at 2:02 PM, Storey, Robert (DCSO) < RStorey_at_dcso.nashville.org> wrote:

> 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_at_TroverSolutions.com]
> *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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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. ****
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 17 2016 - 21:25:30 CEST