RE: tnsping phantom file
Date: Wed, 18 May 2016 16:14:38 +0000
Message-ID: <FE4C2B093843BB4B873D754E5E0BE4DB019990BCC2_at_DCSOSVMS02.dcso.org>
The “app” is our main application. It uses a config file that tells the app what oracle service name to look for in the tnsnames for making the database connection. It was not connecting because the base tnsnames file did not have the requested service name in it. Once I added the service name/info to the ..\network\admin\tnsnames.ora file, the app worked just fine.
Thanks for the doc id. I had already perused through. But, a check of the windows “set” and a search of regedit shows nothing has been set for tns_admin. A search of the computer shows no other tnsnames.ora file installed anywhere on the machine.
Thus, my quandary.
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
Sent: Wednesday, May 18, 2016 6:34 AM
To: Storey, Robert (DCSO)
Cc: Oracle L
Subject: Re: tnsping phantom file
Robert
Have you read through Setting TNS_ADMIN Environment Variable (Doc ID 111942.1) - its quiite comprehensive about how tns_admin might be set and where windows clients might read tnsnames from. In addition I see you talk about "the app" being unable to connect despite tnsping returning correct information. It looks to me as though you will also need to determin whether the app sets the environment/uses a different oracle client etc.
On Tue, May 17, 2016 at 7:32 PM, Storey, Robert (DCSO) <RStorey_at_dcso.nashville.org<mailto:RStorey_at_dcso.nashville.org>> wrote: 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?
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 18 2016 - 18:14:38 CEST