Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Client-Server connection problem help required

Client-Server connection problem help required

From: <patnaik_at_tifrvax.tifr.res.in>
Date: 8 DEC 98 13:48:16 GMT
Message-ID: <8DEC98.13481647@tifrvax.tifr.res.in> 







Date sent:  8-DEC-1998 19:38:49 



We have a SunOS server on which we have a database SID A and have started
listener. We are trying to connnect from a client. It talks over tcp/ip
but it gives Error 12504 SID problem. We are sending SID A which exists 
on the server.



I am appending the log and trace files.



Please help.




Krishnanand Patnaik


patnaik_at_tifrvax.tifr.res.in




===============================LOG FILE=========================================





TNSLSNR for SunOS: Version 2.0.12.1.0 - Developer's Release on 8-DEC-98 16:31:04



Copyright (c) Oracle Corporation 1992.  All rights reserved.



Started at 8-DEC-98 16:31:04


Opened parameter file: /etc/listener.ora
Opened log file: /usr2/oracle/network/log/listener.log
Resolved CONNECT_TIMEOUT_LISTENER to: 10
Resolved PRESPAWN_LISTENER to: 0


Resolved STARTUP_WAIT_TIME_LISTENER to: 0
Resolved TRACE_LEVEL_LISTENER to: OFF


TNS-01200: The listener must be suid root
Resolved LISTENER to: (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 158.144.1.15) (Port = 1521)))
LISTENING ON: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=158.144.1.15)(Port=1521)))
8-DEC-98 16:31:04 ** status ** 0



ERROR at 8-DEC-98 16:31:34


nsanswer failed


    Tns error struct:


    nr err code: 0


    ns main err code: 12535


    TNS-12535: TNS:operation timed out


    ns secondary err code: 0


    nt main err code: 505


    TNS-00505: Operation timed out


    nt secondary err code: 0


    nt OS err code: 0


8-DEC-98 16:31:24 ** 0



8-DEC-98 16:35:09 ** status ** 0



ERROR at 8-DEC-98 16:36:18


nsanswer failed


    Tns error struct:


    nr err code: 0


    ns main err code: 12535


    TNS-12535: TNS:operation timed out


    ns secondary err code: 0


    nt main err code: 505


    TNS-00505: Operation timed out


    nt secondary err code: 0


    nt OS err code: 0

8-DEC-98 16:36:05 ** 0
8-DEC-98 16:37:35 ** establish ** A ** 12504
8-DEC-98 16:39:28 ** establish ** A ** 12504
8-DEC-98 16:40:57 ** establish ** A ** 12504
8-DEC-98 16:41:31 ** establish ** A ** 12504
8-DEC-98 16:45:20 ** stop ** 0





TNSLSNR for SunOS: Version 2.0.12.1.0 - Developer's Release on 8-DEC-98 16:45:24



Copyright (c) Oracle Corporation 1992.  All rights reserved.



Started at 8-DEC-98 16:45:24


Opened parameter file: /etc/listener.ora
Opened log file: /usr2/oracle/network/log/listener.log
Resolved CONNECT_TIMEOUT_LISTENER to: 10
Resolved PRESPAWN_LISTENER to: 0


Resolved STARTUP_WAIT_TIME_LISTENER to: 0
Resolved TRACE_LEVEL_LISTENER to: OFF


TNS-01200: The listener must be suid root
Resolved LISTENER to: (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 158.144.1.15) (Port = 1521)))
LISTENING ON: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=158.144.1.15)(Port=1521)))

8-DEC-98 16:45:24 ** status ** 0
8-DEC-98 16:45:38 ** status ** 0
8-DEC-98 16:46:24 ** establish ** A ** 12504
8-DEC-98 16:47:54 ** stop ** 0





TNSLSNR for SunOS: Version 2.0.12.1.0 - Developer's Release on 8-DEC-98 16:47:56



Copyright (c) Oracle Corporation 1992.  All rights reserved.



Started at 8-DEC-98 16:47:56


Opened parameter file: /etc/listener.ora
Opened log file: /usr2/oracle/network/log/listener.log
Resolved CONNECT_TIMEOUT_LISTENER to: 10
Resolved PRESPAWN_LISTENER to: 0


Resolved STARTUP_WAIT_TIME_LISTENER to: 0
Resolved TRACE_LEVEL_LISTENER to: OFF


TNS-01200: The listener must be suid root
Resolved LISTENER to: (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 158.144.1.15) (Port = 1521)))
LISTENING ON: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=158.144.1.15)(Port=1521)))

8-DEC-98 16:47:56 ** status ** 0
8-DEC-98 16:48:09 ** establish ** A ** 12504
8-DEC-98 16:49:14 ** establish ** A ** 12504
8-DEC-98 17:04:55 ** status ** 0
8-DEC-98 17:09:22 ** stop ** 0





