Re: Desperately seeking help in deciphering part of sqlnet

From: James Howerton <jhowerton_at_uabmc.edu>
Date: Mon, 19 Aug 2002 12:43:29 -0800
Message-ID: <F001.004B9517.20020819124329@fatcity.com>

Rick,

Are you trying to connect across a firewall? Also can you ping both directions client -> server, server -> client?

Here is what I think is important in you're trace file:

nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 204.

ntt2err: entry
ntt2err: soc 204 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport

...JIM...
>>> Rick_Cale_at_teamhealth.com 8/19/02 3:18:21 PM >>>
Hi,

I am getting a ORA-12535 timeout error when connecting to server. I can
tnsping Ok. The environment is Oracle 8.1.6 using NET8 on Win NT. Below is what I believe is relevant part of trace file. However I cannot
determine cause of error.
Any helps is appreciated.

Thanks
Rick

nttbnd2addr: using host IP address: 172.31.2.6 nttbnd2addr: exit
nsmal: 420 bytes at 0x1364890
nsmal: 1712 bytes at 0x1370d68

nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 204.

ntt2err: entry
ntt2err: soc 204 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport

nsmfr: 1712 bytes at 0x1370d68
nsmfr: 420 bytes at 0x1364890
nsmfr: 196 bytes at 0x136e540
nsmfr: 140 bytes at 0x1372b68
nladtrm: entry
nladtrm: exit
nioqper:  error from nscall
nioqper:    nr err code: 0
nioqper:    ns main err code: 12535
nioqper:    ns (2)  err code: 12560
nioqper:    nt main err code: 505

nioqper: nt (2) err code: 60
nioqper: nt OS err code: 0
niomapnserror: entry

niqme: entry
niqme: reporting NS-12535 error as ORA-12535
niqme: exit

niomapnserror: returning error 12535
niomapnserror: exit
niotns: Couldn't connect, returning 12535 niotns: exit

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: Rick_Cale_at_teamhealth.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Aug 19 2002 - 15:43:29 CDT