{"id":701,"date":"2017-09-10T10:54:37","date_gmt":"2017-09-10T02:54:37","guid":{"rendered":"http:\/\/www.821121.com\/?p=701"},"modified":"2020-12-11T10:01:21","modified_gmt":"2020-12-11T02:01:21","slug":"oracle11grac%e9%83%a8%e7%bd%b2%e4%b8%89","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=701","title":{"rendered":"Oracle11gRAC\u90e8\u7f72(\u4e09)"},"content":{"rendered":"<h1>8\u3001\u5b89\u88c511.2.0.4\u6570\u636e\u5e93\u8f6f\u4ef6<\/h1>\n<pre><code class=\"language-sql\">\u5728\u8282\u70b91\u4e2dROOT\u7528\u6237\u8fd0\u884c\u8fd9\u4e2a\u811a\u672c\n[root@whepi1 ~]# su - oracle\n[oracle@whepi1 ~]$ cd \/soft\n[oracle@whepi1 soft]$ unzip p13390677_112040_Linux-x86-64_1of7.zip\n[oracle@whepi1 soft]$ unzip p13390677_112040_Linux-x86-64_2of7.zip\n[oracle@whepi1 soft]$ chown -R oracle:oinstall database\n[oracle@whepi1 soft]$ chmod -R 775 database\n\n\u9996\u5148\u4ee5 grid \u7528\u6237\u8fd0\u884c\u5982\u4e0b\u7684\u547d\u4ee4\u8fdb\u884c\u68c0\u67e5\u73af\u5883\u914d\u7f6e\uff1a\n\/u01\/grid\/runcluvfy.sh stage -pre dbinst -n rac1,rac2 -verbose -fixup<\/code><\/pre>\n<p>VNC\u7528oracle\u7528\u6237\u5b89\u88c5\uff0c\u53ef\u89c6\u5316\u5b89\u88c5<br \/>\n\u56fe\u5982\u4e0b\u6240\u793a\uff1a<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607049946780.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607049953833.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607049963815.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607049970013.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607049976319.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607049983352.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050003424.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050013918.png\" alt=\"file\" \/><br \/>\n\u4ee5\u4e0b\u56fe\u4e2d\u5ffd\u7565\u5982\u4e0b\u62a5\u9519<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050035744.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050040621.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050046697.png\" alt=\"file\" \/><\/p>\n<p>\u4ee5\u4e0a\u811a\u672c2\u4e2a\u8282\u70b9\u90fd\u8981\u7528root\u7528\u6237\u6267\u884c\u3002<\/p>\n<h1>9\u3001\u7ed911.2.0.4\u6570\u636e\u5e93\u6253PSU\u8865\u4e01<\/h1>\n<pre><code class=\"language-sql\">2\u4e2a\u8282\u70b9\u90fd\u8981\uff1a\n\u5347\u7ea7OPatch\n[root@whepi1 soft]# su - oracle\n[oracle@whepi1 ~]$ cd \/soft\/\n[oracle@whepi1 soft]$ unzip database_psu_p26609445_112040_Linux-x86-64.zip\n[oracle@whepi1 ~]$ cd $ORACLE_HOME\n[oracle@whepi1 db_1]$ mv \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/OPatch\/ \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/OPatch_bk20180430\/\n[oracle@whepi1 db_1]$ exit\nlogout\n[root@whepi1 soft]# cp -R \/soft\/OPatch\/ \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/\n[root@whepi1 soft]# chown -R oracle:oinstall \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/OPatch\n[root@whepi1 soft]# su - oracle\n[oracle@whepi1 ~]$ cd $ORACLE_HOME\/OPatch\n[oracle@whepi1 OPatch]$ .\/opatch apply \/soft\/26609445\/\n\u68c0\u67e5\n.\/opatch lsinventory<\/code><\/pre>\n<h1>10\u3001dbca\u5b9e\u4f8b<\/h1>\n<pre><code class=\"language-sql\">\u6253\u5f00\u76d1\u542c\nlsnrctl start\ndbca<\/code><\/pre>\n<p>\u56fe\u5982\u4e0b\u6240\u793a\uff1a<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050165408.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050171064.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050181084.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050186458.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050195545.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050200516.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050209137.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050239598.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050248226.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050253080.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050265155.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050270354.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050296522.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050302770.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050310751.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050323481.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050333182.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607050348158.png\" alt=\"file\" \/><\/p>\n<p>11.\u5efa\u8bae\u6570\u636e\u5e93<br \/>\nsqlplus \/ as sysdba]<br \/>\nselect * from dual<br \/>\n\u6570\u636e\u5b89\u88c5\u6210\u529f\uff0c\u5b9e\u4f8b\u5b89\u88c5\u6210\u529f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>8\u3001\u5b89\u88c511.2.0.4\u6570\u636e\u5e93\u8f6f\u4ef6 \u5728\u8282\u70b91\u4e2dRO<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,37],"tags":[],"class_list":["post-701","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/701","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=701"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/701\/revisions"}],"predecessor-version":[{"id":731,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/701\/revisions\/731"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=701"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}