Oracle-L: Desperately seeking help in deciphering part of sqlnet trace file

From: <Rick_Cale_at_teamhealth.com>
Date: Mon, 19 Aug 2002 12:18:22 -0800
Message-ID: <F001.004B94B5.20020819121822@fatcity.com>

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). Received on Mon Aug 19 2002 - 15:18:22 CDT