十年网站开发经验 + 多家企业客户 + 靠谱的建站团队
量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决
Oracle Study之--AMD CPU安装Oracle 11gR2 RAC错误
为建平等地区用户提供了全套网页设计制作服务,及建平网站建设行业解决方案。主营业务为成都做网站、网站设计、建平网站设计,以传统方式定制建设网站,并提供域名空间备案等一条龙服务,秉承以专业、用心的态度为用户提供真诚的服务。我们深信只要达到每一位用户的要求,就会得到认可,从而选择与我们长期合作。这样,我们也可以走得更远!
系统环境:
操作系统: RedHat EL55
Oracle : Oracle 11gR2 Grid + Oracle
1、错误现象
[root@syl1 install]# /u01/11.2.0/grid/root.shRunning Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed.2015-05-26 14:40:11: Parsing the host name2015-05-26 14:40:11: Checking for super user privileges2015-05-26 14:40:11: User has super user privilegesUsing configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params Failure with signal 11 from command: /u01/11.2.0/grid/bin/ocrconfig -local -upgrade grid oinstall Failed to create or upgrade OLR
2、清除CRS配置
[root@syl1 install]# perl rootcrs.pl -deconfig -force 2015-05-26 14:40:30: Parsing the host name 2015-05-26 14:40:30: Checking for super user privileges 2015-05-26 14:40:30: User has super user privileges Using configuration parameter file: ./crsconfig_params PRCR-1035 : Failed to look up CRS resource ora.cluster_vip.type for 1 PRCR-1068 : Failed to query resources Cannot communicate with crsd PRCR-1070 : Failed to check if resource ora.gsd is registered Cannot communicate with crsd PRCR-1070 : Failed to check if resource ora.ons is registered Cannot communicate with crsd PRCR-1070 : Failed to check if resource ora.eons is registered Cannot communicate with crsd ACFS-9200: Supported CRS-4535: Cannot communicate with Cluster Ready Services CRS-4000: Command Stop failed, or completed with errors. Failure at scls_scr_setval with code 8 Internal Error Information: Category: -2 Operation: failed Location: scrsearch4 Other: id doesnt exist scls_scr_setval System Dependent Information: 2 CRS-4544: Unable to connect to OHAS CRS-4000: Command Stop failed, or completed with errors. error: package cvuqdisk is not installed 3、解决方法 关于这个问题,Meatlink 上[ID 1068212.1]有关于这个问题的描述,同时也说明明了由bug 8670579所引起的,而且还是未公开的,说是不认识新的AMD芯片, 原来是AMD CPU搞得鬼 [html] view plaincopyprint? Cause Unpublished bug 8670579 which relates to the identification of newer AMD chips and therefore only affect platforms using the newer AMD chips. Solution If the error occurs during the installation of the GRID Infrastructure the patch has to be applied, before the root.sh Script in the installation is run: a.) Run a installation (grid/runInstaller) to the prompt where it requests to run orainstroot.sh and/root.sh b.) Run orainstroot.sh on all nodes, but not root.sh c.) Open another session with the Oracle User and apply Patch 8670579 on all nodes (with opatch apply). d.) Continue with the root.sh from the installation. If you hit this bug, and have already started root.sh then: - Deconfigure Clusterware on the failed host with /install/rootcrs.pl -deconfig -force - Install the Patch as Oracle User (opatch apply) - Rerun root.sh
4、下载上传patch并应用(以grid用户的身份)
[grid@syl1 ~]$ ls
oradiag_grid p8670579_112010_LINUX.zip
[grid@syl1 ~]$ unzip p8670579_112010_LINUX.zip
Archive: p8670579_112010_LINUX.zip creating: 8670579/ creating: 8670579/files/ creating: 8670579/files/lib/ creating: 8670579/files/lib/libnnz11.a/ inflating: 8670579/files/lib/libnnz11.a/ahseteco.o inflating: 8670579/files/lib/libnnz11.a/am11rkg.o inflating: 8670579/files/lib/libnnz11.a/amsha.o inflating: 8670579/files/lib/libnnz11.a/cpui32.o inflating: 8670579/files/lib/libnnz11.a/sha.o inflating: 8670579/files/lib/libnnz11.a/x931rand.o inflating: 8670579/files/lib/libnnz11.a/am11dkg.o inflating: 8670579/files/lib/libnnz11.a/am931rnd.o inflating: 8670579/files/lib/libnnz11.a/amsharnd.o inflating: 8670579/files/lib/libnnz11.a/ghash.o inflating: 8670579/files/lib/libnnz11.a/shacomm.o inflating: 8670579/files/lib/libnnz11.so creating: 8670579/etc/ creating: 8670579/etc/config/ inflating: 8670579/etc/config/inventory.xml inflating: 8670579/etc/config/actions.xml inflating: 8670579/etc/config/deploy.xml creating: 8670579/etc/xml/ inflating: 8670579/etc/xml/GenericActions.xml inflating: 8670579/etc/xml/ShiphomeDirectoryStructure.xml inflating: 8670579/README.txt extracting: ¢|||í?ê?-á+?.txt
[grid@syl1 ~]$ ls
8670579 oradiag_grid p8670579_112010_LINUX.zip ??????ê?-?+?.txt
进入patch目录并应用:
[grid@syl1 ~]$ cd 8670579/ [grid@syl1 8670579]$ /u01/11.2.0/grid/OPatch/opatch apply Invoking OPatch 11.1.0.6.6 Oracle Interim Patch Installer version 11.1.0.6.6 Copyright (c) 2009, Oracle Corporation. All rights reserved. Oracle Home : /u01/11.2.0/grid Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.1.0.6.6 OUI version : 11.2.0.1.0 OUI location : /u01/11.2.0/grid/oui Log file location : /u01/11.2.0/grid/cfgtoollogs/opatch/opatch3015-05-26_14-52-15PM.log Patch history file: /u01/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt -------------------------------------------------------------------------------- The patch has more than one Archive Action but there is no Make Action. -------------------------------------------------------------------------------- ApplySession applying interim patch '8670579' to OH '/u01/11.2.0/grid' Running prerequisite checks... OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes. This node is part of an Oracle Real Application Cluster. Remote nodes: 'syl2' Local node: 'syl1' Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/11.2.0/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files and inventory (not for auto-rollback) for the Oracle Home Backing up files affected by the patch '8670579' for restore. This might take a while... Backing up files affected by the patch '8670579' for rollback. This might take a while... Patching component oracle.network.rsf, 11.2.0.1.0... Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/ahseteco.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/am11rkg.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/amsha.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/cpui32.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/sha.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/x931rand.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/am11dkg.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/am931rnd.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/amsharnd.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/ghash.o" Updating archive file "/u01/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/shacomm.o" Copying file to "/u01/11.2.0/grid/lib/libnnz11.so" ApplySession adding interim patch '8670579' to inventory Verifying the update... Inventory check OK: Patch ID 8670579 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8670579 are present in Oracle Home. The local system has been patched. You can restart Oracle instances on it. Patching in rolling mode. The node 'syl2' will be patched next. Please shutdown Oracle instances running out of this ORACLE_HOME on 'syl2'. (Oracle Home = '/u01/11.2.0/grid') Is the node ready for patching? [y|n] y User Responded with: Y Updating nodes 'syl2' Apply-related files are: FP = "/u01/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_files.txt" DP = "/u01/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_dirs.txt" MP = "/u01/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/make_cmds.txt" RC = "/u01/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/remote_cmds.txt" Instantiating the file "/u01/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_files.txt" with actual path. Propagating files to remote nodes... Instantiating the file "/u01/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_dirs.txt" with actual path. Propagating directories to remote nodes... The node 'syl2' has been patched. You can restart Oracle instances on it. OPatch succeeded.
5、重新执行root.sh
[root@syl1 ~]# /u01/11.2.0/grid/root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 2015-05-26 14:58:23: Parsing the host name 2015-05-26 14:58:23: Checking for super user privileges 2015-05-26 14:58:23: User has super user privileges Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params LOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. root wallet root wallet cert root cert export peer wallet profile reader wallet pa wallet peer wallet keys pa wallet keys peer cert request pa cert request peer cert pa cert peer root cert TP profile reader root cert TP pa root cert TP peer pa cert TP pa peer cert TP profile reader pa cert TP profile reader peer cert TP peer user cert pa user cert Adding daemon to inittab CRS-4123: Oracle High Availability Services has been started. ohasd is starting CRS-2672: Attempting to start 'ora.gipcd' on 'syl1' CRS-2672: Attempting to start 'ora.mDNSd' on 'syl1' CRS-2676: Start of 'ora.gipcd' on 'syl1' succeeded CRS-2676: Start of 'ora.mdnsd' on 'syl1' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'syl1' CRS-2676: Start of 'ora.gpnpd' on 'syl1' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'syl1' CRS-2676: Start of 'ora.cssdmonitor' on 'syl1' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'syl1' CRS-2672: Attempting to start 'ora.diskmon' on 'syl1' CRS-2676: Start of 'ora.diskmon' on 'syl1' succeeded CRS-2676: Start of 'ora.cssd' on 'syl1' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'syl1' CRS-2676: Start of 'ora.ctssd' on 'syl1' succeeded ASM created and started successfully. DiskGroup OCR_VOTE created successfully. clscfg: -install mode specified Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-2672: Attempting to start 'ora.crsd' on 'syl1' CRS-2676: Start of 'ora.crsd' on 'syl1' succeeded CRS-4256: Updating the profile Successful addition of voting disk 09a53580da564f6cbf73f80df1b2fed4. Successful addition of voting disk 008f54a53d074f7bbfa9b183f9731505. Successful addition of voting disk aae02f43bc7f4f6cbfbd5e8374f0cab6. Successfully replaced voting disk group with +OCR_VOTE. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 09a53580da564f6cbf73f80df1b2fed4 (/dev/oracleasm/disks/OCR_VOTE3) [OCR_VOTE] 2. ONLINE 008f54a53d074f7bbfa9b183f9731505 (/dev/oracleasm/disks/OCR_VOTE2) [OCR_VOTE] 3. ONLINE aae02f43bc7f4f6cbfbd5e8374f0cab6 (/dev/oracleasm/disks/OCR_VOTE1) [OCR_VOTE] Located 3 voting disk(s). CRS-2673: Attempting to stop 'ora.crsd' on 'syl1' CRS-2677: Stop of 'ora.crsd' on 'syl1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'syl1' CRS-2677: Stop of 'ora.asm' on 'syl1' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'syl1' CRS-2677: Stop of 'ora.ctssd' on 'syl1' succeeded CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'syl1' CRS-2677: Stop of 'ora.cssdmonitor' on 'syl1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'syl1' CRS-2677: Stop of 'ora.cssd' on 'syl1' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'syl1' CRS-2677: Stop of 'ora.gpnpd' on 'syl1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'syl1' CRS-2677: Stop of 'ora.gipcd' on 'syl1' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on 'syl1' CRS-2677: Stop of 'ora.mdnsd' on 'syl1' succeeded CRS-2672: Attempting to start 'ora.mdnsd' on 'syl1' CRS-2676: Start of 'ora.mdnsd' on 'syl1' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'syl1' CRS-2676: Start of 'ora.gipcd' on 'syl1' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'syl1' CRS-2676: Start of 'ora.gpnpd' on 'syl1' succeeded ......
再次执行root.sh成功!