{"id":5982,"date":"2017-06-01T13:17:12","date_gmt":"2017-06-01T18:17:12","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=5982"},"modified":"2017-06-01T13:17:12","modified_gmt":"2017-06-01T18:17:12","slug":"finding-client-side-port-in-oracle","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2017\/06\/01\/finding-client-side-port-in-oracle\/","title":{"rendered":"Finding client side port in Oracle"},"content":{"rendered":"<pre>\r\n\r\nselect machine||':'||port from gv\\$active_session_history where machine like '%app01%' and inst_id = 1\" | sort -u\r\n------------------------------------------------------------\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34218\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34252\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34312\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34313\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34314\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34317\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34319\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34326\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34328\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34331\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34332\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34334\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34336\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34338\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34340\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34342\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34344\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34346\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34348\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34350\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34352\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34354\r\nMACHINE||':'||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34357\r\n<\/pre>\n<p>You can then use this to find the thread with this port open on the client server, and:<\/p>\n<p>Issue an strace against the thread<br \/>\nGather a thread dump to determine its state<\/p>\n<p>Get the file descriptor on the client server associated with this socket&#8230;<\/p>\n<pre>\r\n[root@cmhlpromsapp01 ~]# netstat -aenp | grep 34342\r\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 172.27.5.4:34342\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 172.27.3.178:1521\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ESTABLISHED 20062\u00a0\u00a0\u00a0\u00a0\u00a0 608150577\u00a0 452\/java\r\n[root@cmhlpromsapp01 ~]# ls -lrt \/proc\/452\/fd | grep 608150577\r\nlrwx------. 1 sa-oms-eomadmin domain users 64 Nov 13 09:05 986 -> socket:[608150577]\r\n[root@cmhlpromsapp01 ~]# strace -f -p 452 2>&1 | grep '(986'\r\n[pid\u00a0 1989] sendto(986, \"\\0\\0\\0N\\6 \\0\\0\\0\\0\\3^4\\2\\200`\\1\\23\\0\\0\\1\\1\\r\\0\\0\\0\\0\\4\\177\\377\\377\\377\"..., 78, 0, NULL, 0 <unfinished ...>\r\n[pid\u00a0 1989] recvfrom(986,\u00a0 <unfinished ...>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>select machine||&#8217;:&#8217;||port from gv\\$active_session_history where machine like &#8216;%app01%&#8217; and inst_id = 1&#8243; | sort -u &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34218 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34252 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34312 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34313 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34314 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34317 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34319 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34326 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34328 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34331 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34332 MACHINE||&#8217;:&#8217;||PORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname.domain:34334&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2017\/06\/01\/finding-client-side-port-in-oracle\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,14,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5982"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=5982"}],"version-history":[{"count":4,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5982\/revisions"}],"predecessor-version":[{"id":5986,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5982\/revisions\/5986"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=5982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=5982"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=5982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}