TNSLSNR for SunOS: Version 2.0.12.1.0 - Developer's Release on 8-DEC-98 17:09:24



Copyright (c) Oracle Corporation 1992.  All rights reserved.



Started at 8-DEC-98 17:09:24


Opened parameter file: /etc/listener.ora
Opened log file: /usr2/oracle/network/log/listener.log
Resolved CONNECT_TIMEOUT_LISTENER to: 10
Resolved PRESPAWN_LISTENER to: 0


Resolved STARTUP_WAIT_TIME_LISTENER to: 0
Resolved TRACE_LEVEL_LISTENER to: OFF


TNS-01200: The listener must be suid root
Resolved LISTENER to: (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 158.144.1.15) (Port = 1521)))
LISTENING ON: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=158.144.1.15)(Port=1521)))

8-DEC-98 17:09:24 ** status ** 0
8-DEC-98 17:10:39 ** trace ** 1158
8-DEC-98 17:12:39 ** stop ** 0





TNSLSNR for SunOS: Version 2.0.12.1.0 - Developer's Release on 8-DEC-98 17:12:53



Copyright (c) Oracle Corporation 1992.  All rights reserved.



Started at 8-DEC-98 17:12:53


Opened parameter file: /etc/listener.ora
Opened log file: /usr2/oracle/network/log/listener.log
Resolved CONNECT_TIMEOUT_LISTENER to: 10
Resolved PRESPAWN_LISTENER to: 0


Resolved STARTUP_WAIT_TIME_LISTENER to: 0
Resolved TRACE_LEVEL_LISTENER to: OFF


TNS-01200: The listener must be suid root
Resolved LISTENER to: (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 158.144.1.15) (Port = 1521)))
LISTENING ON: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=158.144.1.15)(Port=1521)))

8-DEC-98 17:12:53 ** status ** 0
8-DEC-98 17:13:03 ** trace ** 0
8-DEC-98 17:13:33 ** establish ** A ** 12504
8-DEC-98 17:14:20 ** establish ** A ** 12504
8-DEC-98 17:14:50 ** establish ** A ** 12504
8-DEC-98 17:15:07 ** stop ** 0





TNSLSNR for SunOS: Version 2.0.12.1.0 - Developer's Release on 8-DEC-98 17:19:00



Copyright (c) Oracle Corporation 1992.  All rights reserved.



Started at 8-DEC-98 17:19:00


Opened parameter file: /etc/listener.ora
Opened log file: /usr2/oracle/network/log/listener.log
Resolved CONNECT_TIMEOUT_LISTENER to: 10
Resolved PRESPAWN_LISTENER to: 0


Resolved STARTUP_WAIT_TIME_LISTENER to: 0
Resolved TRACE_LEVEL_LISTENER to: OFF


TNS-01200: The listener must be suid root
Resolved LISTENER to: (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 158.144.1.15) (Port = 1521)))
LISTENING ON: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=158.144.1.15)(Port=1521)))

8-DEC-98 17:19:00 ** status ** 0
8-DEC-98 17:19:10 ** status ** 0
8-DEC-98 17:19:52 ** establish ** A ** 12504
8-DEC-98 17:20:18 ** establish ** a ** 12504
8-DEC-98 17:20:43 ** establish ** A ** 12504
8-DEC-98 17:23:08 ** establish ** ORCL ** 12505
8-DEC-98 17:24:58 ** establish ** A_ ** 12505
8-DEC-98 17:25:17 ** establish ** A ** 12504
8-DEC-98 17:36:41 ** establish ** A ** 12504
8-DEC-98 18:00:40 ** establish ** A ** 12504
8-DEC-98 18:28:27 ** establish ** A ** 12504
8-DEC-98 18:32:15 ** establish ** orcl ** 12505
============================TRACE FILE==========================================
tnslsnr:SQL*Net TNI NETWORK SERVER




tnslsnr:Started at 8-DEC-98 17:12:53


tnslsnr:Started tracing at 8-DEC-98 17:13:04
nsrefuse:entry

nsdo:entry
nsdo:opcode=SEND, *bl=97, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOCONNECTED, flags=OPN, SWP, NTO, mvd=0


nscon:entry


nscon:sending NSPTRF packet


nspsend:entry


nspsend:plen=109, type=4

nttwr:entry
nttwr:socket 9 had bytes written=109
nttwr:exit
nspsend:109 bytes to transport
nspsend:packet dump
nspsend:00 6D 00 00 04 00 00 00  |.m......|
nspsend:22 00 00 61 28 44 45 53  |"..a(DES|
nspsend:43 52 49 50 54 49 4F 4E  |CRIPTION|
nspsend:3D 28 54 4D 50 3D 29 28  |=(TMP=)(|
nspsend:56 53 4E 4E 55 4D 3D 33  |VSNNUM=3|
nspsend:33 36 30 33 38 34 30 29  |3603840)|
nspsend:28 45 52 52 3D 30 29 28  |(ERR=0)(|
nspsend:54 52 43 46 49 4C 45 4E  |TRCFILEN|
nspsend:41 4D 45 3D 2F 75 73 72  |AME=/usr|
nspsend:32 2F 6F 72 61 63 6C 65  |2/oracle|
nspsend:2F 6E 65 74 77 6F 72 6B  |/network|
nspsend:2F 74 72 61 63 65 2F 6C  |/trace/l|
nspsend:69 73 74 65 6E 65 72 2E  |istener.|


nspsend:74 72 63 29 29 00 00 00  |trc))...|
nspsend:normal exit


nscon:exit


nsdo:exit (nscon)


nsclose:entry

nsdo:entry
nsdo:opcode=CLOSE, *bl=0, uflgs=0, cflgs=DOFINI
nsdo:slot=2, state=TOCONNECTED, flags=SWP, NTO, mvd=0


nsmfr:2094 bytes at 0xe1b28


nsmfr:2094 bytes at 0xe2360


nsdo:exit

nsclose:closing transport
nttdisc:entry
nttdisc:Closed socket 9
nttdisc:exit
nsclose:global context check-out (from slot 2) complete


nsmfr:352 bytes at 0xe1340


nsclose:normal exit


nsrefuse:exit


tnslsnr:Waiting for connection request (using nsevwait with no callbacks) ...

nsevwait:entry
nsevwait:1 registered connection(s)
nsevwait:0 event(s) posted
nsevwait:m=1, t=-1
nsevwait:waiting for transport event...


ntctst:entry


ntctst:number of protocols 1 - not calling poll

sntseltst:entry
sntseltst:TESTING: for connection requests on socket 8
sntseltst:CALLING select()...
sntseltst:FOUND: connection request on socket 8
sntseltst:exit




ntctst:exit

nsevwait:1 event(s) posted
nsevwait:event is NSVCALL, on 0
nsevwait:exit




tnslsnr:Event occured at 8-DEC-98 17:13:33
nsanswer:entry


nsopen:entry


nsmal:352 bytes at 0xda960

nsopen:opening transport...
nttcon:entry
nttcon:toc = 3
nttcnp:entry
nttcnp:exit
nttcnr:entry
nttcnr:waiting to accept a connection.
nttcnr:exit
nttcon:NT layer TCP/IP connection has been established.
nttcon:exit
nsopen:transport is open
nsopen:global context check-in (to slot 2) complete
nsopen:lcl[0]=0x687f, lcl[1]=0x0, gbl[0]=0x1f3f, gbl[1]=0x0, tdu=32767, sdu=2048
nsdo:entry




nsdo:opcode=OPEN, *bl=0, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=NOTCONNECTED, flags=SWP, NTO, mvd=0
nsmal:2094 bytes at 0xe19c0


nsmal:2094 bytes at 0xe21f8


nsdo:normal exit


nsopen:normal exit


nsmal:2040 bytes at 0xe4c88

nsdo:entry
nsdo:opcode=RECV, *bl=2040, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOTOCONNECTED, flags=OPN, SWP, NTO, mvd=0
nscon:entry




nscon:doing connect handshake...


nscon:recving a packet


nsprcvs:entry

nttrd:entry
nttrd:socket 9 had bytes read=223
nttrd:exit
nsprcvs:223 bytes from transport
nsprcvs:rlen=223, plen=223, type=1
nsprcvs:packet dump
nsprcvs:00 DF 00 00 01 00 00 00  |........|
nsprcvs:01 36 01 2C 00 00 08 00  |.6.,....|
nsprcvs:7F FF C3 0A 00 00 01 00  |........|
nsprcvs:00 A5 00 3A 00 00 08 00  |...:....|
nsprcvs:01 01 00 00 00 00 00 00  |........|
nsprcvs:00 00 00 00 00 00 00 00  |........|
nsprcvs:00 00 00 00 00 00 00 00  |........|
nsprcvs:00 00 28 44 45 53 43 52  |..(DESCR|
nsprcvs:49 50 54 49 4F 4E 3D 28  |IPTION=(|
nsprcvs:41 44 44 52 45 53 53 3D  |ADDRESS=|
nsprcvs:28 50 52 4F 54 4F 43 4F  |(PROTOCO|
nsprcvs:4C 3D 54 43 50 29 28 48  |L=TCP)(H|
nsprcvs:4F 53 54 3D 31 35 38 2E  |OST=158.|
nsprcvs:31 34 34 2E 31 2E 31 35  |144.1.15|
nsprcvs:29 28 50 4F 52 54 3D 31  |)(PORT=1|
nsprcvs:35 32 31 29 29 28 43 4F  |521))(CO|
nsprcvs:4E 4E 45 43 54 5F 44 41  |NNECT_DA|
nsprcvs:54 41 3D 28 53 49 44 3D  |TA=(SID=|
nsprcvs:41 29 28 43 49 44 3D 28  |A)(CID=(|
nsprcvs:50 52 4F 47 52 41 4D 3D  |PROGRAM=|
nsprcvs:44 3A 5C 4F 52 41 4E 54  |D:\ORANT|
nsprcvs:5C 6A 72 65 31 31 5C 62  |\jre11\b|
nsprcvs:69 6E 5C 6A 61 76 61 2E  |in\java.|
nsprcvs:65 78 65 29 28 48 4F 53  |exe)(HOS|
nsprcvs:54 3D 42 41 4E 41 53 29  |T=BANAS)|
nsprcvs:28 55 53 45 52 3D 41 64  |(USER=Ad|
nsprcvs:6D 69 6E 69 73 74 72 61  |ministra|


nsprcvs:74 6F 72 29 29 29 29 00  |tor)))).|
nsprcvs:normal exit


nscon:got NSPTCN packet

nsconneg:entry
nsconneg:vsn=310, lov=300, opt=0x0, sdu=2048, tdu=32767, ntc=0xc30a
nsconneg:vsn=305, gbl=0x0, sdu=2048, tdu=32767
nsconneg:normal exit




nscon:got 165 bytes connect data


nscon:exit


nsdo:exit (nscon)


nsmfr:2040 bytes at 0xe4c88


nsanswer:normal exit


tnslsnr:Assume establishing a connection so look for a SID
tnslsnr:command = establish


nsrefuse:entry

nsdo:entry
nsdo:opcode=SEND, *bl=48, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOCONNECTED, flags=OPN, SWP, NTO, mvd=0


nscon:entry


nscon:sending NSPTRF packet


nspsend:entry


nspsend:plen=60, type=4

nttwr:entry
nttwr:socket 9 had bytes written=60
nttwr:exit
nspsend:60 bytes to transport
nspsend:packet dump
nspsend:00 3C 00 00 04 00 00 00  |.<......|
nspsend:22 00 00 30 28 44 45 53  |"..0(DES|
nspsend:43 52 49 50 54 49 4F 4E  |CRIPTION|
nspsend:3D 28 54 4D 50 3D 29 28  |=(TMP=)(|
nspsend:56 53 4E 4E 55 4D 3D 33  |VSNNUM=3|
nspsend:33 36 30 33 38 34 30 29  |3603840)|
nspsend:28 45 52 52 3D 31 32 35  |(ERR=125|


nspsend:30 34 29 29 00 00 00 00  |04))....|
nspsend:normal exit


nscon:exit


nsdo:exit (nscon)


nsclose:entry

nsdo:entry
nsdo:opcode=CLOSE, *bl=0, uflgs=0, cflgs=DOFINI
nsdo:slot=2, state=TOCONNECTED, flags=SWP, NTO, mvd=0


nsmfr:2094 bytes at 0xe19c0


nsmfr:2094 bytes at 0xe21f8


nsdo:exit

nsclose:closing transport
nttdisc:entry
nttdisc:Closed socket 9
nttdisc:exit
nsclose:global context check-out (from slot 2) complete


nsmfr:352 bytes at 0xda960


nsclose:normal exit


nsrefuse:exit


tnslsnr:Waiting for connection request (using nsevwait with no callbacks) ...

nsevwait:entry
nsevwait:1 registered connection(s)
nsevwait:0 event(s) posted
nsevwait:m=1, t=-1
nsevwait:waiting for transport event...


ntctst:entry


ntctst:number of protocols 1 - not calling poll

sntseltst:entry
sntseltst:TESTING: for connection requests on socket 8
sntseltst:CALLING select()...
sntseltst:FOUND: connection request on socket 8
sntseltst:exit




ntctst:exit

nsevwait:1 event(s) posted
nsevwait:event is NSVCALL, on 0
nsevwait:exit




tnslsnr:Event occured at 8-DEC-98 17:14:20
nsanswer:entry


nsopen:entry


nsmal:352 bytes at 0xda960

nsopen:opening transport...
nttcon:entry
nttcon:toc = 3
nttcnp:entry
nttcnp:exit
nttcnr:entry
nttcnr:waiting to accept a connection.
nttcnr:exit
nttcon:NT layer TCP/IP connection has been established.
nttcon:exit
nsopen:transport is open
nsopen:global context check-in (to slot 2) complete
nsopen:lcl[0]=0x687f, lcl[1]=0x0, gbl[0]=0x1f3f, gbl[1]=0x0, tdu=32767, sdu=2048
nsdo:entry




nsdo:opcode=OPEN, *bl=0, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=NOTCONNECTED, flags=SWP, NTO, mvd=0
nsmal:2094 bytes at 0xe19c0


nsmal:2094 bytes at 0xe21f8


nsdo:normal exit


nsopen:normal exit


nsmal:2040 bytes at 0xe4c88

