Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

asked 2022-11-21 08:45:25 +0000

KBJR gravatar image

Connection Reset in TCPDUMP

Hi,

Attached is the TCPDUMP from WebLogic 10.3.6 OS(Hosted on Oracle Linux 64) to Oracle DB 11g Port 1521(Hosted on Oracle Linux 64).We are always receiving hang on WLS. Captured Packet shows Connection Reset. In this case, which peer is reseting the connection ?

Is it Weblogic reseting the connection when no response from DB or DB itself reseting the connection ?

Any feedback on this ?

Below is the 2 Packet Details of Dump.There are several occurred in TCPDUMP.

Frame 81536: 66 bytes on wire (528 bits), 66 bytes captured (528 bits) Ethernet II, Src: HewlettP_73:f5:f8 (ac:16:2d:73:f5:f8), Dst: HewlettP_74:13:b4 (ac:16:2d:74:13:b4) Internet Protocol Version 4, Src: 172.16.100.106, Dst: 172.16.100.115 Transmission Control Protocol, Src Port: 24194, Dst Port: 1521, Seq: 234937, Ack: 6781, Len: 0 Source Port: 24194 Destination Port: 1521 [Stream index: 48] [TCP Segment Len: 0] Sequence number: 234937 (relative sequence number) Acknowledgment number: 6781 (relative ack number) Header Length: 32 bytes Flags: 0x014 (RST, ACK) 000. .... .... = Reserved: Not set ...0 .... .... = Nonce: Not set .... 0... .... = Congestion Window Reduced (CWR): Not set .... .0.. .... = ECN-Echo: Not set .... ..0. .... = Urgent: Not set .... ...1 .... = Acknowledgment: Set .... .... 0... = Push: Not set .... .... .1.. = Reset: Set [Expert Info (Warning/Sequence): Connection reset (RST)] [Connection reset (RST)] [Severity level: Warning] [Group: Sequence] .... .... ..0. = Syn: Not set .... .... ...0 = Fin: Not set [TCP Flags: ·······A·R··] Window size value: 236 [Calculated window size: 30208] [Window size scaling factor: 128] Checksum: 0x21ed [unverified] [Checksum Status: Unverified] Urgent pointer: 0 Options: (12 bytes), No-Operation (NOP), No-Operation (NOP), Timestamps

Frame 281168: 66 bytes on wire (528 bits), 66 bytes captured (528 bits) Ethernet II, Src: HewlettP_73:f5:f8 (ac:16:2d:73:f5:f8), Dst: HewlettP_74:13:b4 (ac:16:2d:74:13:b4) Internet Protocol Version 4, Src: 172.16.100.106, Dst: 172.16.100.115 Transmission Control Protocol, Src Port: 24461, Dst Port: 1521, Seq: 4692, Ack: 5358, Len: 0 Source Port: 24461 Destination Port: 1521 [Stream index: 57] [TCP Segment Len: 0] Sequence number: 4692 (relative sequence number) Acknowledgment number: 5358 (relative ack number) Header Length: 32 bytes Flags: 0x014 (RST, ACK) 000. .... .... = Reserved: Not set ...0 .... .... = Nonce: Not set .... 0... .... = Congestion Window Reduced (CWR): Not set .... .0.. .... = ECN-Echo: Not set .... ..0. .... = Urgent: Not set .... ...1 .... = Acknowledgment: Set .... .... 0... = Push: Not set .... .... .1.. = Reset: Set [Expert Info (Warning/Sequence): Connection reset (RST)] [Connection reset (RST)] [Severity level: Warning] [Group: Sequence] .... .... ..0. = Syn: Not set .... .... ...0 = Fin: Not set [TCP Flags: ·······A·R··] Window size value: 236 [Calculated window size: 30208] [Window size scaling factor: 128] Checksum: 0x21ed [unverified] [Checksum Status: Unverified] Urgent pointer: 0 Options: (12 bytes), No-Operation (NOP), No-Operation (NOP), Timestamps

click to hide/show revision 2
None

updated 2022-11-21 08:50:39 +0000

grahamb gravatar image

Connection Reset in TCPDUMP

Hi,

