{"id":1117,"date":"2018-01-03T10:19:16","date_gmt":"2018-01-03T02:19:16","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1117"},"modified":"2018-01-03T10:19:34","modified_gmt":"2018-01-03T02:19:34","slug":"%e5%bb%ba%e7%ab%8bdblink%e7%9b%b8%e5%85%b3%e5%91%bd%e4%bb%a4","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1117","title":{"rendered":"Oracle\u5efa\u7acbDBLink\u76f8\u5173\u547d\u4ee4"},"content":{"rendered":"<p>\n\t\u5355\u8282\u70b9\uff1a\n<\/p>\n<p>\n\t\/*drop public database link xx_link;*\/\n<\/p>\n<p>\n\tcreate public database link xx_link<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;connect to xx_user&nbsp;identified by xx_user&nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;using &#39; (DESCRIPTION =<br \/>\n\t&nbsp; &nbsp; (ADDRESS_LIST =<br \/>\n\t&nbsp; &nbsp; &nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.2)(PORT = 1521))<br \/>\n\t&nbsp; &nbsp; )<br \/>\n\t&nbsp; &nbsp; (CONNECT_DATA =<br \/>\n\t&nbsp; &nbsp; &nbsp; (SERVER = DEDICATED)<br \/>\n\t&nbsp; &nbsp; &nbsp; (SERVICE_NAME = XXXX)<br \/>\n\t&nbsp; &nbsp; )<br \/>\n\t&nbsp; )&#39;;\n<\/p>\n<p>\n\t\u53cc\u8282\u70b9\uff1a\n<\/p>\n<p>\n\t\/*drop public database link xx_link;*\/\n<\/p>\n<p>\n\tcreate public database link xx_link<br \/>\n\tconnect to xx_user identified by xx_user&nbsp;<br \/>\n\tusing &#39;(DESCRIPTION =<br \/>\n\t(ADDRESS = (PROTOCOL = TCP) (HOST = 10.0.1.92)(PORT = 1521))<br \/>\n\t(ADDRESS = (PROTOCOL = TCP) (HOST = 10.0.1.93)(PORT = 1521))<br \/>\n\t(LOAD_BALANCE = yes)<br \/>\n\t(CONNECT_DATA =<br \/>\n\t(SERVER = DEDICATED)<br \/>\n\t(SERVICE_NAME =PROD)<br \/>\n\t)<br \/>\n\t)&#39;;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5355\u8282\u70b9\uff1a \/*drop public database link xx_link;*\/ create publ &hellip; <a href=\"https:\/\/www.llku.com\/?p=1117\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">Oracle\u5efa\u7acbDBLink\u76f8\u5173\u547d\u4ee4<\/span> <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":[],"categories":[53,31],"tags":[167],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1117"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1117"}],"version-history":[{"count":2,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1117\/revisions"}],"predecessor-version":[{"id":1119,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1117\/revisions\/1119"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}