欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

OracleStudy之--AMDCPU安装Oracle11gR2RAC错误

程序员文章站 2022-05-15 16:50:01
...

Oracle Study之--AMD CPU安装Oracle 11gR2 RAC错误 系统环境: 操作系统: RedHat EL55 Oracle : Oracle 11gR2 Grid + Oracle 1、错误现象 [root@syl1install]#/u01/11.2.0/grid/root.shRunningOracle11groot.shscript...Thefollowingenvironmentvariablesa

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: scrsearch3  
  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/opatch2015-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成功!