Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> I am having the same problem!

I am having the same problem!

From: ShadowAssassin <tariq.khan_at_gmail-dot-com.no-spam.invalid>
Date: Tue, 15 Nov 2005 02:11:21 -0600
Message-ID: <w72dnfhGm4u0BeTeRVn_vA@giganews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US