Re-transmission tlisrv requests in between Application and Database

[Former Member]

Dear Experts.

Our SAP production system is having 4 application serves those are connecting to database instance in linux ha. There were some network issue last few days. Then we analyse the network. While inspecting the network using wire-shark we could see in between database and application servers re-transmitting packets according to the attached wire-shark file.

Server Vlan is 10.10.11.0/24 [vlan 11]

Access Vlan   is 10.10.10.0/24 [vlan 10]

Users are connect though the vlan10.

App servers - 21, 22 , 23 ,24

DB server - 10.10.10.13

Please anyone can expalin me the exact issue in our system.

wireshark.txt.zip

[Former Member]

hi,

     tlisrv is oracle service & its use tcp/udp port 1527. i did not seen any problem there,because appl always access database via port 1527 so between them transmission is possible.

pls find other forum discussion about it....

https://forums.oracle.com/thread/586238?start=0&tstart=0

[ACE-SAP]

Hi

Oracle listener was by default set by SAP to listen on port 1527 instead of Oracle default 1521.

This is not true in the latest SAP versions.

Have you checked if you've got any network related warning/error in Oracle & listener alert log ?

Any message in SAP system log or work process trace ?

In ST06 / OS07N can you see network error (lost packets) ?

If not this it might be a network only problem (wrong config, defective element...) that is not related to SAP or Oracle => SCN isnot be the best place to get help...

You could try basic diagnostic with tnsping from AS to DB to see if the roundtrip time does vary a lot

tnsping <Ora_sid / service> <number_of_times>

tnsping PRD 20

Hope this can help.

562403 - FAQ: Oracle Net

1100926 - FAQ: Network performance

500235 - Network Diagnosis with NIPING