nsdo:entry
nsdo:opcode=RECV, *bl=2040, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOTOCONNECTED, flags=OPN, SWP, NTO, mvd=0
nscon:entry




nscon:doing connect handshake...


nscon:recving a packet


nsprcvs:entry

nttrd:entry
nttrd:socket 9 had bytes read=223
nttrd:exit
nsprcvs:223 bytes from transport
nsprcvs:rlen=223, plen=223, type=1
nsprcvs:packet dump
nsprcvs:00 DF 00 00 01 00 00 00  |........|
nsprcvs:01 36 01 2C 00 00 08 00  |.6.,....|
nsprcvs:7F FF C3 0A 00 00 01 00  |........|
nsprcvs:00 A5 00 3A 00 00 08 00  |...:....|
nsprcvs:01 01 00 00 00 00 00 00  |........|
nsprcvs:00 00 00 00 00 00 00 00  |........|
nsprcvs:00 00 00 00 00 00 00 00  |........|
nsprcvs:00 00 28 44 45 53 43 52  |..(DESCR|
nsprcvs:49 50 54 49 4F 4E 3D 28  |IPTION=(|
nsprcvs:41 44 44 52 45 53 53 3D  |ADDRESS=|
nsprcvs:28 50 52 4F 54 4F 43 4F  |(PROTOCO|
nsprcvs:4C 3D 54 43 50 29 28 48  |L=TCP)(H|
nsprcvs:4F 53 54 3D 31 35 38 2E  |OST=158.|
nsprcvs:31 34 34 2E 31 2E 31 35  |144.1.15|
nsprcvs:29 28 50 4F 52 54 3D 31  |)(PORT=1|
nsprcvs:35 32 31 29 29 28 43 4F  |521))(CO|
nsprcvs:4E 4E 45 43 54 5F 44 41  |NNECT_DA|
nsprcvs:54 41 3D 28 53 49 44 3D  |TA=(SID=|
nsprcvs:41 29 28 43 49 44 3D 28  |A)(CID=(|
nsprcvs:50 52 4F 47 52 41 4D 3D  |PROGRAM=|
nsprcvs:44 3A 5C 4F 52 41 4E 54  |D:\ORANT|
nsprcvs:5C 6A 72 65 31 31 5C 62  |\jre11\b|
nsprcvs:69 6E 5C 6A 61 76 61 2E  |in\java.|
nsprcvs:65 78 65 29 28 48 4F 53  |exe)(HOS|
nsprcvs:54 3D 42 41 4E 41 53 29  |T=BANAS)|
nsprcvs:28 55 53 45 52 3D 41 64  |(USER=Ad|
nsprcvs:6D 69 6E 69 73 74 72 61  |ministra|


nsprcvs:74 6F 72 29 29 29 29 00  |tor)))).|
nsprcvs:normal exit


nscon:got NSPTCN packet

nsconneg:entry
nsconneg:vsn=310, lov=300, opt=0x0, sdu=2048, tdu=32767, ntc=0xc30a
nsconneg:vsn=305, gbl=0x0, sdu=2048, tdu=32767
nsconneg:normal exit




nscon:got 165 bytes connect data


nscon:exit


nsdo:exit (nscon)


nsmfr:2040 bytes at 0xe4c88


nsanswer:normal exit


tnslsnr:Assume establishing a connection so look for a SID
tnslsnr:command = establish


nsrefuse:entry

nsdo:entry
nsdo:opcode=SEND, *bl=48, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOCONNECTED, flags=OPN, SWP, NTO, mvd=0


nscon:entry


nscon:sending NSPTRF packet


nspsend:entry


nspsend:plen=60, type=4

nttwr:entry
nttwr:socket 9 had bytes written=60
nttwr:exit
nspsend:60 bytes to transport
nspsend:packet dump
nspsend:00 3C 00 00 04 00 00 00  |.<......|
nspsend:22 00 00 30 28 44 45 53  |"..0(DES|
nspsend:43 52 49 50 54 49 4F 4E  |CRIPTION|
nspsend:3D 28 54 4D 50 3D 29 28  |=(TMP=)(|
nspsend:56 53 4E 4E 55 4D 3D 33  |VSNNUM=3|
nspsend:33 36 30 33 38 34 30 29  |3603840)|
nspsend:28 45 52 52 3D 31 32 35  |(ERR=125|


nspsend:30 34 29 29 00 00 00 00  |04))....|
nspsend:normal exit


nscon:exit


nsdo:exit (nscon)


nsclose:entry

nsdo:entry
nsdo:opcode=CLOSE, *bl=0, uflgs=0, cflgs=DOFINI
nsdo:slot=2, state=TOCONNECTED, flags=SWP, NTO, mvd=0


nsmfr:2094 bytes at 0xe19c0


nsmfr:2094 bytes at 0xe21f8


nsdo:exit

nsclose:closing transport
nttdisc:entry
nttdisc:Closed socket 9
nttdisc:exit
nsclose:global context check-out (from slot 2) complete


