Oracle Study之--AMD CPU安装Oracle 11gR2 RAC错误

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/gridEnter 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 createdFinished 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_paramsFailure with signal 11 from command: /u01/11.2.0/grid/bin/ocrconfig -local -upgrade grid oinstallFailed 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目录并应用：

1. [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成功！