Re: Desperately seeking help in deciphering part of sqlnet

2002-08-19 Thread James Howerton

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...

>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Desperately seeking help in deciphering part of sqlnet trace file

2002-08-19 Thread Rick_Cale

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).