Oracle Connection being dropped
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
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