12560 error after 10 queries

From: David <abstond_at_yahoo.com>
Date: 24 Sep 2002 14:14:40 -0700
Message-ID: <46ea33b6.0209241314.db498d2@posting.google.com>

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 - 16:14:40 CDT