Hello everybody!
As stated before I've got a Problem inserting new data into my tables from one of my two Clients...
The System consists of on Server running under Windows 2008 R2 with an ORACLE11g database.
I've got two (nearly identical Clients) running Windows 7 prof 64bit and Oracle 11g 32 Bit Client.
I've got an Application created in Delphi using DOA-Tools to do the database-stuff.
The whole application was now transferred from an old Oracle 8.1.7 to 11g.
TNS-Ping from both Clients is working without any Problem. Connection via SQLplus and inserting data into my tables is working fine from both Clients too.
Now for my Problem:
Inserting new data (rows) into tabels (it doesn't matter which one) fails from one of the Clients. The Delphi-application freezes and inside the table no data is created.
I tried to track down the problem
via trace function from Oracle-database on client-side. One of the differences I found inside the trace-files seems to be the way the Connection to the database was made. But I don't know why...
In the follwonig you can find the two trace-files:
A working client-machine:
===================
nrigbni:Unable to get data from navigation file tnsnav.ora
nnftmlf_make_local_addrfile:construction of local names file failed
nnftmlf_make_system_addrfile:system names file is C:\oracle\11.2.0_32Bit\client_1\NETWORK\ADMIN\tnsnames.ora
niotns:Not trying to enable dead connection detection.
niotns:Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.65.160)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MyLPVSService)(CID=(PROGRAM=C:\LS\LPVS\App\LPVS2015.exe)(HOST=ID0853-LPVS2)(USER=Administrator))))
nscall:connecting...
nsc2addr:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.65.160)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MyLPVSService)(CID=(PROGRAM=C:\LS\LPVS\App\LPVS2015.exe)(HOST=ID0853-LPVS2)(USER=Administrator))))
nttbnd2addr:using host IP address: 172.20.65.160
nsopen:opening transport...
nttcni:Tcp conn timeout = 60000 (ms)
nttcni:trying to connect to socket 744.
nttcni:connected on ipaddr 172.20.65.158
nttcon:set TCP_NODELAY on 744
nsopen:transport is open
nsnainit:inf->nsinfflg[0]: 0x41 inf->nsinfflg[1]: 0x41
nsopen:global context check-in (to slot 0) complete
nscon:doing connect handshake...
nscon:sending NSPTCN packet
nscon:got NSPTRS packet
nscon:sending NSPTCN packet
nscon:got NSPTAC packet
nscon:connect handshake is complete
nscon:nsctxinf[0]=0x61, [1]=0x1
nsnainconn:inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x1
nsnasend:bytes to send: 146
nsdo:146 bytes to NS buffer
nsnareceive:buffer address: 0x185cb0 bytes wanted: 2048
nsnareceive:calling NS to receive 2048 bytes into address 0x185cb0
nsdo:117 bytes from NS buffer
nsnareceive:received 117 bytes
nsnareceive:no more data to receive - returning
nsnareceive:total bytes received: 117
nscontrol:Vect I/O support: 1nszgclv:SQLNET.ALLOWED_LOGON_VERSION not found, using default.
nstimarmed:no timer allocated
nsclose:closing transport
nsclose:global context check-out (from slot 0) complete
B not working client-machine:
=======================
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\11.2.0_32Bit\client_1\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=172.20.65.160)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MyLPVSService)(CID=(PROGRAM=C:\LS\LPVS\App\LPVS2015.exe)(HOST=ID0853-LPVS)(USER=LSAdmin))))
nscall: connecting...
nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address: 172.20.65.160
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 508.
nttcon: set TCP_NODELAY on 508
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0x1 inf->nsinfflg[1]: 0x1
nsopen: global context check-in (to slot 0) complete
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTRS packet
nscon: sending NSPTCN packet
nscon: got NSPTAC packet
nscon: doing connect handshake...
nscon: nsctxinf[0]=0x21, [1]=0x1
nsnainconn: inf->nsinfflg[0]: 0x21 inf->nsinfflg[1]: 0x1
nsnasend: bytes to send: 133
nsdo: 133 bytes to NS buffer
nsnareceive: buffer address: 0x18ba90 bytes wanted: 2048
nsnareceive: calling NS to receive 2048 bytes into address 0x18ba90
nsdo: 117 bytes from NS buffer
nsnareceive: received 117 bytes
nsnareceive: no more data to receive - returning
nsnareceive: total bytes received: 117
Any idea? I would be glad to heere from you!!! Thanks in advance!
H. Sackmann