nsmfr:352 bytes at 0xda960


nsclose:normal exit


nsrefuse:exit


tnslsnr:Waiting for connection request (using nsevwait with no callbacks) ...

nsevwait:entry
nsevwait:1 registered connection(s)
nsevwait:0 event(s) posted
nsevwait:m=1, t=-1
nsevwait:waiting for transport event...


ntctst:entry


ntctst:number of protocols 1 - not calling poll

sntseltst:entry
sntseltst:TESTING: for connection requests on socket 8
sntseltst:CALLING select()...
sntseltst:FOUND: connection request on socket 8
sntseltst:exit




ntctst:exit

nsevwait:1 event(s) posted
nsevwait:event is NSVCALL, on 0
nsevwait:exit




tnslsnr:Event occured at 8-DEC-98 17:14:50
nsanswer:entry


nsopen:entry


nsmal:352 bytes at 0xda960

nsopen:opening transport...
nttcon:entry
nttcon:toc = 3
nttcnp:entry
nttcnp:exit
nttcnr:entry
nttcnr:waiting to accept a connection.
nttcnr:exit
nttcon:NT layer TCP/IP connection has been established.
nttcon:exit
nsopen:transport is open
nsopen:global context check-in (to slot 2) complete
nsopen:lcl[0]=0x687f, lcl[1]=0x0, gbl[0]=0x1f3f, gbl[1]=0x0, tdu=32767, sdu=2048
nsdo:entry




nsdo:opcode=OPEN, *bl=0, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=NOTCONNECTED, flags=SWP, NTO, mvd=0
nsmal:2094 bytes at 0xe19c0


nsmal:2094 bytes at 0xe21f8


nsdo:normal exit


nsopen:normal exit


nsmal:2040 bytes at 0xe4c88

nsdo:entry
nsdo:opcode=RECV, *bl=2040, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOTOCONNECTED, flags=OPN, SWP, NTO, mvd=0
nscon:entry




nscon:doing connect handshake...


nscon:recving a packet


nsprcvs:entry

nttrd:entry
nttrd:socket 9 had bytes read=223
nttrd:exit
nsprcvs:223 bytes from transport
nsprcvs:rlen=223, plen=223, type=1
nsprcvs:packet dump
nsprcvs:00 DF 00 00 01 00 00 00  |........|
nsprcvs:01 36 01 2C 00 00 08 00  |.6.,....|
nsprcvs:7F FF C3 0A 00 00 01 00  |........|
nsprcvs:00 A5 00 3A 00 00 08 00  |...:....|
nsprcvs:01 01 00 00 00 00 00 00  |........|
nsprcvs:00 00 00 00 00 00 00 00  |........|
nsprcvs:00 00 00 00 00 00 00 00  |........|
nsprcvs:00 00 28 44 45 53 43 52  |..(DESCR|
nsprcvs:49 50 54 49 4F 4E 3D 28  |IPTION=(|
nsprcvs:41 44 44 52 45 53 53 3D  |ADDRESS=|
nsprcvs:28 50 52 4F 54 4F 43 4F  |(PROTOCO|
nsprcvs:4C 3D 54 43 50 29 28 48  |L=TCP)(H|
nsprcvs:4F 53 54 3D 31 35 38 2E  |OST=158.|
nsprcvs:31 34 34 2E 31 2E 31 35  |144.1.15|
nsprcvs:29 28 50 4F 52 54 3D 31  |)(PORT=1|
nsprcvs:35 32 31 29 29 28 43 4F  |521))(CO|
nsprcvs:4E 4E 45 43 54 5F 44 41  |NNECT_DA|
nsprcvs:54 41 3D 28 53 49 44 3D  |TA=(SID=|
nsprcvs:41 29 28 43 49 44 3D 28  |A)(CID=(|
nsprcvs:50 52 4F 47 52 41 4D 3D  |PROGRAM=|
nsprcvs:44 3A 5C 4F 52 41 4E 54  |D:\ORANT|
nsprcvs:5C 6A 72 65 31 31 5C 62  |\jre11\b|
nsprcvs:69 6E 5C 6A 61 76 61 2E  |in\java.|
nsprcvs:65 78 65 29 28 48 4F 53  |exe)(HOS|
nsprcvs:54 3D 42 41 4E 41 53 29  |T=BANAS)|
nsprcvs:28 55 53 45 52 3D 41 64  |(USER=Ad|
nsprcvs:6D 69 6E 69 73 74 72 61  |ministra|


nsprcvs:74 6F 72 29 29 29 29 00  |tor)))).|
nsprcvs:normal exit


nscon:got NSPTCN packet

nsconneg:entry
nsconneg:vsn=310, lov=300, opt=0x0, sdu=2048, tdu=32767, ntc=0xc30a
nsconneg:vsn=305, gbl=0x0, sdu=2048, tdu=32767
nsconneg:normal exit




nscon:got 165 bytes connect data


nscon:exit


nsdo:exit (nscon)


nsmfr:2040 bytes at 0xe4c88


nsanswer:normal exit


tnslsnr:Assume establishing a connection so look for a SID
tnslsnr:command = establish


nsrefuse:entry

nsdo:entry
nsdo:opcode=SEND, *bl=48, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOCONNECTED, flags=OPN, SWP, NTO, mvd=0


nscon:entry


nscon:sending NSPTRF packet


nspsend:entry


nspsend:plen=60, type=4

nttwr:entry
nttwr:socket 9 had bytes written=60
nttwr:exit
nspsend:60 bytes to transport
nspsend:packet dump
nspsend:00 3C 00 00 04 00 00 00  |.<......|
nspsend:22 00 00 30 28 44 45 53  |"..0(DES|
nspsend:43 52 49 50 54 49 4F 4E  |CRIPTION|
nspsend:3D 28 54 4D 50 3D 29 28  |=(TMP=)(|
nspsend:56 53 4E 4E 55 4D 3D 33  |VSNNUM=3|
nspsend:33 36 30 33 38 34 30 29  |3603840)|
nspsend:28 45 52 52 3D 31 32 35  |(ERR=125|


nspsend:30 34 29 29 00 00 00 00  |04))....|
nspsend:normal exit


nscon:exit


nsdo:exit (nscon)


nsclose:entry

nsdo:entry
nsdo:opcode=CLOSE, *bl=0, uflgs=0, cflgs=DOFINI
nsdo:slot=2, state=TOCONNECTED, flags=SWP, NTO, mvd=0


nsmfr:2094 bytes at 0xe19c0


nsmfr:2094 bytes at 0xe21f8


nsdo:exit

nsclose:closing transport
nttdisc:entry
nttdisc:Closed socket 9
nttdisc:exit
nsclose:global context check-out (from slot 2) complete


nsmfr:352 bytes at 0xda960


nsclose:normal exit


nsrefuse:exit


tnslsnr:Waiting for connection request (using nsevwait with no callbacks) ...

nsevwait:entry
nsevwait:1 registered connection(s)
nsevwait:0 event(s) posted
nsevwait:m=1, t=-1
nsevwait:waiting for transport event...


ntctst:entry


ntctst:number of protocols 1 - not calling poll

sntseltst:entry
sntseltst:TESTING: for connection requests on socket 8
sntseltst:CALLING select()...
sntseltst:FOUND: connection request on socket 8
sntseltst:exit




ntctst:exit

nsevwait:1 event(s) posted
nsevwait:event is NSVCALL, on 0
nsevwait:exit




tnslsnr:Event occured at 8-DEC-98 17:15:07
nsanswer:entry


nsopen:entry


nsmal:352 bytes at 0xda960

nsopen:opening transport...
nttcon:entry
nttcon:toc = 3
nttcnp:entry
nttcnp:exit
nttcnr:entry
nttcnr:waiting to accept a connection.
nttcnr:exit
nttcon:NT layer TCP/IP connection has been established.
nttcon:exit
nsopen:transport is open
nsopen:global context check-in (to slot 2) complete
nsopen:lcl[0]=0x687f, lcl[1]=0x0, gbl[0]=0x1f3f, gbl[1]=0x0, tdu=32767, sdu=2048
nsdo:entry




nsdo:opcode=OPEN, *bl=0, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=NOTCONNECTED, flags=SWP, NTO, mvd=0
nsmal:2094 bytes at 0xe19c0


nsmal:2094 bytes at 0xe21f8


nsdo:normal exit


nsopen:normal exit


nsmal:2040 bytes at 0xe4c88

nsdo:entry
nsdo:opcode=RECV, *bl=2040, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOTOCONNECTED, flags=OPN, SWP, NTO, mvd=0
nscon:entry




nscon:doing connect handshake...


nscon:recving a packet


nsprcvs:entry

nttrd:entry
nttrd:socket 9 had bytes read=143
nttrd:exit
nsprcvs:143 bytes from transport
nsprcvs:rlen=143, plen=143, type=1
nsprcvs:packet dump
nsprcvs:00 8F 00 00 01 00 00 00  |........|
nsprcvs:01 31 01 2C 00 00 08 00  |.1.,....|
nsprcvs:7F FF 7F 08 00 00 00 01  |........|
nsprcvs:00 73 00 1C 28 44 45 53  |.s..(DES|
nsprcvs:43 52 49 50 54 49 4F 4E  |CRIPTION|
nsprcvs:3D 28 43 4F 4E 4E 45 43  |=(CONNEC|
nsprcvs:54 5F 44 41 54 41 3D 28  |T_DATA=(|
nsprcvs:43 4F 4D 4D 41 4E 44 3D  |COMMAND=|
nsprcvs:73 74 6F 70 29 28 53 45  |stop)(SE|
nsprcvs:52 56 49 43 45 3D 4C 49  |RVICE=LI|
nsprcvs:53 54 45 4E 45 52 29 29  |STENER))|
nsprcvs:28 41 44 44 52 45 53 53  |(ADDRESS|
nsprcvs:3D 28 50 52 4F 54 4F 43  |=(PROTOC|
nsprcvs:4F 4C 3D 54 43 50 29 28  |OL=TCP)(|
nsprcvs:48 6F 73 74 3D 31 35 38  |Host=158|
nsprcvs:2E 31 34 34 2E 31 2E 31  |.144.1.1|
nsprcvs:35 29 28 50 6F 72 74 3D  |5)(Port=|


nsprcvs:31 35 32 31 29 29 29 00  |1521))).|
nsprcvs:normal exit


