{"id":3914,"date":"2021-09-23T14:16:58","date_gmt":"2021-09-23T14:16:58","guid":{"rendered":"https:\/\/nenadnoveljic.com\/blog\/?p=3914"},"modified":"2021-09-23T14:59:02","modified_gmt":"2021-09-23T14:59:02","slug":"troubleshooting-a-networking-issue-from-the-database-perspective","status":"publish","type":"post","link":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/","title":{"rendered":"Troubleshooting a Networking Issue from the Database Perspective"},"content":{"rendered":"<h1>SQL*Net message from client<\/h1>\n<p>Firewall blocking an incoming connection is one of the most commonly networking issues reported to database teams. This problem is easy to diagnose because the behavior is consistent and easily reproducible &#8211; session creation hangs every time. Database administrators usually confirm this problem by trying to open a telnet session to the listener port.<\/p>\n<p>Recently, we were troubleshooting another type of networking problem, which was occurring randomly. The application session connected to the database, successfully executed several queries, but a query execution hung at some point. After realizing that it required some time of inactivity for the issue to happen, we managed to  reproduce it with sqlplus:<\/p>\n<pre><code>sqlplus user\/password@db\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 17 15:38:00 2021\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n\nLast Successful login time: Fri Sep 17 2021 15:34:44 +02:00\n\nConnected to:\nOracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production\nVersion 21.3.0.0.0\n\nSQL&gt; -- <span style=\"color:red\">WAIT SOME TIME BEFORE EXECUTING THE QUERY<\/span>\nSQL&gt; select 1 from dual ;<\/code><\/pre>\n<p>The query was hanging, but the session was INACTIVE waiting on SQL*Net message from the client. That was the first indication of broken communication.<\/p>\n<h1>Stacks<\/h1>\n<p>The stacks from the sqlplus and the dedicated server process, respectively, confirmed the communication problem &#8211; both processes were expecting something on the TCP socket:<\/p>\n<pre><code>#0  0x00007f814bfb875d in <span style=\"color:red\">read<\/span> () from \/lib64\/libpthread.so.0\n#1  0x00007f815051e070 in snttread () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#2  0x00007f814da0b243 in nttrd () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#3  0x00007f814d8deb17 in nsprecv () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#4  0x00007f814d8e7492 in nsrdr () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#5  0x00007f814ec642c9 in nsfull_pkt_rcv () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#6  0x00007f814ec6b58e in nsfull_brc () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#7  0x00007f8150503116 in nioqrc () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#8  0x00007f815053e376 in ttcdrv () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#9  0x00007f815050d2ad in nioqwa () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#10 0x00007f81504e1467 in upirtrc () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#11 0x00007f81504ec824 in kpurcsc () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#12 0x00007f81504e4d69 in kpuexec () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#13 0x00007f81504e0b79 in OCIStmtExecute () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libclntsh.so.19.1\n#14 0x00007f8151442182 in afioci () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libsqlplus.so\n#15 0x00007f815143a6a2 in afinbu () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libsqlplus.so\n#16 0x00007f815146efca in afixeqqry () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libsqlplus.so\n#17 0x00007f815146d3d2 in afixeqsql () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libsqlplus.so\n#18 0x00007f815146ce01 in afixeqr () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libsqlplus.so\n#19 0x00007f8151401998 in aficfd () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libsqlplus.so\n#20 0x00007f8151400b8c in aficdr () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libsqlplus.so\n#21 0x00007f815142e4c3 in afidrv () from \/u00\/oracle\/orabase\/Ora193000\/lib\/libsqlplus.so\n#22 0x0000000000400d50 in main ()<\/code><\/pre>\n<pre><code>#0  0x00007f19cb24d8c2 in <span style=\"color:red\">read<\/span> () from \/lib64\/libpthread.so.0\n#1  0x0000000015414d85 in read ()\n#2  0x000000001540eae0 in snttread ()\n#3  0x0000000006f7ffe2 in nttrd ()\n#4  0x0000000006e6c8d7 in nsprecv ()\n#5  0x0000000006e738f0 in nsrdr ()\n#6  0x00000000144173ec in nsfull_pkt_rcv ()\n#7  0x000000001441ecce in nsfull_brc ()\n#8  0x00000000153f703f in nioqrc ()\n#9  0x0000000014eec366 in opikndf2 ()\n#10 0x0000000003001988 in opitsk ()\n#11 0x00000000030070c0 in opiino ()\n#12 0x0000000014eef578 in opiodr ()\n#13 0x0000000002ffda4b in opidrv ()\n#14 0x0000000003e8b4b5 in sou2o ()\n#15 0x0000000000e91280 in opimai_real ()\n#16 0x0000000003e988fc in ssthrdmain ()\n#17 0x0000000000e910c4 in main ()<\/code><\/pre>\n<p>But we still didn&#8217;t know who stopped communicating.<\/p>\n<h1>SQL*Net Trace<\/h1>\n<p>Therefore, we configured SQL*Net trace on both client and server. The client entries below didn&#8217;t match any entries in the server trace:<\/p>\n<pre><code>(4182797376) [17-SEP-2021 15:49:38:923] nspsend: 88 48 8E 24 CE E3 30 F0  |.H.$..0.|\n(4182797376) [17-SEP-2021 15:49:38:923] nspsend: B5 D2 D6 DB 4A 63 D6 A5  |....Jc..|\n(4182797376) [17-SEP-2021 15:49:38:923] nspsend: 54 91 76 CA D3 E7 87 07  |T.v.....|\n(4182797376) [17-SEP-2021 15:49:38:923] nspsend: 1B 6C 06 01              |.l..    |\n(4182797376) [17-SEP-2021 15:49:38:923] nspsend: 348 bytes to transport\n(4182797376) [17-SEP-2021 15:49:38:923] nspsend: normal exit\n(4182797376) [17-SEP-2021 15:49:38:923] nsdofls: exit (0)\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: entry\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: acquired the bit\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: normal exit\n(4182797376) [17-SEP-2021 15:49:38:923] nsdo: nsctxrnk=0\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitcl_ts: entry\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitcl_ts: normal exit\n(4182797376) [17-SEP-2021 15:49:38:923] nsdo: normal exit\n(4182797376) [17-SEP-2021 15:49:38:923] nsfull_pkt_rcv: entry\n(4182797376) [17-SEP-2021 15:49:38:923] nsfull_pkt_rcv: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x0\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: entry\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: acquired the bit\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: normal exit\n(4182797376) [17-SEP-2021 15:49:38:923] nsfull_pkt_rcv: rank=64, nsctxrnk=0\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitcl_ts: entry\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitcl_ts: normal exit\n(4182797376) [17-SEP-2021 15:49:38:923] nsfull_pkt_rcv: nsctx: state=8, flg=0x400d, mvd=0\n(4182797376) [17-SEP-2021 15:49:38:923] nsfull_pkt_rcv: gtn=943, gtc=943, ptn=10, ptc=8074\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: entry\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: acquired the bit\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitts_ts: normal exit\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitcl_ts: entry\n(4182797376) [17-SEP-2021 15:49:38:923] snsbitcl_ts: normal exit\n(4182797376) [17-SEP-2021 15:49:38:923] nsfull_pkt_rcv: switching to application buffer\n(4182797376) [17-SEP-2021 15:49:38:923] nsrdr: entry\n(4182797376) [17-SEP-2021 15:49:38:923] nsrdr: recving a packet\n(4182797376) [17-SEP-2021 15:49:38:923] nsprecv: entry\n(4182797376) [17-SEP-2021 15:49:38:923] <span style=\"color:red\">nsprecv: reading from transport...<\/span>\n(4182797376) [17-SEP-2021 15:49:38:923] nttrd: entry<\/code><\/pre>\n<p>As we can see, the client sent data and then started reading from the TCP socket. At the same time, the server didn&#8217;t receive anything. The SQL*Net trace confirmed the interruption in the network layer.<\/p>\n<h1>TCP Dump<\/h1>\n<p>So far, we&#8217;ve used the Oracle utilities to reproduce the problem. Since we suspected the problem with TCP, we tried to reproduce the issue with netcat, and observe the communication with tcpdump. (netcat does simple client\/server communication.) It&#8217;s always good to keep the test case as lean as possible.<\/p>\n<p>First, start the server in the verbose mode on port 50000:<\/p>\n<pre><code>nc -vl 50000\nNcat: Version 7.70 ( https:\/\/nmap.org\/ncat )\nNcat: Listening on :::50000\nNcat: Listening on 0.0.0.0:50000<\/code><\/pre>\n<p>Then, send data from the client to the server:<\/p>\n<pre><code>nc servername 50000\nHallo1\nHallo2    <span style=\"color:red\">make a break here\nHallo3<\/span><\/code><\/pre>\n<p>The netcat server shows that it received the first two messages, but didn&#8217;t get the third:<\/p>\n<pre><code>Ncat: Connection from 10.144.221.18.\nNcat: Connection from 10.144.221.18:36578.\nHallo1\nHallo2<\/code><\/pre>\n<p>You can run tcpdump in concurrent sessions on the client and the server, respectively, to observe the TCP packet flow on both machines:<\/p>\n<pre><code>sudo tcpdump -nnnvv -i any host servername<\/code><\/pre>\n<pre><code>sudo tcpdump -nnvvv -i any host clientname<\/code><\/pre>\n<h1>ARP table<\/h1>\n<p>The packets for the first message came through:<\/p>\n<pre><code>...\n15:21:08.625809 IP (tos 0x0, ttl 64, id 48380, offset 0, flags [DF], proto TCP (6), length 47)\n    <span style=\"color:blue\">x.x.221.18<\/span>.46406 &gt; <span style=\"color:brown\">x.x.225.51<\/span>.50000: Flags [P.], cksum 0xd387 (incorrect -&gt; 0x89c7), seq 1:8, ack 1, win 229, length 7\n15:21:08.626177 IP (tos 0x0, ttl 64, id 63851, offset 0, flags [DF], proto TCP (6), length 40)\n    <span style=\"color:brown\">x.x.225.51<\/span>.50000 &gt; <span style=\"color:blue\">x.x.221.18<\/span>.46406: Flags [.], cksum 0xd6bd (correct), seq 1, ack 8, win 502, length 0<\/code><\/pre>\n<p>(<span style=\"color:blue\">x.x.221.18<\/span> is the client; <span style=\"color:brown\">x.x.225.51<\/span> is the database server.)<\/p>\n<p>The packets from the database server stopped arriving to the client after the following ARP request:<\/p>\n<pre><code>15:21:13.930354 ARP, Ethernet (len 6), IPv4 (len 4), Request who-has <span style=\"color:blue\">x.x.221.18<\/span> tell <span style=\"color:red\">x.x.221.119<\/span>, length 42\n15:21:13.930369 ARP, Ethernet (len 6), IPv4 (len 4), Reply <span style=\"color:blue\">x.x.221.18<\/span> is-at z:z:z:z:z:z, length 28<\/code><\/pre>\n<p>A new address appeared in the tcpdump output &#8211; <span style=\"color:red\">x.x.221.119<\/span> &#8211; even though we&#8217;ve never referenced it explicitly. It is the IP address of the second network interface card (NIC) <span style=\"color:red\">eth1<\/span> on the database server.<\/p>\n<pre><code><span style=\"color:red\">eth1<\/span>: flags=4163<up,broadcast,running,multicast>  mtu 1500\n        inet <span style=\"color:red\">x.x.221.119<\/span>  netmask 255.255.255.0  broadcast x.x.221.255\n        ether <span style=\"color:red\">y:y:y:y:y:07<\/span>  txqueuelen 1000  (Ethernet)<\/up,broadcast,running,multicast><\/code><\/pre>\n<p>The primary NIC &#8211; the one which we talked to when opening the connection &#8211; is:<\/p>\n<pre><code><span style=\"color:brown\">eth0<\/span>: flags=4163<up,broadcast,running,multicast>  mtu 1500\n        inet <span style=\"color:brown\">x.x.225.51<\/span>  netmask 255.255.255.0  broadcast x.x.225.255\n        ether <span style=\"color:brown\">y:y:y:y:y:06<\/span>  txqueuelen 1000  (Ethernet)<\/up,broadcast,running,multicast><\/code><\/pre>\n<p>The entry of the IP address on <span style=\"color:brown\">eth0<\/span> was updated with the MAC address of the <span style=\"color:red\">eth1<\/span> NIC:<\/p>\n<pre><code>arp -a\n...\nserver-alias-<span style=\"color:brown\">eth0<\/span> (<span style=\"color:brown\">x.x.225.51<\/span>) at <span style=\"color:red\">y:y:y:y:y:07<\/span> [ether] on eth0\nserver-alias-<span style=\"color:red\">eth1<\/span> (<span style=\"color:red\">x.x.221.119<\/span>) at <span style=\"color:red\">y:y:y:y:y:07<\/span> [ether] on eth0\n...<\/code><\/pre>\n<p>We can see the retries after the ARP table update:<\/p>\n<pre><code>15:21:21.393795 IP (tos 0x0, ttl 64, id 48381, offset 0, flags [DF], proto TCP (6), length 47)\n    <span style=\"color:blue\">x.x.221.18<\/span>.46406 &gt; <span style=\"color:brown\">x.x.225.51<\/span>.50000: Flags [P.], cksum 0xd387 (incorrect -&gt; 0x89bf), seq 8:15, ack 1, win 229, length 7\n15:21:21.594648 IP (tos 0x0, ttl 64, id 48382, offset 0, flags [DF], proto TCP (6), length 47)\n    <span style=\"color:blue\">x.x.221.18<\/span>.46406 &gt; <span style=\"color:brown\">x.x.225.51<\/span>.50000: Flags [P.], cksum 0xd387 (incorrect -&gt; 0x89bf), seq 8:15, ack 1, win 229, length 7\n15:21:21.795684 IP (tos 0x0, ttl 64, id 48383, offset 0, flags [DF], proto TCP (6), length 47)\n    <span style=\"color:blue\">x.x.221.18<\/span>.46406 &gt; <span style=\"color:brown\">x.x.225.51<\/span>.50000: Flags [P.], cksum 0xd387 (incorrect -&gt; 0x89bf), seq 8:15, ack 1, win 229, length 7\n...<\/code><\/pre>\n<p>But why were only some clients having the problem? And why could the same clients communicate with other database servers?<\/p>\n<p>Since all three IP addresses involved in this communication were belonging to the same subnet, a special routing, presumably, kicked in and produced the bad ARP table entry. Instead of drilling into the genesis of the wrong ARP table entry, we assigned an IP address from another subnet to the NIC <span style=\"color:red\">eth1<\/span>, which fixed the issue. A separate subnet for the second interface was the requirement anyway, which we overlooked when configuring the server.<\/p>\n<h1>Summary<\/h1>\n<p>The following symptoms might indicate that TCP packets are not reaching their destination:<\/p>\n<ul>\n<li>The application is executing a query, but the session is waiting on SQL*Net message from client.<\/li>\n<li>Both the application and the database server process are reading from the TCP socket.<\/li>\n<li>The SQL*Net trace shows that data was sent, but the corresponding SQL*Net trace entries are missing on the server side.<\/li>\n<\/ul>\n<p>You can reproduce the issue with netcat and capture the traffic with tcpdump to see if TCP packets are not arriving and investigate further.<\/p>\n<p>In our case, a wrong ARP table entry was causing the problem.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Identifying a networking issue with Oracle and OS tools <a href=\"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/\" class=\"more-link\">Continue Reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[5,23],"tags":[],"class_list":["post-3914","post","type-post","status-publish","format-standard","hentry","category-oracle","category-tcp-ip"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Troubleshooting a Networking Issue from the Database Perspective - All-round Database Topics<\/title>\n<meta name=\"description\" content=\"Identifying a networking issue with Oracle and OS tools\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Troubleshooting a Networking Issue from the Database Perspective - All-round Database Topics\" \/>\n<meta property=\"og:description\" content=\"Identifying a networking issue with Oracle and OS tools\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/\" \/>\n<meta property=\"og:site_name\" content=\"All-round Database Topics\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-23T14:16:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-23T14:59:02+00:00\" \/>\n<meta name=\"author\" content=\"Nenad Noveljic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Troubleshooting a Networking Issue from the Database Perspective\" \/>\n<meta name=\"twitter:description\" content=\"Identifying a networking issue with Oracle and OS tools\" \/>\n<meta name=\"twitter:creator\" content=\"@NenadNoveljic\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nenad Noveljic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/\"},\"author\":{\"name\":\"Nenad Noveljic\",\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/#\\\/schema\\\/person\\\/51458d9dd86dbbdd19f5add451d44efa\"},\"headline\":\"Troubleshooting a Networking Issue from the Database Perspective\",\"datePublished\":\"2021-09-23T14:16:58+00:00\",\"dateModified\":\"2021-09-23T14:59:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/\"},\"wordCount\":672,\"commentCount\":0,\"articleSection\":[\"Oracle\",\"TCP\\\/IP\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/\",\"url\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/\",\"name\":\"Troubleshooting a Networking Issue from the Database Perspective - All-round Database Topics\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/#website\"},\"datePublished\":\"2021-09-23T14:16:58+00:00\",\"dateModified\":\"2021-09-23T14:59:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/#\\\/schema\\\/person\\\/51458d9dd86dbbdd19f5add451d44efa\"},\"description\":\"Identifying a networking issue with Oracle and OS tools\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/troubleshooting-a-networking-issue-from-the-database-perspective\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Troubleshooting a Networking Issue from the Database Perspective\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/\",\"name\":\"All-round Database Topics\",\"description\":\"Nenad Noveljic\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/#\\\/schema\\\/person\\\/51458d9dd86dbbdd19f5add451d44efa\",\"name\":\"Nenad Noveljic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97b796613ea48ec8a7b79c8ffe1c685dcffc920c68121f6238d5caab5070670?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97b796613ea48ec8a7b79c8ffe1c685dcffc920c68121f6238d5caab5070670?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97b796613ea48ec8a7b79c8ffe1c685dcffc920c68121f6238d5caab5070670?s=96&d=mm&r=g\",\"caption\":\"Nenad Noveljic\"},\"sameAs\":[\"nenad-noveljic-9b746a6\",\"https:\\\/\\\/x.com\\\/NenadNoveljic\"],\"url\":\"https:\\\/\\\/nenadnoveljic.com\\\/blog\\\/author\\\/nenad\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Troubleshooting a Networking Issue from the Database Perspective - All-round Database Topics","description":"Identifying a networking issue with Oracle and OS tools","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/","og_locale":"en_US","og_type":"article","og_title":"Troubleshooting a Networking Issue from the Database Perspective - All-round Database Topics","og_description":"Identifying a networking issue with Oracle and OS tools","og_url":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/","og_site_name":"All-round Database Topics","article_published_time":"2021-09-23T14:16:58+00:00","article_modified_time":"2021-09-23T14:59:02+00:00","author":"Nenad Noveljic","twitter_card":"summary_large_image","twitter_title":"Troubleshooting a Networking Issue from the Database Perspective","twitter_description":"Identifying a networking issue with Oracle and OS tools","twitter_creator":"@NenadNoveljic","twitter_misc":{"Written by":"Nenad Noveljic","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/#article","isPartOf":{"@id":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/"},"author":{"name":"Nenad Noveljic","@id":"https:\/\/nenadnoveljic.com\/blog\/#\/schema\/person\/51458d9dd86dbbdd19f5add451d44efa"},"headline":"Troubleshooting a Networking Issue from the Database Perspective","datePublished":"2021-09-23T14:16:58+00:00","dateModified":"2021-09-23T14:59:02+00:00","mainEntityOfPage":{"@id":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/"},"wordCount":672,"commentCount":0,"articleSection":["Oracle","TCP\/IP"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/","url":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/","name":"Troubleshooting a Networking Issue from the Database Perspective - All-round Database Topics","isPartOf":{"@id":"https:\/\/nenadnoveljic.com\/blog\/#website"},"datePublished":"2021-09-23T14:16:58+00:00","dateModified":"2021-09-23T14:59:02+00:00","author":{"@id":"https:\/\/nenadnoveljic.com\/blog\/#\/schema\/person\/51458d9dd86dbbdd19f5add451d44efa"},"description":"Identifying a networking issue with Oracle and OS tools","breadcrumb":{"@id":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nenadnoveljic.com\/blog\/troubleshooting-a-networking-issue-from-the-database-perspective\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nenadnoveljic.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Troubleshooting a Networking Issue from the Database Perspective"}]},{"@type":"WebSite","@id":"https:\/\/nenadnoveljic.com\/blog\/#website","url":"https:\/\/nenadnoveljic.com\/blog\/","name":"All-round Database Topics","description":"Nenad Noveljic","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nenadnoveljic.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/nenadnoveljic.com\/blog\/#\/schema\/person\/51458d9dd86dbbdd19f5add451d44efa","name":"Nenad Noveljic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a97b796613ea48ec8a7b79c8ffe1c685dcffc920c68121f6238d5caab5070670?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a97b796613ea48ec8a7b79c8ffe1c685dcffc920c68121f6238d5caab5070670?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a97b796613ea48ec8a7b79c8ffe1c685dcffc920c68121f6238d5caab5070670?s=96&d=mm&r=g","caption":"Nenad Noveljic"},"sameAs":["nenad-noveljic-9b746a6","https:\/\/x.com\/NenadNoveljic"],"url":"https:\/\/nenadnoveljic.com\/blog\/author\/nenad\/"}]}},"_links":{"self":[{"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/posts\/3914","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/comments?post=3914"}],"version-history":[{"count":2,"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/posts\/3914\/revisions"}],"predecessor-version":[{"id":4021,"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/posts\/3914\/revisions\/4021"}],"wp:attachment":[{"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/media?parent=3914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/categories?post=3914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nenadnoveljic.com\/blog\/wp-json\/wp\/v2\/tags?post=3914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}