Re: 12560 error after 10 queries

David -

I just did a quickie search in Oracle's Metalink, and another customer had a similar issue. For her, the problem turned out to be an incomplete JDBC connection string. Here is a snippet from that forum:

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ Problems was connection string was missing SID after jdbc:oracle:oci8:@ <--- Must add SID here. =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+

Bye,
TG

David wrote:

> I wrote a vb app that uses an Oracle database. Some of the users get
> a 12560 after do 10 queries. They are using the version 9 client.
> It doesn't happen on my pc or my spare.
>
> Here is some of the trace info:
>
> ...
> ...
> nsnareceive: total bytes received: 117
> nigini: Count in NI global area now: 76
> nigini: Count in NI global area now: 76
> nncpmlf_make_local_addrfile: construction of local names file failed
> nncpmsf_make_sys_addrfile: system names file is
> c:\oracle\ora90\network\admin\tnsnames.ora
> nigtrm: Count in the NI global area is now 75
> nigtrm: Count in the NL global area is now 75
> nigini: Count in NI global area now: 76
> nigini: Count in NI global area now: 76
> niotns: niotns: setting up interrupt handler...
> niotns: Not trying to enable dead connection detection.
> niotns: Calling address:
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=xx.x.xx.x)(Port=1521)))(CONNECT_DATA=(SID=coname)(CID=(PROGRAM=G:\VBAPPS\CUSTOMER
> SERVICE\CS.EXE)(HOST=STEPHENE_PC)(USER=stephene))))
> nscall: connecting...
> nttgetport: port resolved to 1521
> nttbnd2addr: using host IP address: xx.x.xx.x
> nsopen: opening transport...
> nttcnp: Validnode Table IN use; err 0x0
> nttcni: trying to connect to socket 760.
> nttcni: trying to connect to socket 760.
> nttcni: trying to connect to socket 760.
> nttcni: trying to connect to socket 760.
> nttcni: trying to connect to socket 760.
> ntt2err: soc 760 error - operation=1, ntresnt[0]=530, ntresnt[1]=55,
> ntresnt[2]=0
> nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=55,
> nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
> nsopen: unable to open transport
> nioqper: error from nscall
> nioqper: nr err code: 0
> nioqper: ns main err code: 12560
> nioqper: ns (2) err code: 0
> nioqper: nt main err code: 530
> nioqper: nt (2) err code: 55
> nioqper: nt OS err code: 0
> niqme: reporting NS-12560 error as ORA-12560
> niomapnserror: returning error 12560
> niotns: Couldn't connect, returning 12560
> nigtrm: Count in the NI global area is now 75
> nigtrm: Count in the NL global area is now 75
> nstimarmed: no timer allocated
> nsclose: closing transport
> nsclose: global context check-out (from slot 0) complete
> nigtrm: Count in the NI global area is now 74
> nigtrm: Count in the NL global area is now 74
> nstimarmed: no timer allocated
> nsclose: closing transport
> ....
> ....
>
> Here is the entry from tnsnames:
>
> coname.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = xx.x.xx.x)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = coname)
> )
> )
>
> Any help would be appreciated.
>
> Thanks
Received on Tue Sep 24 2002 - 17:46:03 CDT