nscon:got NSPTCN packet

nsconneg:entry
nsconneg:vsn=305, lov=300, opt=0x0, sdu=2048, tdu=32767, ntc=0x7f08
nsconneg:vsn=305, gbl=0x0, sdu=2048, tdu=32767
nsconneg:normal exit




nscon:got 115 bytes connect data


nscon:exit


nsdo:exit (nscon)


nsmfr:2040 bytes at 0xe4c88


nsanswer:normal exit


tnslsnr:command = stop


nsrefuse:entry

nsdo:entry
nsdo:opcode=SEND, *bl=44, uflgs=0, cflgs=DOFINI, DOFCHK
nsdo:slot=2, state=TOCONNECTED, flags=OPN, SWP, NTO, mvd=0


nscon:entry


nscon:sending NSPTRF packet


nspsend:entry


nspsend:plen=56, type=4

nttwr:entry
nttwr:socket 9 had bytes written=56
nttwr:exit
nspsend:56 bytes to transport
nspsend:packet dump
nspsend:00 38 00 00 04 00 00 00  |.8......|
nspsend:22 00 00 2C 28 44 45 53  |"..,(DES|
nspsend:43 52 49 50 54 49 4F 4E  |CRIPTION|
nspsend:3D 28 54 4D 50 3D 29 28  |=(TMP=)(|
nspsend:56 53 4E 4E 55 4D 3D 33  |VSNNUM=3|
nspsend:33 36 30 33 38 34 30 29  |3603840)|


nspsend:28 45 52 52 3D 30 29 29  |(ERR=0))|
nspsend:normal exit


nscon:exit


nsdo:exit (nscon)


nsclose:entry

nsdo:entry
nsdo:opcode=CLOSE, *bl=0, uflgs=0, cflgs=DOFINI
nsdo:slot=2, state=TOCONNECTED, flags=SWP, NTO, mvd=0


nsmfr:2094 bytes at 0xe19c0


nsmfr:2094 bytes at 0xe21f8


nsdo:exit

nsclose:closing transport
nttdisc:entry
nttdisc:Closed socket 9
nttdisc:exit
nsclose:global context check-out (from slot 2) complete


nsmfr:352 bytes at 0xda960


nsclose:normal exit


nsrefuse:exit

tnslsnr:SQL*Net TNI NETWORK SERVER
tnslsnr:Shutdown at 8-DEC-98 17:15:07
tnslsnr:exit




nsdisc:entry


nsclose:entry

nsdo:entry
nsdo:opcode=CLOSE, *bl=0, uflgs=IMM, cflgs=DOFINI
nsdo:slot=1, state=CONNECTED, flags=CON, SWP, NTO, mvd=395


nsmfr:2094 bytes at 0xe02d0


nsmfr:2094 bytes at 0xe0b08


nsdo:exit

nsclose:closing transport
ntpdisc:entry
ntpdisc:exit
nsclose:global context check-out (from slot 1) complete


nsmfr:352 bytes at 0xdfb08


nsclose:normal exit


nsdisc:exit


nsdisc:entry


nsclose:entry

nsdo:entry
nsdo:opcode=CLOSE, *bl=0, uflgs=IMM, cflgs=DOFINI
nsdo:slot=0, state=NOTCONNECTED, flags=LSN, SWP, NTO, mvd=0


nsevunreg:entry


nsevunreg:normal exit


nsdo:exit

nsclose:closing transport
nttdisc:entry
nttdisc:Closed socket 8
nttdisc:exit
nsclose:global context check-out (from slot 0) complete


nsmfr:352 bytes at 0xdf320


nsclose:normal exit


nsdisc:exit



Krishnanand Patnaik				     Tel: (O) 91-22-2152971x2547
Computer Center                                           (R) 91-22-6401670-C6 
Tata Institute of Fundamental Research       e-mail: patnaik_at_tifrvax.tifr.res.in
Homi Bhabha Road                            URL: http://www.tifr.res.in/~patnaik



Bombay - 400 005


India


Received on Tue Dec 08 1998 - 07:48:16 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US