Hello ,
I am having a weird issue with my network .I have a oracle client installed on my windows and I am using this client to connect to 12.1 Database on linux .
sys@protect1:protect>@PROTECT
ERROR:
ORA-12170: TNS :Connection timeout occurred
The above issue is happening intermittently and it is connecting fine if I try for the 2nd time ....
Warning: You are no longer connected to ORACLE.
sys@protect1:protect>@PROTECT
Connected.
USERNAME INST_NAME HOST_NAME SID SERIAL# VERSION STARTED SPID OPID CPID SADDR PADDR
-------------------- -------------------- ------------------------- ----- -------- ---------- -------- ---------- ----- --------------- ---------------- ----------------
SYS protect-protect localhost.localdomain 33 44657 12.1.0.2.0 20180331 5352 30 10220:9820 00000000BDEEE1C0 00000000BDA5DAF0
I am also seeing more
SQL*Net break/reset to client wait events when I run the Swingbench load against the database.Please advise sys@protect1:protect> @ash/ashtop sql_id,event2 1=1 &5min
Total Distinct
Seconds AAS %This SQL_ID EVENT2 FIRST_SEEN LAST_SEEN Execs Seen
--------- ------- ------- ------------- ------------------------------------------ ------------------- ------------------- ----------
400 1.3 79% | SQL*Net break/reset to client 2018-03-31 11:54:31 2018-03-31 11:59:29 1
40 .1 8% | 37znp4xvzx7p9 ON CPU 2018-03-31 11:54:30 2018-03-31 11:55:15 2
40 .1 8% | resmgr:cpu quantum 2018-03-31 11:54:31 2018-03-31 11:55:16 1
8 .0 2% | ON CPU 2018-03-31 11:54:33 2018-03-31 11:56:20 1
sys@protect1:protect>@ash/ashtop p1,p2,p3 "event2='SQL*Net break/reset to client'" &5min
Total Distinct
Seconds AAS %This P1 P2 P3 FIRST_SEEN LAST_SEEN Execs Seen
--------- ------- ------- ---------- ---------- ---------- ------------------- ------------------- ----------
395 1.3 100% | 1413697536 0 0 2018-03-31 11:54:53 2018-03-31 11:59:52 1
1 .0 0% | 1413697536 1 0 2018-03-31 11:55:34 2018-03-31 11:55:34 1
Also when I ping the Server IP from windows command Prompt below is happening.
First time it reports that Destination host unreachable
C:\Users\User>ping 192.168.56.21
Pinging 192.168.56.21 with 32 bytes of data:
Reply from 192.168.56.1: Destination host unreachable.
Reply from 192.168.56.21: bytes=32 time<1ms TTL=64
Reply from 192.168.56.21: bytes=32 time<1ms TTL=64
Reply from 192.168.56.21: bytes=32 time<1ms TTL=64
Ping statistics for 192.168.56.21:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
C:\Users\User>ping 192.168.56.21
Pinging 192.168.56.21 with 32 bytes of data:
Reply from 192.168.56.21: bytes=32 time<1ms TTL=64
Reply from 192.168.56.21: bytes=32 time<1ms TTL=64
Reply from 192.168.56.21: bytes=32 time<1ms TTL=64
Reply from 192.168.56.21: bytes=32 time<1ms TTL=64
Ping statistics for 192.168.56.21:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms