{"id":385,"date":"2020-02-01T16:13:28","date_gmt":"2020-02-01T08:13:28","guid":{"rendered":"http:\/\/www.821121.com\/?p=385"},"modified":"2020-12-11T10:19:56","modified_gmt":"2020-12-11T02:19:56","slug":"%e9%80%9a%e8%bf%87dblink%e8%b7%a8cdb%e5%a4%8d%e5%88%b6pdb","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=385","title":{"rendered":"\u901a\u8fc7dblink\u8de8CDB\u590d\u5236PDB"},"content":{"rendered":"

1\u3001\u5728tnsnames.ora\u4e2d\u6dfb\u52a0\u8fde\u63a5PDB2_WHS\uff0c\u8fc7\u7a0b\u7565\u3002<\/h2>\n

2\u3001\u5728\u76ee\u6807CDB\u521b\u5efadblink<\/h2>\n
[oracle@cat1 ~]$ export ORACLE_SID=whss1\n[oracle@cat1 ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 1 15:18:12 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\nSQL> startup\nORACLE instance started.\n\nTotal System Global Area 2650796208 bytes\nFixed Size                  9138352 bytes\nVariable Size             620756992 bytes\nDatabase Buffers         2013265920 bytes\nRedo Buffers                7634944 bytes\nDatabase mounted.\nDatabase opened.\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\nSQL> create database link cppdb connect to system identified by oracle using 'PDB2_WHS';\n\nDatabase link created.\n\nSQL>  SELECT * FROM DUAL@cppdb;\n\nDUM\n---\nX<\/code><\/pre>\n
3\u3001\u5728\u76ee\u6807\u5e93\u590d\u5236PDB<\/h2>\n
SQL> CREATE PLUGGABLE DATABASE PDB2_WHS FROM PDB2_WHS@cppdb ;\nCREATE PLUGGABLE DATABASE PDB2_WHS FROM PDB2_WHS@cppdb\n*\nERROR at line 1:\nORA-17628: Oracle error 1031 returned by remote Oracle server\nORA-01031: insufficient privileges\n\n\u4ee5\u4e0a\u521b\u5efa\u6570\u636e\u5e93\u5931\u8d25\uff0c\u4e3asystem\u7528\u6237\u6ca1\u6709\u6743\u9650\uff0c\u9700\u8981\u5230\u6e90pdb\u6570\u636e\u5e93\u4e0a\u8d4b\u6743\uff1a\n[oracle@cat1 admin]$ export ORACLE_SID=whs11\n[oracle@cat1 admin]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 1 15:52:52 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1_WHS                       MOUNTED\n         4 PDB2_WHS                       READ WRITE NO\n         5 PDB3_WHS                       MOUNTED\nSQL> alter session set container=PDB2_WHS;\n\nSQL> grant create pluggable database to system;\n\nGrant succeeded.\n\nSQL> <\/code><\/pre>\n
\u518d\u6b21\u767b\u5f55\u76ee\u6807\u6570\u636e\u5e93\uff0c\u521b\u5efapdb<\/p>\n
SQL> CREATE PLUGGABLE DATABASE PDB2_WHS FROM PDB2_WHS@cppdb ;\n\nPluggable database created.\n\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         4 PDB2_WHS                       MOUNTED\nSQL> alter session set container=PDB2_WHS;\n\nSession altered.\n\nSQL> startup\nPluggable Database opened.\nSQL> select file_name from dba_data_files;\n\nFILE_NAME\n--------------------------------------------------------------------------------\n+DATA2\/WHSS\/B5633DCD0104C05EE0532900A8C0652C\/DATAFILE\/system.278.1058025469\n+DATA2\/WHSS\/B5633DCD0104C05EE0532900A8C0652C\/DATAFILE\/sysaux.279.1058025469\n+DATA2\/WHSS\/B5633DCD0104C05EE0532900A8C0652C\/DATAFILE\/undotbs1.276.1058025469\n+DATA2\/WHSS\/B5633DCD0104C05EE0532900A8C0652C\/DATAFILE\/undo_2.277.1058025469\n+DATA2\/WHSS\/B5633DCD0104C05EE0532900A8C0652C\/DATAFILE\/user02.273.1058025469\n+DATA2\/WHSS\/B5633DCD0104C05EE0532900A8C0652C\/DATAFILE\/users.274.1058025469\n+DATA2\/WHSS\/B5633DCD0104C05EE0532900A8C0652C\/DATAFILE\/undotbs2.275.1058025469\n\n7 rows selected.<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
1\u3001\u5728tnsnames.ora\u4e2d\u6dfb\u52a0\u8fde\u63a5PDB2_<\/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-385","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\/385","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=385"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/385\/revisions"}],"predecessor-version":[{"id":386,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/385\/revisions\/386"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=385"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}