{"id":817,"date":"2020-04-15T10:39:37","date_gmt":"2020-04-15T10:39:37","guid":{"rendered":"http:\/\/www.liutianfeng.com\/?p=817"},"modified":"2020-04-16T09:43:02","modified_gmt":"2020-04-16T09:43:02","slug":"db-link-dblink-oracle%e6%9f%a5%e8%af%a2%e3%80%81%e5%88%9b%e5%bb%badb-link","status":"publish","type":"post","link":"https:\/\/www.liutianfeng.com\/?p=817","title":{"rendered":"db-link dblink &#8211; oracle\u67e5\u8be2\u3001\u521b\u5efadb-link"},"content":{"rendered":"<h4>1. \u67e5\u8be2\u5df2\u6709dblink<\/h4>\n<pre class=\"pure-highlightjs\"><code class=\"\">select owner,object_name from dba_objects where object_type='DATABASE LINK';\r\nselect * from dba_db_links;<\/code><\/pre>\n<h4>2. \u521b\u5efadblink<\/h4>\n<p>\u524d\u63d0: \u521b\u5efadblink\u7684\u7528\u6237\u6709\u5bf9\u5e94\u7684\u6570\u636e\u5e93\u6743\u9650\uff0ccreate public database link \u6216\u8005create database link<br \/>\n\u5982\u679c\u6ca1\u6709\u8fd9\u4e2a\u6743\u9650\uff0c\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u8bed\u53e5\u6388\u6743\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"\">grant create public database link,create database link to myAccount;<\/code><\/pre>\n<p>\u521b\u5efa:<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"\">create public database link link_name connect to db_user identified by user_passwd using '(DESCRIPTION=\r\n(ADDRESS_LIST=\r\n(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.100)(PORT=1521))\r\n)\r\n(CONNECT_DATA=(SERVICE_NAME=ora12c))\r\n)';<\/code><\/pre>\n<p>\u5982\u679c\u5728create\u4e4b\u540e\u4e0d\u52a0public,\u5219\u521b\u5efa\u7684dblink\u5c31\u4e0d\u662f\u516c\u5171\u7684,\u5c31\u53ea\u6709\u521b\u5efa\u8005\u53ef\u4ee5\u4f7f\u7528\u4e86.<\/p>\n<p>\u5982\u4f55\u786e\u5b9a\u6570\u636e\u5e93\u7684servicename\uff1f<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"\">show parameter[s] service_names;\r\n\u6216\r\nselect name,value from v$parameter where name='service_names';<\/code><\/pre>\n<h4>3. \u521b\u5efa\u548c\u4f7f\u7528dblink\u793a\u4f8b\uff1a<\/h4>\n<p>A\u7684servicename\u4e3aliusdb1\uff1bB\u7684servicename\u4e3aliusdb2.<br \/>\nB\u4e0a\u6709\u4e00\u4e2a\u53ef\u4ee5\u67e5\u8be2\u6240\u6709\u8868\u7684\u7528\u6237\uff1aliusx<br \/>\nA\u4e0a\u521b\u5efa\u4e00\u4e2adblink lius_link\uff0c\u7528liusx\u7528\u6237\u4f5c\u4e3a\u6865\u6881\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"\">create public database link lius_link connect to liusx identified by lius_password using '(DESCRIPTION=\r\n(ADDRESS_LIST=\r\n(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.111)(PORT=1521))\r\n)\r\n(CONNECT_DATA=(SERVICE_NAME=liusdb2))\r\n)';\r\n<\/code><\/pre>\n<p>\u4f7f\u7528\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"\">select * from v$parameter@lius_link;<\/code><\/pre>\n<h4>4.\u5220\u9664dblink<\/h4>\n<p>\u548c\u521b\u5efa\u76f8\u4f3c\uff0c\u7528\u6237\u6709createpublic database link \u6216\u8005create database link \u6743\u9650.<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"\">drop public database link dblinkname;<\/code><\/pre>\n<p>\u53c2\u8003\uff1ahttps:\/\/blog.csdn.net\/qq_30553235\/article\/details\/78688352<\/p>\n<p>\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a<a href=\"https:\/\/www.liutianfeng.com\">liutianfeng.com<\/a> &raquo; <a href=\"https:\/\/www.liutianfeng.com\/?p=817\">db-link dblink &#8211; oracle\u67e5\u8be2\u3001\u521b\u5efadb-link<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>1. \u67e5\u8be2\u5df2\u6709dblink select owner,object_name from dba_objects [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[45],"tags":[],"_links":{"self":[{"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=\/wp\/v2\/posts\/817"}],"collection":[{"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=817"}],"version-history":[{"count":4,"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=\/wp\/v2\/posts\/817\/revisions"}],"predecessor-version":[{"id":822,"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=\/wp\/v2\/posts\/817\/revisions\/822"}],"wp:attachment":[{"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.liutianfeng.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}