Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error 12560 in Connections once a While

441793Apr 8 2005 — edited Apr 12 2005

Hi, I`m having the same trouble with some DB`s. on Windows 2000 and 2003 whith Oracle 9.0.1, sometimes hapens thath client`s some can`t connect to DB. They recibe the ORA-012560 error.

I enable tracing on clients and i found that all have the same king of errors.
This is a piece of the Trace (User level)

[07-ABR-2005 13:32:43] nscall: connecting...
[07-ABR-2005 13:32:43] nsopen: opening transport...
[07-ABR-2005 13:32:43] nsopen: transport is open
[07-ABR-2005 13:32:43] nsnainit: inf->nsinfflg[0]: 0x21 inf->nsinfflg[1]: 0x21
[07-ABR-2005 13:32:43] nsopen: global context check-in (to slot 0) complete
[07-ABR-2005 13:32:43] nscon: doing connect handshake...
[07-ABR-2005 13:32:43] nscon: sending NSPTCN packet
[07-ABR-2005 13:32:43] nscon: got NSPTAC packet
[07-ABR-2005 13:32:43] nscon: doing connect handshake...
[07-ABR-2005 13:32:43] nscon: nsctxinf[0]=0x21, [1]=0x21
[07-ABR-2005 13:32:43] nsnainconn: inf->nsinfflg[0]: 0x21 inf->nsinfflg[1]: 0x21
[07-ABR-2005 13:32:43] nsnasend: bytes to send: 145
[07-ABR-2005 13:32:43] nsdo: 145 bytes to NS buffer
[07-ABR-2005 13:32:43] nsnareceive: buffer address: 0x4de864c bytes wanted: 2048
[07-ABR-2005 13:32:43] nsnareceive: calling NS to receive 2048 bytes into address 0x4de864c
[07-ABR-2005 13:32:43] nsdo: 153 bytes from NS buffer
[07-ABR-2005 13:32:43] nsnareceive: received 153 bytes
[07-ABR-2005 13:32:43] nsnareceive: no more data to receive - returning
[07-ABR-2005 13:32:43] nsnareceive: total bytes received: 153
[07-ABR-2005 13:32:43] nsnasend: bytes to send: 147
[07-ABR-2005 13:32:43] nsdo: 147 bytes to NS buffer
[07-ABR-2005 13:32:43] nsnareceive: buffer address: 0x4de864c bytes wanted: 2048
[07-ABR-2005 13:32:43] nsnareceive: calling NS to receive 2048 bytes into address 0x4de864c
[07-ABR-2005 13:32:43] nsdo: 177 bytes from NS buffer
[07-ABR-2005 13:32:43] nsnareceive: received 177 bytes
[07-ABR-2005 13:32:43] nsnareceive: no more data to receive - returning
[07-ABR-2005 13:32:43] nsnareceive: total bytes received: 177
[07-ABR-2005 13:32:43] nsnasend: bytes to send: 105
[07-ABR-2005 13:32:43] nsdo: 105 bytes to NS buffer
[07-ABR-2005 13:33:32] nsrdr: got NSPTMK packet
[07-ABR-2005 13:33:32] nioqrc: Recieve: returning error: 3111
[07-ABR-2005 13:33:32] nioqrs: state = interrupted (1)
[07-ABR-2005 13:33:32] nsdo: sending NSPTMK packet
[07-ABR-2005 13:33:32] nsrdr: got NSPTMK packet
[07-ABR-2005 13:33:32] nserror: nsres: id=0, op=70, ns=12582, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:33:32] nserror: nsres: id=0, op=70, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:33:32] nsrdr: got NSPTMK packet
[07-ABR-2005 13:33:32] nioqrc: Recieve: returning error: 3111
[07-ABR-2005 13:33:32] nioqrs: state = interrupted (1)
[07-ABR-2005 13:33:32] nsdo: sending NSPTMK packet
[07-ABR-2005 13:33:32] nsrdr: got NSPTMK packet
[07-ABR-2005 13:33:32] nserror: nsres: id=0, op=70, ns=12582, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:33:32] nserror: nsres: id=0, op=70, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:33:58] nsrdr: got NSPTMK packet
[07-ABR-2005 13:33:58] nioqrc: Recieve: returning error: 3111
[07-ABR-2005 13:33:58] nioqrs: state = interrupted (1)
[07-ABR-2005 13:33:58] nsdo: sending NSPTMK packet
[07-ABR-2005 13:33:58] nsrdr: got NSPTMK packet
[07-ABR-2005 13:33:58] nserror: nsres: id=0, op=70, ns=12582, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:33:58] nserror: nsres: id=0, op=70, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:34:21] nsrdr: got NSPTMK packet
[07-ABR-2005 13:34:21] nioqrc: Recieve: returning error: 3111
[07-ABR-2005 13:34:21] nioqrs: state = interrupted (1)
[07-ABR-2005 13:34:21] nsdo: sending NSPTMK packet
[07-ABR-2005 13:34:21] nsrdr: got NSPTMK packet
[07-ABR-2005 13:34:21] nserror: nsres: id=0, op=70, ns=12582, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:34:21] nserror: nsres: id=0, op=70, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:34:28] nsrdr: got NSPTMK packet
[07-ABR-2005 13:34:28] nioqrc: Recieve: returning error: 3111
[07-ABR-2005 13:34:28] nioqrs: state = interrupted (1)
[07-ABR-2005 13:34:28] nsdo: sending NSPTMK packet
[07-ABR-2005 13:34:28] nsrdr: got NSPTMK packet
[07-ABR-2005 13:34:28] nserror: nsres: id=0, op=70, ns=12582, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:34:28] nserror: nsres: id=0, op=70, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:34:28] nsrdr: got NSPTMK packet
[07-ABR-2005 13:34:28] nioqrc: Recieve: returning error: 3111
[07-ABR-2005 13:34:28] nioqrs: state = interrupted (1)
[07-ABR-2005 13:34:28] nsdo: sending NSPTMK packet
[07-ABR-2005 13:34:28] nsrdr: got NSPTMK packet
[07-ABR-2005 13:34:28] nserror: nsres: id=0, op=70, ns=12582, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:34:28] nserror: nsres: id=0, op=70, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-ABR-2005 13:34:28] nsrdr: got NSPTMK packet
[07-ABR-2005 13:34:28] nioqrc: Recieve: returning error: 3111
[07-ABR-2005 13:34:28] nioqrs: state = interrupted (1)
[07-ABR-2005 13:34:28] nsdo: sending NSPTMK packet

i canÂ´t find what`s the meaning of those errors (12582 and 12630)

Finally Sorry about my English is Horrible.

Thanks

Maximiliano MirÃ³ - System Ingenieer - DBA (Junior)

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2005

Added on Apr 8 2005

#general-database-discussions

2 comments

1,022 views