Attached is the TCPDUMP from WebLogic 10.3.6 OS(Hosted on Oracle Linux 64) to Oracle DB 11g Port 1521(Hosted on Oracle Linux 64).We are always receiving hang on WLS. Captured Packet shows Connection Reset. In this case, which peer is reseting the connection ?

Is it Weblogic reseting the connection when no response from DB or DB itself reseting the connection ?

Any feedback on this ?

Below is the 2 Packet Details of Dump.There are several occurred in TCPDUMP.

Frame 81536: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: HewlettP_73:f5:f8 (ac:16:2d:73:f5:f8), Dst: HewlettP_74:13:b4 (ac:16:2d:74:13:b4)
Internet Protocol Version 4, Src: 172.16.100.106, Dst: 172.16.100.115
Transmission Control Protocol, Src Port: 24194, Dst Port: 1521, Seq: 234937, Ack: 6781, Len: 0
    Source Port: 24194
    Destination Port: 1521
    [Stream index: 48]
    [TCP Segment Len: 0]
    Sequence number: 234937    (relative sequence number)
    Acknowledgment number: 6781    (relative ack number)
    Header Length: 32 bytes
    Flags: 0x014 (RST, ACK)
        000. .... .... = Reserved: Not set
        ...0 .... .... = Nonce: Not set
        .... 0... .... = Congestion Window Reduced (CWR): Not set
        .... .0.. .... = ECN-Echo: Not set
        .... ..0. .... = Urgent: Not set
        .... ...1 .... = Acknowledgment: Set
        .... .... 0... = Push: Not set
        .... .... .1.. = Reset: Set
            [Expert Info (Warning/Sequence): Connection reset (RST)]
                [Connection reset (RST)]
                [Severity level: Warning]
                [Group: Sequence]
        .... .... ..0. = Syn: Not set
        .... .... ...0 = Fin: Not set
        [TCP Flags: ·······A·R··]
    Window size value: 236
    [Calculated window size: 30208]
    [Window size scaling factor: 128]
    Checksum: 0x21ed [unverified]
    [Checksum Status: Unverified]
    Urgent pointer: 0
    Options: (12 bytes), No-Operation (NOP), No-Operation (NOP), Timestamps
 
Timestamps

Frame 281168: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: HewlettP_73:f5:f8 (ac:16:2d:73:f5:f8), Dst: HewlettP_74:13:b4 (ac:16:2d:74:13:b4)
Internet Protocol Version 4, Src: 172.16.100.106, Dst: 172.16.100.115
Transmission Control Protocol, Src Port: 24461, Dst Port: 1521, Seq: 4692, Ack: 5358, Len: 0
    Source Port: 24461
    Destination Port: 1521
    [Stream index: 57]
    [TCP Segment Len: 0]
    Sequence number: 4692    (relative sequence number)
    Acknowledgment number: 5358    (relative ack number)
    Header Length: 32 bytes
    Flags: 0x014 (RST, ACK)
        000. .... .... = Reserved: Not set
        ...0 .... .... = Nonce: Not set
        .... 0... .... = Congestion Window Reduced (CWR): Not set
        .... .0.. .... = ECN-Echo: Not set
        .... ..0. .... = Urgent: Not set
        .... ...1 .... = Acknowledgment: Set
        .... .... 0... = Push: Not set
        .... .... .1.. = Reset: Set
            [Expert Info (Warning/Sequence): Connection reset (RST)]
                [Connection reset (RST)]
                [Severity level: Warning]
                [Group: Sequence]
        .... .... ..0. = Syn: Not set
        .... .... ...0 = Fin: Not set
        [TCP Flags: ·······A·R··]
    Window size value: 236
    [Calculated window size: 30208]
    [Window size scaling factor: 128]
    Checksum: 0x21ed [unverified]
    [Checksum Status: Unverified]
    Urgent pointer: 0
    Options: (12 bytes), No-Operation (NOP), No-Operation (NOP), Timestamps
Timestamps

Connection Reset in TCPDUMP

Hi,

Attached is the TCPDUMP from WebLogic 10.3.6 OS(Hosted on Oracle Linux 64) to Oracle DB 11g Port 1521(Hosted on Oracle Linux 64).We are always receiving hang on WLS. Captured Packet shows Connection Reset. In this case, which peer is reseting the connection ?

Is it Weblogic reseting the connection when no response from DB or DB itself reseting the connection ?

