{"id":1349,"date":"2017-02-03T08:58:24","date_gmt":"2017-02-03T00:58:24","guid":{"rendered":"http:\/\/www.821121.com\/?p=1349"},"modified":"2021-01-08T09:23:02","modified_gmt":"2021-01-08T01:23:02","slug":"%e5%ad%a6%e4%b9%a0%e7%ac%94%e8%ae%b0%e4%b9%8bcdb-%e5%88%9b%e5%bb%ba%e9%9d%9e%e5%a4%9a%e7%a7%9f%e6%88%b7%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e5%89%af%e6%9c%ac%ef%bc%8c%e8%bd%ac%e5%8c%96%e4%b8%bapdb","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1349","title":{"rendered":"\u5b66\u4e60\u7b14\u8bb0\u4e4bCDB-\u521b\u5efa\u975e\u591a\u79df\u6237\u6570\u636e\u5e93\u7684\u526f\u672c\uff0c\u8f6c\u5316\u4e3aPDB\u6570\u636e\u5e93"},"content":{"rendered":"<h1>\u521b\u5efa\u975e\u591a\u79df\u6237\u6570\u636e\u5e93\u7684\u526f\u672c\uff0c\u8f6c\u5316\u4e3aPDB\u6570\u636e\u5e93<\/h1>\n<p><!--more--><\/p>\n<h4>\u73af\u5883\uff1a<\/h4>\n<p>catcdb\u4e3a\u5bb9\u5668\u6570\u636e\u5e93<br \/>\norcl\u4e3a\u975e\u591a\u79df\u6237\u6570\u636e\u5e93\uff0c\u6570\u636e\u5e93\u7248\u672c\u4e0e\u5bb9\u5668\u5e93\u4e00\u81f4<\/p>\n<h4>\u8981\u6c42\uff1a<\/h4>\n<p>\u5c06orcl\u8f6c\u4e3acatdb\u7684\u53ef\u63d2\u62d4\u6570\u636e\u5e93<\/p>\n<h4>\u6b65\u9aa4\uff1a<\/h4>\n<ol>\n<li>\n<p>\u5728catcdb\u6240\u5728\u670d\u52a1\u5668\u914d\u7f6e\u597d\u8fde\u63a5\u5230orcl\u7684\u8fde\u63a5\u4e32\u2018orcl\u2019<\/p>\n<pre><code class=\"language-sql\">orcl =\n(DESCRIPTION =\n(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))\n(CONNECT_DATA =\n  (SERVER = DEDICATED)\n  (SERVICE_NAME = orcl)\n)\n)<\/code><\/pre>\n<\/li>\n<li>\n<p>\u767b\u9646catcdb\u521b\u5efa\u8fde\u63a5\u5230orcl\u7684dblink<\/p>\n<pre><code class=\"language-sql\">create plublic database link orcl connect to system identified by oracle using &#039;orcl&#039;;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u521b\u5efa\u53ef\u62d4\u63d2\u6570\u636e\u5e93catorcl<\/p>\n<pre><code class=\"language-sql\">create pluggable database catorcl from non$cdb@orcl;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u8fd0\u884c\u8f6c\u5316\u811a\u672c<\/p>\n<pre><code class=\"language-sql\">alter session set container=catorcl;\n@?\/rdbms\/admin\/noncdb_to_pdb.sql;     #\u6bd4\u8f83\u6162\uff0c\u8010\u5fc3\u7b49\u5f85\nalter pluggable database pdbprod5 open;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u5220\u9664catorcl\u4e2d\u7684\u670d\u52a1\u4fe1\u606f<\/p>\n<pre><code class=\"language-sql\">select * from dba_service;\nexec dbms_service.delete_service(&#039;ORCLXDB&#039;);\nexec dbms_service.delete_service(&#039;ORCL&#039;);<\/code><\/pre>\n<\/li>\n<li>\n<p>\u91cd\u542fcatorcl<\/p>\n<pre><code class=\"language-sql\">alter pluggable database catorcl close;\nalter pluggable database catorcl open;<\/code><\/pre>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u521b\u5efa\u975e\u591a\u79df\u6237\u6570\u636e\u5e93\u7684\u526f\u672c\uff0c\u8f6c\u5316\u4e3aPDB\u6570\u636e\u5e93<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,38],"tags":[],"class_list":["post-1349","post","type-post","status-publish","format-standard","hentry","category-oracle-12c","category--oracle-12c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1349"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1349\/revisions"}],"predecessor-version":[{"id":1351,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1349\/revisions\/1351"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1349"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}