Well my problem is similar and I have traced it down to the same
thing. my application is reading tnsnames.ora etc and everything
works with sqlplus, tnsping, etc. all the diagnostics you can spend a
week on google checking!
I also get 2 files.
FILE 1 contains:
..
..
..
4020) [11-NOV-2005 13:48:32:366] nnfttran: entry
(4020) [11-NOV-2005 13:48:32:366] ---
c:\oracle\ora92\network\admin\tnsnames.ora TABLE HAS THE FOLLOWING
CONTENTS ---
(4020) [11-NOV-2005 13:48:32:366] FPL9I = (DESCRIPTION = (ADDRESS_LIST
= (ADDRESS = (PROTOCOL = TCP)(HOST = MyHost)(PORT = 1521)))
(CONNECT_DATA = (SID = DATA001) (SERVER = DEDICATED)))
(4020) [11-NOV-2005 13:48:32:366] FPL_DATA = (DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
MyHost.fauchierpartners.com)(PORT = 1521))) (CONNECT_DATA =
(SERVICE_NAME = DATA001)))
(4020) [11-NOV-2005 13:48:32:366] SCPROD = (DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
MyHost.fauchierpartners.com)(PORT = 1521))) (CONNECT_DATA = (SID =
SCPROD) (SERVER = DEDICATED)))
(4020) [11-NOV-2005 13:48:32:366] --- END
c:\oracle\ora92\network\admin\tnsnames.ora TABLE ---
(4020) [11-NOV-2005 13:48:32:366] nnfttran: exit
(4020) [11-NOV-2005 13:48:32:366] nnfttran: entry
(4020) [11-NOV-2005 13:48:32:366] nnftqnm: Using tnsnames.ora address
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
myhost.fauchierpartners.com)(PORT = 1521))) (CONNECT_DATA =
(SERVICE_NAME = DATA001))) for name FPL_DATA
(4020) [11-NOV-2005 13:48:32:366] nnfcraa: entry
(4020) [11-NOV-2005 13:48:32:366] nnfgrne: Name successfully queried
(4020) [11-NOV-2005 13:48:32:366] nnfgrne: Obtaining answer records
for FPL_DATA
..
..
..
FILE 2 contains:
..
..
..
(4020) [11-NOV-2005 12:24:44:868] ntvllt: entry
(4020) [11-NOV-2005 12:24:44:868] ntvllt: exit
(4020) [11-NOV-2005 12:24:44:868] nigini: entry
(4020) [11-NOV-2005 12:24:44:868] nigini: Count in NI global area now:
1
(4020) [11-NOV-2005 12:24:44:868] nigini: Count in NI global area now:
1
(4020) [11-NOV-2005 12:24:44:868] nrigbi: entry
(4020) [11-NOV-2005 12:24:44:868] nrigbni: entry
(4020) [11-NOV-2005 12:24:44:868] nrigbni: Unable to get data from
navigation file tnsnav.ora
(4020) [11-NOV-2005 12:24:44:868] nrigbni: exit
(4020) [11-NOV-2005 12:24:44:868] nrigbi: exit
(4020) [11-NOV-2005 12:24:44:868] nigini: exit
(4020) [11-NOV-2005 12:24:44:868] niqname: Hst is already an
NVstring.
(4020) [11-NOV-2005 12:24:44:868] niqname: Inserting CID.
(4020) [11-NOV-2005 12:24:44:868] nigtrm: Count in the NI global area
is now 0
(4020) [11-NOV-2005 12:24:44:868] nrigbd: entry
(4020) [11-NOV-2005 12:24:44:868] nrigbd: exit
(4020) [11-NOV-2005 12:24:44:868] nigtrm: Count in the NL global area
is now 0
and it ends there. I checked filemon and it is eventually finding and
reading from tnsnames.ora alright (nothing wrong with that file
either).
What is CID?!! what is niqname? and nigtrm? I am guessing that it is
trying to append the program name to the TNS entry along with
username and host.
In the version that works after Inserting CID it should say 'entry'
and then display what the completed 'tns string' is.
Received on Tue Nov 15 2005 - 02:11:21 CST