Oracle Connection being dropped

From: Phil Adams <pdadams_at_enterprise.net>
Date: 4 Jun 2003 09:55:23 -0700
Message-ID: <b8e09280.0306040855.12785a3b_at_posting.google.com>


Hi, newbie oracle problem.

I'm making calls to an oracle DB through a dll. the DB is 8.5, the Oracle client is 8.17.

The problem is quite strange, I open the Database, then call a method to retrive some data trhu the dll, was passes ok, then I call this mehtod again when another dialog is shown (straight after), which fails with -1012 (NOT_LOGGED_ON?). The trace output is as follows:

  • TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is C:\ORACLE\ORA81\network\trace\sqlnet.trc New trace level is 4
  • TRACE CONFIGURATION INFORMATION ENDS ---
  • PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source C:\oracle\ora81\network\admin\sqlnet.ora Parameter source loaded successfully

Attempted load of local pfile source C:\REDIST\sqlnet.ora Parameter source was not loaded

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-   TRACE_LEVEL_CLIENT = user
  NAMES.DIRECTORY_PATH = (TNSNAMES)
  trace_directory_client = C:\ORACLE\ORA81\network\trace   SQLNET.AUTHENTICATION_SERVICES = (NTS)   log_directory_client = C:\ORACLE\ORA81\network\log   trace_file_client = sqlnet
  log_file_client = sqlnet
--- PARAMETER SOURCE INFORMATION ENDS ---

  • LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "C:\ORACLE\ORA81\network\log\sqlnet.log" Log stream validation not requested
  • LOG CONFIGURATION INFORMATION ENDS ---
nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbni: Unable to get data from navigation file tnsnav.ora nncpmlf_make_local_addrfile: construction of local names file failed nncpmsf_make_sys_addrfile: system names file is C:\oracle\ora81\network\admin\tnsnames.ora
niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ndsuk6542)(PORT=1521)))(CONNECT_DATA=(SID=RA)(CID=(PROGRAM=c:\redist\TtvBigButtonServer.exe)(HOST=TTVUK10406)(USER=AdamsP)))) nscall: connecting...
nttbnd2addr: port resolved to 1521
nttbnd2addr: looking up IP addr for host: ndsuk6542
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 1588.
nttcon: set TCP_NODELAY on 1588
nsopen: transport is open

nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61 nsopen: global context check-in (to slot 0) complete
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTRD packet

nscall: redirected
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 0) complete nscall: connecting...
nttbnd2addr: port resolved to 1359
nttbnd2addr: using host IP address: 172.17.225.157
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 1580.
nttcon: set TCP_NODELAY on 1580
nsopen: transport is open

nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61 nsopen: global context check-in (to slot 0) complete
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTAC packet
nscon: doing connect handshake...
nscon: nsctxinf[0]=0x61, [1]=0x1

nsnainconn: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x1 nsnasend: bytes to send: 155
nsdo: 155 bytes to NS buffer
nsnareceive: buffer address: 0x1bdb020 bytes wanted: 2048 nsnareceive: calling NS to receive 2048 bytes into address 0x1bdb020 nsdo: 117 bytes from NS buffer
nsnareceive: received 117 bytes
nsnareceive: no more data to receive - returning
nsnareceive: total bytes received: 117

  • I think this is where its going wrong, but I don't understand the notations.

nioqbr: state = normal (0)
nsdo: sending NSPTMK packet
nioqrs: state = interrupted (1)
nsdo: sending NSPTMK packet
nsrdr: got NSPTMK packet

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

nioqbr: state = normal (0)
nsdo: sending NSPTMK packet
nioqrs: state = interrupted (1)
nsdo: sending NSPTMK packet
nsrdr: got NSPTMK packet
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
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

nioqbr: state = normal (0)
nsdo: sending NSPTMK packet
nioqrs: state = interrupted (1)
nsdo: sending NSPTMK packet
nsrdr: got NSPTMK packet
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
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

***************************************** end trace info

Could someone possibly enlighten me at all?

Any help much appreciated.

Cheers

Phil Received on Wed Jun 04 2003 - 18:55:23 CEST

Original text of this message