Hehe... One more reason to apply patches proactively. :)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"David" <abstond_at_yahoo.com> wrote in message news:46ea33b6.0209251048.5896ba4e_at_posting.google.com...
> I upgraded the users to mdac 2.7 and the problem went away.
>
>
>
> Thomas Gaines <Thomas.Gaines_at_noaa.gov> wrote in message news:<3D90EB2B.5593CB1E_at_noaa.gov>...
> > 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 Fri Sep 27 2002 - 06:49:46 CDT
