{"id":1428,"date":"2019-02-23T10:09:31","date_gmt":"2019-02-23T02:09:31","guid":{"rendered":"http:\/\/www.821121.com\/?p=1428"},"modified":"2021-03-02T10:51:50","modified_gmt":"2021-03-02T02:51:50","slug":"11grac%e9%9b%86%e7%be%a4%e9%9d%99%e9%bb%98%e5%ae%89%e8%a3%85%e5%ae%9e%e9%aa%8c","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1428","title":{"rendered":"11gRAC\u96c6\u7fa4\u9759\u9ed8\u5b89\u88c5\u5b9e\u9a8c"},"content":{"rendered":"<pre><code class=\"language-sql\">RAC\u96c6\u7fa4\u9759\u9ed8\u5b89\u88c5\uff1a\n\n\u524d\u9762\u73af\u5883\u53d8\u91cf\u7b49\u914d\u7f6e\u540c\u56fe\u5f62\u5b89\u88c5\u6587\u6863\u4e00\u6837\u3002\nGRID:\nBASE:\/u01\/app\/grid\nHOME:\/u01\/grid\/11.2.0.4\/\n\nORACLE:\nBASE:\/u01\/app\/oracle\nHOME:\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\n<\/code><\/pre>\n<h1>\u4e00\u3001grid<\/h1>\n<pre><code class=\"language-sql\">\u5b89\u88c5\u4e4b\u524d\u4f7f\u7528\u811a\u672c\u8fdb\u884c\u6821\u9a8c\uff0c\u786e\u4fdd\u6240\u6709\u7684 failed \u9009\u9879\u90fd\u53ef\u4ee5\u5ffd\u7565\u3002\n.\/runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbose\n\n\u5728 2 \u4e2a\u8282\u70b9\u4e0a\u65b0\u5efa\/etc\/oraInst.loc\uff0c\u6587\u4ef6\u4e2d\u7684\u5185\u5bb9\u5982\u4e0b\nvi \/etc\/oraInst.loc\ninventory_loc=\/u01\/app\/oraInventory\ninst_group=oinstall\n\n\u8f93\u5165\u4e0b\u9762\u7684\u547d\u4ee4\u5728 oraInst.loc \u6587\u4ef6\u4e0a\u8bbe\u7f6e\u5408\u9002\u7684\u62e5\u6709\u8005\uff0c\u7ec4\u548c\u6743\u9650\uff1a\nchown oracle:oinstall \/etc\/oraInst.loc\nchmod 664 \/etc\/oraInst.loc\n\n\/u01\/app\/oraInventory \u7684\u76ee\u5f55\u5fc5\u987b\u4e3a\u7a7a\nls -l \/u01\/app\/oraInventory\/*\nrm -rf \/u01\/app\/oraInventory\/*\n\nvi \/home\/grid\/grid_install.rsp\n\u9759\u9ed8\u811a\u672c\uff1a\noracle.install.responseFileVersion=\/oracle\/install\/rspfmt_crsinstall_response_schema_v11_2_0\nORACLE_HOSTNAME=rac1\nINVENTORY_LOCATION=\/u01\/app\/oraInventory\nSELECTED_LANGUAGES=en,zh_CN\noracle.install.option=CRS_CONFIG\nORACLE_BASE=\/u01\/app\/grid\nORACLE_HOME=\/u01\/grid\/11.2.0.4\noracle.install.asm.OSDBA=asmdba\noracle.install.asm.OSOPER=asmoper\noracle.install.asm.OSASM=asmadmin\noracle.install.crs.config.gpnp.scanName=racscanip\noracle.install.crs.config.gpnp.scanPort=1521\noracle.install.crs.config.clusterName=rac-cluster\noracle.install.crs.config.gpnp.configureGNS=false\noracle.install.crs.config.gpnp.gnsSubDomain=\noracle.install.crs.config.gpnp.gnsVIPAddress=\noracle.install.crs.config.autoConfigureClusterNodeVIP=false\noracle.install.crs.config.clusterNodes=rac1:rac1vip,rac2:rac2vip\noracle.install.crs.config.networkInterfaceList=eth0:192.168.0.0:1,eth1:192.168.178.0:2\noracle.install.crs.config.storageOption=ASM_STORAGE\noracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=\noracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=\noracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=EXTERNAL\noracle.install.crs.config.sharedFileSystemStorage.ocrLocations=\noracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=EXTERNAL\noracle.install.crs.config.useIPMI=false\noracle.install.crs.config.ipmi.bmcUsername=\noracle.install.crs.config.ipmi.bmcPassword=\noracle.install.asm.SYSASMPassword=oracle123\noracle.install.asm.diskGroup.name=OCR\noracle.install.asm.diskGroup.redundancy=EXTERNAL\noracle.install.asm.diskGroup.AUSize=1\noracle.install.asm.diskGroup.disks=\/dev\/mapper\/OCR\noracle.install.asm.diskGroup.diskDiscoveryString=\/dev\/mapper\/*\noracle.install.asm.monitorPassword=oracle123\noracle.install.crs.upgrade.clusterNodes=\noracle.installer.autoupdates.option=SKIP_UPDATES\noracle.installer.autoupdates.downloadUpdatesLoc=\nAUTOUPDATES_MYORACLESUPPORT_USERNAME=\nAUTOUPDATES_MYORACLESUPPORT_PASSWORD=\nPROXY_HOST=\nPROXY_PORT=0\nPROXY_USER=\nPROXY_PWD=\nPROXY_REALM=\n\n\u8bf7\u4f7f\u7528grid\u7528\u6237\u5728\u8282\u70b91\uff08rac1\uff09\u4e0a\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\n\nchmod 775 \/home\/grid\/grid_install.rsp\n\/u01\/grid\/runInstaller -ignorePrereq -silent -force -responseFile \/home\/grid\/grid_install.rsp -showProgress\n\n\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u6267\u884c\u811a\u672c\uff1a\n\n\/u01\/grid\/11.2.0.4\/root.sh     \/\/\u53cc\u8282\u70b9\u64cd\u4f5c\n\ncrsctl stat res -t   \/\/\u68c0\u67e5\n\n\/u01\/grid\/11.2.0.4\/cfgtoollogs\/configToolAllCommands RESPONSE_FILE=\/home\/grid\/grid_install.rsp\nSetting the invPtrLoc to \/u01\/grid\/11.2.0.4\/oraInst.loc     \/\/\u5355\u8282\u70b9\u6267\u884c\uff0c\u5373\u8dd1\u811a\u672c\u7684\u6267\u884c\n\ncrsctl stat res -t  \/\/\u68c0\u67e5\uff0c\u591a\u4e86\u76d1\u542c\u914d\u7f6e<\/code><\/pre>\n<h1>\u4e8c\u3001ORACLE<\/h1>\n<pre><code class=\"language-sql\">\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\n\nvi \/home\/oracle\/db_install.rsp\n\noracle.install.responseFileVersion=\/oracle\/install\/rspfmt_dbinstall_response_schema_v11_2_0\noracle.install.option=INSTALL_DB_SWONLY\nORACLE_HOSTNAME=rac1\nUNIX_GROUP_NAME=oinstall\nINVENTORY_LOCATION=\/u01\/app\/oraInventory\nSELECTED_LANGUAGES=en,zh_CN\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\nORACLE_BASE=\/u01\/app\/oracle\noracle.install.db.InstallEdition=EE\noracle.install.db.EEOptionsSelection=false\noracle.install.db.optionalComponents=\noracle.install.db.DBA_GROUP=dba\noracle.install.db.OPER_GROUP=oper\noracle.install.db.CLUSTER_NODES=rac1,rac2\noracle.install.db.isRACOneInstall=false\noracle.install.db.racOneServiceName=\noracle.install.db.config.starterdb.type=GENERAL_PURPOSE\noracle.install.db.config.starterdb.globalDBName=racdb\noracle.install.db.config.starterdb.SID=racdb1\noracle.install.db.config.starterdb.characterSet=AL32UTF8\noracle.install.db.config.starterdb.memoryOption=false\noracle.install.db.config.starterdb.memoryLimit=\noracle.install.db.config.starterdb.installExampleSchemas=false\noracle.install.db.config.starterdb.enableSecuritySettings=false\noracle.install.db.config.starterdb.password.ALL=oracle123\noracle.install.db.config.starterdb.password.SYS=\noracle.install.db.config.starterdb.password.SYSTEM=\noracle.install.db.config.starterdb.password.SYSMAN=\noracle.install.db.config.starterdb.password.DBSNMP=\noracle.install.db.config.starterdb.control=DB_CONTROL\noracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=\noracle.install.db.config.starterdb.automatedBackup.enable=false\noracle.install.db.config.starterdb.automatedBackup.osuid=\noracle.install.db.config.starterdb.automatedBackup.ospwd=\noracle.install.db.config.starterdb.storageType=\noracle.install.db.config.starterdb.fileSystemStorage.dataLocation=\noracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=\noracle.install.db.config.asm.diskGroup=\noracle.install.db.config.asm.ASMSNMPPassword=oracle123\nMYORACLESUPPORT_USERNAME=\nMYORACLESUPPORT_PASSWORD=\nSECURITY_UPDATES_VIA_MYORACLESUPPORT=false\nDECLINE_SECURITY_UPDATES=true\nPROXY_PORT=\nPROXY_USER=\nPROXY_PWD=\nPROXY_REALM=\nCOLLECTOR_SUPPORTHUB_URL=\noracle.installer.autoupdates.option=SKIP_UPDATES\nAUTOUPDATES_MYORACLESUPPORT_USERNAME=\nAUTOUPDATES_MYORACLESUPPORT_PASSWORD=\n\nchmod 775 \/home\/oracle\/db_install.rsp\n\/u01\/database\/runInstaller -ignorePrereq -silent -force -noconfig -responseFile \/home\/oracle\/db_install.rsp  -showProgress\n\n\u6240\u6709\u8282\u70b9\u8dd1\u811a\u672c,\u5e76\u67e5\u770b\u65e5\u5fd7\u68c0\u67e5\uff1a\n\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/root.sh<\/code><\/pre>\n<h1>\u4e09\u3001\u624b\u5de5\u5efa\u7acb\u78c1\u76d8\u7ec4<\/h1>\n<pre><code class=\"language-sql\">col name format a10\nset line 9999\ncol path format a15\nselect GROUP_NUMBER,path,name,disk_number,total_mb,free_mb,CREATE_DATE,MOUNT_STATUS,MOUNT_DATE\nfrom v$asm_disk order by GROUP_NUMBER desc,disk_number;\n\nselect group_number,name,state,total_mb,free_mb from v$asm_diskgroup;\n\nCREATE DISKGROUP DATA external REDUNDANCY disk &#039;\/dev\/mapper\/DATA&#039; ATTRIBUTE &#039;au_size&#039;=&#039;1M&#039;, &#039;compatible.asm&#039; = &#039;11.2&#039;;\n\n\u8282\u70b92\u6302\u8f7d\uff1a\nalter diskgroup DATA mount;<\/code><\/pre>\n<h1>\u56db\u3001\u670d\u52a1\u5668\u91cd\u542f\uff0c\u8bbe\u7f6e\u96c6\u7fa4\u670d\u52a1\u8ddf\u968f\u5f00\u673a\u542f\u52a8<\/h1>\n<pre><code class=\"language-sql\">reboot\n\nvi \/etc\/inittab\nh1:35:respawn:\/etc\/init.d\/init.ohasd run &gt;\/dev\/null 2&gt;&amp;1 &lt;\/dev\/null<\/code><\/pre>\n<h1>\u4e94\u3001\u521b\u5efa\u6570\u636e\u5e93\uff08\u6709\u70b9\u95ee\u9898\uff0c\u540e\u7eed\u6709\u7528\u5230\u6539\uff09--&gt;\u9759\u9ed8DBCA<\/h1>\n<pre><code class=\"language-sql\">dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \\\n-gdbname mydb -sid mydb \\\n-sysPassword oracle -systemPassword oracle \\\n-datafileDestination &#039;DATA\/&#039; -recoveryAreaDestination &#039;FRA\/&#039; \\\n-redoLogFileSize 50 \\\n-storageType ASM -asmsnmpPassword oracle -diskGroupName &#039;DATA&#039; \\\n-characterset AL32UTF8 -nationalCharacterSet AL16UTF16 \\\n-sampleSchema true \\\n-automaticMemoryManagement true -totalMemory 2048 \\\n-databaseType OLTP \\\n-emConfiguration NONE \\\n-nodeinfo NODE1,NODE2\n<\/code><\/pre>\n<h1>\u516d\u3001\u624b\u5de5\u5efa\u5e93<\/h1>\n<p>h```sql<br \/>\nttp:\/\/blog.itpub.net\/26736162\/viewspace-2121981\/<\/p>\n<pre><code><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>RAC\u96c6\u7fa4\u9759\u9ed8\u5b89\u88c5\uff1a \u524d\u9762\u73af\u5883\u53d8\u91cf\u7b49\u914d\u7f6e\u540c\u56fe\u5f62\u5b89\u88c5<\/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-1428","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\/1428","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=1428"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1428\/revisions"}],"predecessor-version":[{"id":1429,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1428\/revisions\/1429"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1428"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}