{"id":16206,"date":"2022-01-29T13:23:52","date_gmt":"2022-01-29T05:23:52","guid":{"rendered":"http:\/\/www.rao-bing.cn\/?p=16206"},"modified":"2022-01-29T13:28:31","modified_gmt":"2022-01-29T05:28:31","slug":"dameng8-unix-domain-socket","status":"publish","type":"post","link":"http:\/\/www.rao-bing.cn\/index.php\/2022\/01\/29\/16206\/","title":{"rendered":"\u8fbe\u68a68\u4f7f\u7528unix domain socket\u8fde\u63a5\u6570\u636e\u5e93"},"content":{"rendered":"

\u8fbe\u68a68\u6570\u636e\u5e93\u7f3a\u7701\u662f\u4e0d\u4ea7\u751fsocket\u6587\u4ef6\u7684\uff0c\u9700\u8981\u4fee\u6539dm.ini\u4e2d\u7684\u4e00\u4e2a\u53c2\u6570\uff0cUNIX_SOCKET_PATHNAME\uff0c\u8fd9\u4e2a\u53c2\u6570\u7f3a\u7701\u662f\u7a7a\u4e32\uff0c\u8fd9\u4e2a\u53c2\u6570\u662f\u6307\u5b9asocket\u6587\u4ef6\u7684\u8def\u5f84\u548c\u6587\u4ef6\u540d\u7684\uff0c\u6307\u5b9a\u4e00\u4e2admdba\u6709\u6743\u9650\u8bfb\u5199\u7684\u8def\u5f84+\u6587\u4ef6\u540d\uff0c\u6bd4\u5982\uff1a<\/p>\n

UNIX_SOCKET_PATHNAME=\/home\/dm\/dm1.sock<\/p>\n

\u91cd\u542f\u6570\u636e\u5e93\uff0c\u8fd9\u4e2a\u6587\u4ef6\u5c31\u751f\u6210\u4e86\uff0c\u4f7f\u7528disql\u65f6\uff0c\u5229\u7528unix domain socket\u8fde\u63a5\u7684\u7528\u6cd5\u662f\uff1a<\/p>\n

disql <username>\/<password>@<unix domain socket filename>#{inet_type=UNIXSOCKET}<\/p>\n

\u4f8b\u5982\uff1a<\/p>\n

disql SYSDBA\/SYSDBA@\/home\/dm\/dm1.sock#{inet_type=UNIXSOCKET<\/a>}<\/p>\n

\u6587\u6863\u4e0a\u8bf4\u5fc5\u987b\u8981\u52a0\u4e0a#{inet_type=UNIXSOCKET}\uff0c\u5b9e\u6d4b\u4f3c\u4e4e\u6ca1\u6709\u8fd9\u90e8\u5206\u4e5f\u80fd\u6b63\u5e38\u8fde\u63a5\u3002<\/p>\n

\u5982\u679c\u4f7f\u7528JDBC\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u9700\u8981\u989d\u5916\u7684jar\u5305\uff0c\u8fbe\u68a6\u7684jdbc driver\u4f1a\u5f15\u7528junixsocket\u7684\u4e00\u4e9b\u529f\u80fd\uff0c\u9700\u8981\u53bbgithub\u4e0b\u8f7d\u3002<\/p>\n

\u6211\u4f7f\u7528\u7684\u7684\u662f2.4.0\u7248\u672c\uff1ahttps:\/\/github.com\/kohlschutter\/junixsocket\/releases\/download\/junixsocket-parent-2.4.0\/junixsocket-dist-2.4.0-bin.zip<\/a><\/p>\n

\u89e3\u5f00\u8fd9\u4e2a\u538b\u7f29\u5305\uff0c\u5c06 junixsocket-native-common-2.4.0.jar \u548c<\/p>\n

junixsocket-common-2.4.0.jar \u52a0\u5165\u5230CLASSPATH<\/p>\n

\u5728\u4f7f\u7528java\u7a0b\u5e8f\u8fde\u63a5\u6570\u636e\u5e93\u65f6\uff0c\u8fde\u63a5\u4e32\u7684\u5199\u6cd5\uff1a<\/p>\n

jdbc:dm:\/\/?unixSocketFile=\/home\/dm\/dm1.sock<\/p>\n","protected":false},"excerpt":{"rendered":"

\u8fbe\u68a68\u4f7f\u7528 unix domain socket\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65b9\u6cd5<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"aside","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[47],"class_list":["post-16206","post","type-post","status-publish","format-aside","hentry","category-uncategorized","tag-unix-domain-socket","post_format-post-format-aside"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p8gSFq-4do","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":16123,"url":"http:\/\/www.rao-bing.cn\/index.php\/2020\/06\/23\/16123\/","url_meta":{"origin":16206,"position":0},"title":"\u795e\u821f\u901a\u7528\u6570\u636e\u5e93\u53cc\u673a\u5207\u6362\u73af\u5883\u642d\u5efa","author":"raobing","date":"2020-06-23","format":"aside","excerpt":"\u795e\u821f\u901a\u7528\u7684\u53cc\u673a\u5207\u6362\u73af\u5883\u539f\u7406\u793a\u610f\u56fe\uff1a \u795e\u901a\u6570\u636e\u5e93\u7684\u53cc\u673a\u70ed\u5907\u539f\u7406\uff0c\u4eceOracle DBA\u7684\u89d2\u5ea6\uff0c\u5176\u5b9e\u4e0d\u96be\u2026","rel":"","context":"\u5728\u201c\u53bbO\u201d\u4e2d","block_context":{"text":"\u53bbO","link":"http:\/\/www.rao-bing.cn\/index.php\/tag\/de-oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/lio_thumb.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/lio_thumb.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/lio_thumb.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/lio_thumb.png?resize=700%2C400 2x"},"classes":[]},{"id":348,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/19\/348\/","url_meta":{"origin":16206,"position":1},"title":"\u4f7f\u7528Zabbix\u76d1\u63a7Oracle\u6570\u636e\u5e93","author":"raobing","date":"2017-01-19","format":"aside","excerpt":"\u4f7f\u7528Zabbix\u76d1\u63a7Oracle\u6570\u636e\u5e93 Orabbix\u4ecb\u7ecd \u76d1\u63a7Oracle\u6570\u636e\u5e93\u6211\u4eec\u9700\u8981\u5b89\u88c5\u7b2c\u4e09\u65b9\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image001.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image001.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image001.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image001.png?resize=700%2C400 2x"},"classes":[]},{"id":182,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/07\/182\/","url_meta":{"origin":16206,"position":2},"title":"Database Replay\u548cConsolidated Database replay","author":"raobing","date":"2017-01-07","format":false,"excerpt":"\u7b80\u4ecb \u5728\u6570\u636e\u5e93\u7684\u8fc1\u79fb\u548c\u5347\u7ea7\u573a\u666f\u4e2d\uff0c\u6211\u4eec\u7ecf\u5e38\u4f1a\u9047\u5230\u4e00\u4e2a\u95ee\u9898\uff1a\u5728\u505a\u538b\u529b\u6d4b\u8bd5\u65f6\uff0c\u5982\u4f55\u6a21\u62df\u771f\u5b9e\u7684\u4e1a\u52a1\u538b\u529b\uff0c\u89e3\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=525%2C300 1.5x"},"classes":[]},{"id":16136,"url":"http:\/\/www.rao-bing.cn\/index.php\/2020\/06\/28\/16136\/","url_meta":{"origin":16206,"position":3},"title":"\u795e\u821f\u901a\u7528\u6570\u636e\u5e93\u8bfb\u5199\u5206\u79bb\uff08RW\uff09\u96c6\u7fa4","author":"raobing","date":"2020-06-28","format":"aside","excerpt":"\u795e\u821f\u901a\u7528\u6570\u636e\u5e93\u8bfb\u5199\u5206\u79bb\uff08RW\uff09\u96c6\u7fa4\u7684\u67b6\u6784\u56fe\u5982\u4e0b\u6240\u793a\uff0c \u548c\u795e\u901aDB\u7684HA\u67b6\u6784\u4e0d\u540c\uff0cRW\u96c6\u7fa4\u662fshare\u2026","rel":"","context":"\u5728\u201c\u53bbO\u201d\u4e2d","block_context":{"text":"\u53bbO","link":"http:\/\/www.rao-bing.cn\/index.php\/tag\/de-oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/image_thumb-2.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/image_thumb-2.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/image_thumb-2.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/image_thumb-2.png?resize=700%2C400 2x"},"classes":[]},{"id":136,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/07\/136\/","url_meta":{"origin":16206,"position":4},"title":"\u4f7f\u7528\u6280\u672f\u624b\u6bb5\u9650\u5236DBA\u7684\u5371\u9669\u64cd\u4f5c","author":"raobing","date":"2017-01-07","format":"aside","excerpt":"\u6982\u8ff0 \u4f17\u6240\u5468\u77e5\uff0c\u5728\u4e1a\u52a1\u9ad8\u5cf0\u671f\uff0c\u67d0\u4e9b\u9488\u5bf9Oracle\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u5177\u6709\u5f88\u9ad8\u7684\u98ce\u9669\uff0c\u6bd4\u5982\u4fee\u6539\u8868\u7ed3\u6784\u3001\u4fee\u6539\u5b9e\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1123_1.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":738,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/09\/04\/738\/","url_meta":{"origin":16206,"position":5},"title":"Ansible\u6279\u91cf\u4fee\u6539WebLogic JDBC \u6570\u636e\u6e90\u53e3\u4ee4","author":"raobing","date":"2017-09-04","format":"aside","excerpt":"\u6839\u636e\u5b89\u5168\u6700\u4f73\u5b9e\u8df5\uff0c\u6570\u636e\u5e93\u7528\u6237\u53e3\u4ee4\u9700\u8981\u5b9a\u671f\u66f4\u6539\uff0c\u5f53\u6570\u636e\u5e93\u7528\u6237\u53e3\u4ee4\u4fee\u6539\u540e\uff0c\u5bf9\u5e94\u7684weblogic\u4e2d\u7684\u6570\u636e\u2026","rel":"","context":"\u5728\u201cTools\u201d\u4e2d","block_context":{"text":"Tools","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/tools\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/16206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/comments?post=16206"}],"version-history":[{"count":2,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/16206\/revisions"}],"predecessor-version":[{"id":16210,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/16206\/revisions\/16210"}],"wp:attachment":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/media?parent=16206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/categories?post=16206"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/tags?post=16206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}