Any feedback on this ?

Below is the 2 Packet Details of Dump.There are several occurred in TCPDUMP.

Summary

81536 2207.351784 172.16.100.106 172.16.100.115 TCP 66 24194 → 1521 [RST, ACK] Seq=234937 Ack=6781 Win=30208 Len=0

Detail

 
Frame 81536: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: HewlettP_73:f5:f8 (ac:16:2d:73:f5:f8), Dst: HewlettP_74:13:b4 (ac:16:2d:74:13:b4)
Internet Protocol Version 4, Src: 172.16.100.106, Dst: 172.16.100.115
Transmission Control Protocol, Src Port: 24194, Dst Port: 1521, Seq: 234937, Ack: 6781, Len: 0
    Source Port: 24194
    Destination Port: 1521
    [Stream index: 48]
    [TCP Segment Len: 0]
    Sequence number: 234937    (relative sequence number)
    Acknowledgment number: 6781    (relative ack number)
    Header Length: 32 bytes
    Flags: 0x014 (RST, ACK)
        000. .... .... = Reserved: Not set
        ...0 .... .... = Nonce: Not set
        .... 0... .... = Congestion Window Reduced (CWR): Not set
        .... .0.. .... = ECN-Echo: Not set
        .... ..0. .... = Urgent: Not set
        .... ...1 .... = Acknowledgment: Set
        .... .... 0... = Push: Not set
        .... .... .1.. = Reset: Set
            [Expert Info (Warning/Sequence): Connection reset (RST)]
                [Connection reset (RST)]
                [Severity level: Warning]
                [Group: Sequence]
        .... .... ..0. = Syn: Not set
        .... .... ...0 = Fin: Not set
        [TCP Flags: ·······A·R··]
    Window size value: 236
    [Calculated window size: 30208]
    [Window size scaling factor: 128]
    Checksum: 0x21ed [unverified]
    [Checksum Status: Unverified]
    Urgent pointer: 0
    Options: (12 bytes), No-Operation (NOP), No-Operation (NOP), Timestamps

Summary

281168 6792.352201 172.16.100.106 172.16.100.115 TCP 66 24461 → 1521 [RST, ACK] Seq=4692 Ack=5358 Win=30208 Len=0

Detail

Frame 281168: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: HewlettP_73:f5:f8 (ac:16:2d:73:f5:f8), Dst: HewlettP_74:13:b4 (ac:16:2d:74:13:b4)
Internet Protocol Version 4, Src: 172.16.100.106, Dst: 172.16.100.115
Transmission Control Protocol, Src Port: 24461, Dst Port: 1521, Seq: 4692, Ack: 5358, Len: 0
    Source Port: 24461
    Destination Port: 1521
    [Stream index: 57]
    [TCP Segment Len: 0]
    Sequence number: 4692    (relative sequence number)
    Acknowledgment number: 5358    (relative ack number)
    Header Length: 32 bytes
    Flags: 0x014 (RST, ACK)
        000. .... .... = Reserved: Not set
        ...0 .... .... = Nonce: Not set
        .... 0... .... = Congestion Window Reduced (CWR): Not set
        .... .0.. .... = ECN-Echo: Not set
        .... ..0. .... = Urgent: Not set
        .... ...1 .... = Acknowledgment: Set
        .... .... 0... = Push: Not set
        .... .... .1.. = Reset: Set
            [Expert Info (Warning/Sequence): Connection reset (RST)]
                [Connection reset (RST)]
                [Severity level: Warning]
                [Group: Sequence]
        .... .... ..0. = Syn: Not set
        .... .... ...0 = Fin: Not set
        [TCP Flags: ·······A·R··]
    Window size value: 236
    [Calculated window size: 30208]
    [Window size scaling factor: 128]
    Checksum: 0x21ed [unverified]
    [Checksum Status: Unverified]
    Urgent pointer: 0
    Options: (12 bytes), No-Operation (NOP), No-Operation (NOP), Timestamps
click to hide/show revision 4
None

updated 2022-11-21 10:28:32 +0000

grahamb gravatar image

Connection Reset in TCPDUMP

Hi,

