{"id":294,"date":"2019-03-02T10:14:18","date_gmt":"2019-03-02T02:14:18","guid":{"rendered":"http:\/\/www.821121.com\/?p=294"},"modified":"2020-12-25T10:52:57","modified_gmt":"2020-12-25T02:52:57","slug":"%e6%96%b0%e7%89%b9%e6%80%a7%ef%bc%9acdb-pdb%e7%9a%84%e7%bb%b4%e6%8a%a4%e5%91%bd%e4%bb%a4%ef%bc%9acdb%e3%80%81pdb%e7%9a%84%e7%94%a8%e6%88%b7%e7%ae%a1%e7%90%86%ef%bc%884%ef%bc%89cdb%e7%9a%84%e7%94%a8","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=294","title":{"rendered":"\u65b0\u7279\u6027\uff1aCDB\/PDB\u7684\u7ef4\u62a4\u547d\u4ee4\uff1aCDB\u3001PDB\u7684\u7528\u6237\u7ba1\u7406\uff084\uff09CDB\u7684\u7528\u6237\uff08c##\u5f00\u5934\u7684\uff09\uff0c\u5728CDB\u80fd\u67e5\u770bPDB\u7684\u6570\u636e"},"content":{"rendered":"<p>CDB\u7684\u7528\u6237\uff08c##\u5f00\u5934\u7684\uff09\uff0c\u9664\u4e86sys\u7528\u6237\uff0c\u9ed8\u8ba4\u60c5\u51b5\u5728CDB\u4e0d\u80fd\u67e5\u770bPDB\u7684\u6570\u636e\uff0c\u4f8b\u5982v_$session\u7684\u6570\u636e\uff0c\u9700\u8981\u901a\u8fc7alter user c##viewpdb set container_data\u8fdb\u884c\u8d4b\u6743\u3002<\/p>\n<h2>1\u3001\u521b\u5efa\u4e00\u4e2aCDB\u7684\u7528\u6237\u5e76\u8d4b\u6743<\/h2>\n<pre><code class=\"language-sql\">SQL&gt;  conn \/ as sysdba\nConnected.\nSQL&gt; select con_id,count(*) from sys.v_$session group by con_id;\n\n    CON_ID   COUNT(*)\n---------- ----------\n         1          5\n         5          1\n         3          1\n         0         89\n\nSQL&gt; create user c##viewpdb1 identified by test ;\n\nUser created.\n\nSQL&gt; grant create session, set container to c##viewpdb1 container=all;\n\nGrant succeeded.\n\nSQL&gt; grant select on v_$session to c##viewpdb1 container=all;\n\nGrant succeeded.<\/code><\/pre>\n<h2>2\u3001\u9a8c\u8bc1<\/h2>\n<p>\u9ed8\u8ba4\u60c5\u51b5\u4e0bc##viewpdb1\u53ea\u80fd\u67e5\u770bcon_id in (0,1)<\/p>\n<pre><code class=\"language-sql\">SQL&gt; conn c##viewpdb1\/test\nConnected.\nSQL&gt; select con_id,count(*) from sys.v_$session group by con_id;\n\n    CON_ID   COUNT(*)\n---------- ----------\n         1          5\n         0         89<\/code><\/pre>\n<h2>3\u3001\u8d4b\u6743<\/h2>\n<pre><code class=\"language-sql\">SQL&gt; conn \/ as sysdba\nConnected.\nSQL&gt; alter user c##viewpdb1 set container_data =(CDB$ROOT,PDB1_WHS,PDB3_WHS\uff09for v_$session container=current;\n\nUser altered.<\/code><\/pre>\n<h2>4\u3001\u9a8c\u8bc1\u80fd\u5426\u67e5\u770b<\/h2>\n<pre><code class=\"language-sql\">SQL&gt; conn c##viewpdb1\/test\nConnected.\nSQL&gt; select con_id,count(*) from sys.v_$session group by con_id;\n\n    CON_ID   COUNT(*)\n---------- ----------\n         1          5\n         5          1\n         3          1\n         0         89\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>CDB\u7684\u7528\u6237\uff08c##\u5f00\u5934\u7684\uff09\uff0c\u9664\u4e86sys\u7528\u6237\uff0c\u9ed8\u8ba4<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-294","post","type-post","status-publish","format-standard","hentry","category-oracle-12c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/294","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=294"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions"}],"predecessor-version":[{"id":295,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions\/295"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}