{"id":1043,"date":"2017-04-02T16:45:49","date_gmt":"2017-04-02T08:45:49","guid":{"rendered":"http:\/\/www.821121.com\/?p=1043"},"modified":"2020-12-11T16:52:36","modified_gmt":"2020-12-11T08:52:36","slug":"oracle11g%e9%9b%86%e7%be%a4%e6%96%b0%e5%a2%9e%e8%8a%82%e7%82%b9%ef%bc%88%e4%ba%8c%ef%bc%89","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1043","title":{"rendered":"Oracle11g\u96c6\u7fa4\u65b0\u589e\u8282\u70b9\uff08\u4e8c\uff09"},"content":{"rendered":"<h1>2\u3001\u6dfb\u52a0GRID\u8f6f\u4ef6<\/h1>\n<h2>2.1\u3001\u5907\u4efdOCR<\/h2>\n<pre><code class=\"language-sql\">ocrconfig -manualbackup\nocrconfig -showbackup manual<\/code><\/pre>\n<h2>2.2\u3001\u5728\u8282\u70b9 1 \u4ee5 grid \u7528\u6237\u6267\u884c addNode.sh \u547d\u4ee4\u6dfb\u52a0 GI \u8f6f\u4ef6<\/h2>\n<pre><code class=\"language-sql\">\u5728 addNode.sh \u6b63\u5f0f\u6dfb\u52a0\u8282\u70b9\u4e4b\u524d\u5b83\u4e5f\u4f1a\u8c03\u7528 cluvfy \u5de5\u5177\u6765\u9a8c\u8bc1\u65b0\u52a0\u5165\u8282\u70b9\u662f\u5426\u6ee1\u8db3\u6761\u4ef6\uff0c\u5982\u679c\u4e0d\u6ee1\u8db3\n\u5219\u62d2\u7edd\u4e0b\u4e00\u6b65\u64cd\u4f5c\u3002\n\u56e0\u4e3aaddNode.sh\u811a\u672c\u4f1a\u4f7f\u7528cluvfy\u5de5\u5177\u6765\u9a8c\u8bc1\u65b0\u52a0\u5165\u8282\u70b9\u662f\u5426\u6ee1\u8db3\u6761\u4ef6\uff0c\u800c\u6211\u4eecDNS\u6ca1\u6709\u914d\u7f6e\u6216swap\n\u4e0d\u6ee1\u8db3\u6761\u4ef6\uff0c\u6240\u4ee5\u76f4\u63a5\u8fd0\u884c\uff0c\u80af\u5b9a\u4f1a\u62a5\u9519\u3002\u56e0\u6b64\uff0c\u5728\u8fd0\u884c addNode.sh \u4e4b\u524d\u9700\u8981\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf\uff0c\u8df3\u8fc7\u5bf9\u8282\u70b9\u65b0\n\u589e\u7684\u9884\u68c0\u67e5\u3002\u8fd9\u4e2a\u53c2\u6570\u5c31\u662f\u4ece addNode.sh \u811a\u672c\u91cc\u627e\u51fa\u6765\u7684\uff1a\nexport IGNORE_PREADDNODE_CHECKS=Y\n\n\u4ee5 grid \u7528\u6237\u5728\u8282\u70b9 1 \u4e0a\u6267\u884c\uff0c\u6dfb\u52a0\u8282\u70b9\u7684\u547d\u4ee4\u5982\u4e0b\u6240\u793a\uff1a\ncd $ORACLE_HOME\/oui\/bin\nexport IGNORE_PREADDNODE_CHECKS=Y\n.\/addNode.sh &quot;CLUSTER_NEW_NODES={rac3}&quot; &quot;CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac3vip}&quot; &quot;CLUSTER_NEW_PRIVATE_NODE_NAMES={rac3priv}&quot;\n<\/code><\/pre>\n<pre><code class=\"language-sql\">\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[grid@rac1 bin]$ export IGNORE_PREADDNODE_CHECKS=Y\n[grid@rac1 bin]$ .\/addNode.sh &quot;CLUSTER_NEW_NODES={rac3}&quot; &quot;CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac3vip}&quot; &quot;CLUSTER_NEW_PRIVATE_NODE_NAMES={rac3priv}&quot;\nStarting Oracle Universal Installer...\n\nChecking swap space: must be greater than 500 MB.   Actual 4512 MB    Passed\nOracle Universal Installer, Version 11.2.0.4.0 Production\nCopyright (C) 1999, 2013, Oracle. All rights reserved.\n\nPerforming tests to see whether nodes rac2,rac3 are available\n............................................................... 100% Done.\n\n.\n-----------------------------------------------------------------------------\nCluster Node Addition Summary\nGlobal Settings\n   Source: \/u01\/grid\/11.2.0.4\n   New Nodes\nSpace Requirements\n   New Nodes\n      rac3\n         \/: Required 4.85GB : Available 35.43GB\nInstalled Products\n   Product Names\n      Oracle Grid Infrastructure 11g 11.2.0.4.0 \n      Java Development Kit 1.5.0.51.10 \n      Installer SDK Component 11.2.0.4.0 \n      Oracle One-Off Patch Installer 11.2.0.3.4 \n      Oracle Universal Installer 11.2.0.4.0 \n      Oracle RAC Required Support Files-HAS 11.2.0.4.0 \n      Oracle USM Deconfiguration 11.2.0.4.0 \n      Oracle Configuration Manager Deconfiguration 10.3.1.0.0 \n      Enterprise Manager Common Core Files 10.2.0.4.5 \n      Oracle DBCA Deconfiguration 11.2.0.4.0 \n      Oracle RAC Deconfiguration 11.2.0.4.0 \n      Oracle Quality of Service Management (Server) 11.2.0.4.0 \n      Installation Plugin Files 11.2.0.4.0 \n      Universal Storage Manager Files 11.2.0.4.0 \n      Oracle Text Required Support Files 11.2.0.4.0 \n      Automatic Storage Management Assistant 11.2.0.4.0 \n      Oracle Database 11g Multimedia Files 11.2.0.4.0 \n      Oracle Multimedia Java Advanced Imaging 11.2.0.4.0 \n      Oracle Globalization Support 11.2.0.4.0 \n      Oracle Multimedia Locator RDBMS Files 11.2.0.4.0 \n      Oracle Core Required Support Files 11.2.0.4.0 \n      Bali Share 1.1.18.0.0 \n      Oracle Database Deconfiguration 11.2.0.4.0 \n      Oracle Quality of Service Management (Client) 11.2.0.4.0 \n      Expat libraries 2.0.1.0.1 \n      Oracle Containers for Java 11.2.0.4.0 \n      Perl Modules 5.10.0.0.1 \n      Secure Socket Layer 11.2.0.4.0 \n      Oracle JDBC\/OCI Instant Client 11.2.0.4.0 \n      Oracle Multimedia Client Option 11.2.0.4.0 \n      LDAP Required Support Files 11.2.0.4.0 \n      Character Set Migration Utility 11.2.0.4.0 \n      Perl Interpreter 5.10.0.0.2 \n      PL\/SQL Embedded Gateway 11.2.0.4.0 \n      OLAP SQL Scripts 11.2.0.4.0 \n      Database SQL Scripts 11.2.0.4.0 \n      Oracle Extended Windowing Toolkit 3.4.47.0.0 \n      SSL Required Support Files for InstantClient 11.2.0.4.0 \n      SQL*Plus Files for Instant Client 11.2.0.4.0 \n      Oracle Net Required Support Files 11.2.0.4.0 \n      Oracle Database User Interface 2.2.13.0.0 \n      RDBMS Required Support Files for Instant Client 11.2.0.4.0 \n      RDBMS Required Support Files Runtime 11.2.0.4.0 \n      XML Parser for Java 11.2.0.4.0 \n      Oracle Security Developer Tools 11.2.0.4.0 \n      Oracle Wallet Manager 11.2.0.4.0 \n      Enterprise Manager plugin Common Files 11.2.0.4.0 \n      Platform Required Support Files 11.2.0.4.0 \n      Oracle JFC Extended Windowing Toolkit 4.2.36.0.0 \n      RDBMS Required Support Files 11.2.0.4.0 \n      Oracle Ice Browser 5.2.3.6.0 \n      Oracle Help For Java 4.2.9.0.0 \n      Enterprise Manager Common Files 10.2.0.4.5 \n      Deinstallation Tool 11.2.0.4.0 \n      Oracle Java Client 11.2.0.4.0 \n      Cluster Verification Utility Files 11.2.0.4.0 \n      Oracle Notification Service (eONS) 11.2.0.4.0 \n      Oracle LDAP administration 11.2.0.4.0 \n      Cluster Verification Utility Common Files 11.2.0.4.0 \n      Oracle Clusterware RDBMS Files 11.2.0.4.0 \n      Oracle Locale Builder 11.2.0.4.0 \n      Oracle Globalization Support 11.2.0.4.0 \n      Buildtools Common Files 11.2.0.4.0 \n      HAS Common Files 11.2.0.4.0 \n      SQL*Plus Required Support Files 11.2.0.4.0 \n      XDK Required Support Files 11.2.0.4.0 \n      Agent Required Support Files 10.2.0.4.5 \n      Parser Generator Required Support Files 11.2.0.4.0 \n      Precompiler Required Support Files 11.2.0.4.0 \n      Installation Common Files 11.2.0.4.0 \n      Required Support Files 11.2.0.4.0 \n      Oracle JDBC\/THIN Interfaces 11.2.0.4.0 \n      Oracle Multimedia Locator 11.2.0.4.0 \n      Oracle Multimedia 11.2.0.4.0 \n      Assistant Common Files 11.2.0.4.0 \n      Oracle Net 11.2.0.4.0 \n      PL\/SQL 11.2.0.4.0 \n      HAS Files for DB 11.2.0.4.0 \n      Oracle Recovery Manager 11.2.0.4.0 \n      Oracle Database Utilities 11.2.0.4.0 \n      Oracle Notification Service 11.2.0.3.0 \n      SQL*Plus 11.2.0.4.0 \n      Oracle Netca Client 11.2.0.4.0 \n      Oracle Advanced Security 11.2.0.4.0 \n      Oracle JVM 11.2.0.4.0 \n      Oracle Internet Directory Client 11.2.0.4.0 \n      Oracle Net Listener 11.2.0.4.0 \n      Cluster Ready Services Files 11.2.0.4.0 \n      Oracle Database 11g 11.2.0.4.0 \n-----------------------------------------------------------------------------\n\nInstantiating scripts for add node (Friday, December 11, 2020 3:18:03 PM CST)\n.                                                                 1% Done.\nInstantiation of add node scripts complete\n\nCopying to remote nodes (Friday, December 11, 2020 3:18:07 PM CST)\n...............................................................................................                                 96% Done.\nHome copied to new nodes\n\nSaving inventory on nodes (Friday, December 11, 2020 3:23:49 PM CST)\n.                                                               100% Done.\nSave inventory complete\nWARNING:A new inventory has been created on one or more nodes in this session. However, it has not yet been registered as the central inventory of this system. \nTo register the new inventory please run the script at &#039;\/u01\/app\/oraInventory\/orainstRoot.sh&#039; with root privileges on nodes &#039;rac3&#039;.\nIf you do not register the inventory, you may not be able to update or patch the products you installed.\nThe following configuration scripts need to be executed as the &quot;root&quot; user in each new cluster node. Each script in the list below is followed by a list of nodes.\n\/u01\/app\/oraInventory\/orainstRoot.sh #On nodes rac3\n\/u01\/grid\/11.2.0.4\/root.sh #On nodes rac3\nTo execute the configuration scripts:\n    1. Open a terminal window\n    2. Log in as &quot;root&quot;\n    3. Run the scripts in each cluster node\n\nThe Cluster Node Addition of \/u01\/grid\/11.2.0.4 was successful.\nPlease check &#039;\/tmp\/silentInstall.log&#039; for more details.\n\n\u6ce8\u610f\uff1a\n\u5982\u679c\u6709\u591a\u4e2a\u8282\u70b9\u9700\u8981\u6dfb\u52a0\uff0c\u7528\u4ee5\u4e0b\u683c\u5f0f\uff1a\n&quot;CLUSTER_NEW_NODES={node3,node4,node5}&quot;\n&quot;CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3-vip,node4-vip,node5-vip}&quot;\n&quot;CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3-priv,node4-priv,node5-priv}&quot;\n<\/code><\/pre>\n<pre><code class=\"language-sql\">\u5728 addNode.sh \u811a\u672c\u6267\u884c\u5b8c\u6210\u540e\u6839\u636e\u811a\u672c\u63d0\u793a\u4ee5 root \u7528\u6237\u5728\u65b0\u6dfb\u52a0\u7684\u8282\u70b9\u4e0a\u6267\u884c\u4ee5\u4e0b\u811a\u672c\uff1a\n\/u01\/app\/oraInventory\/orainstRoot.sh\n\/u01\/grid\/11.2.0.4\/root.sh\n\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[root@rac3 grid]# \/u01\/app\/oraInventory\/orainstRoot.sh\nCreating the Oracle inventory pointer file (\/etc\/oraInst.loc)\nChanging permissions of \/u01\/app\/oraInventory.\nAdding read,write permissions for group.\nRemoving read,write,execute permissions for world.\n\nChanging groupname of \/u01\/app\/oraInventory to oinstall.\nThe execution of the script is complete.\n[root@rac3 grid]# \/u01\/grid\/11.2.0.4\/root.sh\nPerforming root user operation for Oracle 11g \n\nThe following environment variables are set as:\n    ORACLE_OWNER= grid\n    ORACLE_HOME=  \/u01\/grid\/11.2.0.4\n\nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]: \n   Copying dbhome to \/usr\/local\/bin ...\n   Copying oraenv to \/usr\/local\/bin ...\n   Copying coraenv to \/usr\/local\/bin ...\n\nCreating \/etc\/oratab file...\nEntries will be added to the \/etc\/oratab file as needed by\nDatabase Configuration Assistant when a database is created\nFinished running generic part of root script.\nNow product-specific root actions will be performed.\nUsing configuration parameter file: \/u01\/grid\/11.2.0.4\/crs\/install\/crsconfig_params\nCreating trace directory\nUser ignored Prerequisites during installation\nInstalling Trace File Analyzer\nOLR initialization - successful\nAdding Clusterware entries to upstart\nCRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rac1, number 1, and is terminating\nAn active cluster was found during exclusive startup, restarting to join the cluster\nclscfg: EXISTING configuration version 5 detected.\nclscfg: version 5 is 11g Release 2.\nSuccessfully accumulated necessary OCR keys.\nCreating OCR keys for user &#039;root&#039;, privgrp &#039;root&#039;..\nOperation successful.\nConfigure Oracle Grid Infrastructure for a Cluster ... succeeded\n\n\u6267\u884c\u5b8c\u6210\u540e\u6821\u9a8c\uff1a\ncrsctl stat res -t\n\u68c0\u67e5\uff1a\ncat \/u01\/app\/oraInventory\/ContentsXML\/inventory.xm\n\n\u5982\u679c\u6dfb\u52a0\u8282\u70b9\u5931\u8d25\uff0c\u90a3\u4e48\u9700\u8981\u4ee5 grid \u7528\u6237\u6267\u884c\u5982\u4e0b\u7684\u811a\u672c\u6e05\u7406\u540e\u518d\u6b21\u6267\u884c\u6dfb\u52a0\u8282\u70b9\u7684\u811a\u672c\uff1a\n$ORACLE_HOME\/crs\/utl\/rootdeletenode.sh rac3<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>2\u3001\u6dfb\u52a0GRID\u8f6f\u4ef6 2.1\u3001\u5907\u4efdOCR ocrc<\/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,40],"tags":[],"class_list":["post-1043","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\/1043","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=1043"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1043\/revisions"}],"predecessor-version":[{"id":1044,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1043\/revisions\/1044"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1043"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1043"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}