Attached is the TCPDUMP from WebLogic 10.3.6 OS(Hosted on Oracle Linux 64) to Oracle DB 11g Port 1521(Hosted on Oracle Linux 64).We are always receiving hang on WLS. Captured Packet shows Connection Reset. In this case, which peer is reseting the connection ?

Is it Weblogic reseting the connection when no response from DB or DB itself reseting the connection ?

Any feedback on this ?

Below is the 2 Packet Details of Dump.There are several occurred in TCPDUMP.

Summary

81536   2207.351784 172.16.100.106  172.16.100.115  TCP 66  24194 → 1521 [RST, ACK] Seq=234937 Ack=6781 Win=30208 Len=0
Len=0

Detail

Frame 81536: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: HewlettP_73:f5:f8 (ac:16:2d:73:f5:f8), Dst: HewlettP_74:13:b4 (ac:16:2d:74:13:b4)
Internet Protocol Version 4, Src: 172.16.100.106, Dst: 172.16.100.115
Transmission Control Protocol, Src Port: 24194, Dst Port: 1521, Seq: 234937, Ack: 6781, Len: 0
    Source Port: 24194
    Destination Port: 1521
    [Stream index: 48]
    [TCP Segment Len: 0]
    Sequence number: 234937    (relative sequence number)
    Acknowledgment number: 6781    (relative ack number)
    Header Length: 32 bytes
    Flags: 0x014 (RST, ACK)
        000. .... .... = Reserved: Not set
        ...0 .... .... = Nonce: Not set
        .... 0... .... = Congestion Window Reduced (CWR): Not set
        .... .0.. .... = ECN-Echo: Not set
        .... ..0. .... = Urgent: Not set
        .... ...1 .... = Acknowledgment: Set
        .... .... 0... = Push: Not set
        .... .... .1.. = Reset: Set
            [Expert Info (Warning/Sequence): Connection reset (RST)]
                [Connection reset (RST)]
                [Severity level: Warning]
                [Group: Sequence]
        .... .... ..0. = Syn: Not set
        .... .... ...0 = Fin: Not set
        [TCP Flags: ·······A·R··]
    Window size value: 236
    [Calculated window size: 30208]
    [Window size scaling factor: 128]
    Checksum: 0x21ed [unverified]
    [Checksum Status: Unverified]
    Urgent pointer: 0
    Options: (12 bytes), No-Operation (NOP), No-Operation (NOP), Timestamps

Summary

281168  6792.352201 172.16.100.106  172.16.100.115  TCP 66  24461 → 1521 [RST, ACK] Seq=4692 Ack=5358 Win=30208 Len=0
Len=0

Detail

Frame 281168: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: HewlettP_73:f5:f8 (ac:16:2d:73:f5:f8), Dst: HewlettP_74:13:b4 (ac:16:2d:74:13:b4)
Internet Protocol Version 4, Src: 172.16.100.106, Dst: 172.16.100.115
Transmission Control Protocol, Src Port: 24461, Dst Port: 1521, Seq: 4692, Ack: 5358, Len: 0
    Source Port: 24461
    Destination Port: 1521
    [Stream index: 57]
    [TCP Segment Len: 0]
    Sequence number: 4692    (relative sequence number)
    Acknowledgment number: 5358    (relative ack number)
    Header Length: 32 bytes
    Flags: 0x014 (RST, ACK)
        000. .... .... = Reserved: Not set
        ...0 .... .... = Nonce: Not set
        .... 0... .... = Congestion Window Reduced (CWR): Not set
        .... .0.. .... = ECN-Echo: Not set
        .... ..0. .... = Urgent: Not set
        .... ...1 .... = Acknowledgment: Set
        .... .... 0... = Push: Not set
        .... .... .1.. = Reset: Set
            [Expert Info (Warning/Sequence): Connection reset (RST)]
                [Connection reset (RST)]
                [Severity level: Warning]
                [Group: Sequence]
        .... .... ..0. = Syn: Not set
        .... .... ...0 = Fin: Not set
        [TCP Flags: ·······A·R··]
    Window size value: 236
    [Calculated window size: 30208]
    [Window size scaling factor: 128]
    Checksum: 0x21ed [unverified]
    [Checksum Status: Unverified]
    Urgent pointer: 0
    Options: (12 bytes), No-Operation (NOP), No-Operation (NOP), Timestamps