Failed to create or upgrade OLR

   對於Oracle 11g RAC 的安裝，與Oracle 10g(clusterware)類似，grid 安裝完畢後需要執行orainstroot.sh和root.sh，如果是AMD晶片，Oracle說不認識啊，那就要恭喜一下你又多了一次patch的親密接觸，這個錯誤提示是Failed to create or upgrade OLR。客官，中招了？接著往下看...

1、安裝時的環境    

 作業系統(Oracle linux 5.5 32bit)    

 [root@node1 ~]# cat /etc/issue    

 Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)    

 Kernel \r on an \m    

 Oracle版本    

 Oracle 11g RAC R2(32bit)    

 宿主機系統    

 Win7 64bit + vmware server 2.0.2    

2、錯誤再現  

 [root@node1 ~]# /u01/app/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/app/11.2.0/grid  

 Enter the full pathname of the local bin directory: [/usr/local/bin]:  

    Copying dbhome to /usr/local/bin ...  

    Copying oraenv to /usr/local/bin ...  

    Copying coraenv to /usr/local/bin ...  

 Creating /etc/oratab file...  

 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.  

 2012-12-12 21:20:04: Parsing the host name  

 2012-12-12 21:20:04: Checking for super user privileges  

 2012-12-12 21:20:04: User has super user privileges  

 Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params  

 Creating trace directory  

 Failure with signal 11 from command: /u01/app/11.2.0/grid/bin/ocrconfig -local -upgrade grid oinstall  

 Failed to create or upgrade OLR  

 #查看記錄檔  

 [grid@node1 ~]$ cd $ORACLE_HOME/log/node1  

 [grid@node1 node1]$ pwd  

 /u01/app/11.2.0/grid/log/node1  

 [grid@node1 node1]$ ls  

 admin  agent  alertnode1.log  client  crsd  cssd  ctssd  diskmon  evmd  gipcd  gnsd  gpnpd  mdnsd  ohasd  racg  srvm  

 [grid@node1 node1]$ tail -30 alertnode1.log  

 Oracle Database 11g Clusterware Release 11.2.0.1.0 - Production Copyright 1996, 2009 Oracle. All rights reserved.  

 2012-12-12 21:20:06.347  

 [client(14059)]CRS-2106:The OLR location /u01/app/11.2.0/grid/cdata/node1.olr is inaccessible.  

  Details in /u01/app/11.2.0/grid/log/node1/client/ocrconfig_14059.log.  

 #也可以根據上面的描述查看日誌的詳細資料，此處省略  

3、問題分析  

 關於這個問題，Meatlink 上[ID 1068212.1]有關於這個問題的描述，同時也說明明了由bug 8670579所引起的，而且還是未公開的，說是  

 不認識新的AMD晶片，我倒...  

 一起來看看解決辦法吧。  

 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 <GRID_HOME>/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 <GRID_HOME>/install/rootcrs.pl -deconfig -force  

 - Install the Patch as Oracle User (opatch apply)  

 - Rerun root.sh  

 上面的描述說明了兩種情況。  

 a. 僅僅在所有節點執行了orainstroot.sh，還沒有執行root.sh  

   那麼使用grid使用者再開一個session，  

   在所有節點使用opatch來打補丁(8670579)  

   再運行root.sh  

 b. 已經執行了root.sh  

   使用root帳戶先deconfigure之前的配置  

   使用grid再打補丁(grid)，  

   重新運行root.sh  

4、問題解決  

 #現在當前屬於b情形，因此先deconfigure  

 #注意我當前的補丁檔案放在/inst_src/patch8670579路徑  

 [grid@node1 grid]$ pwd  

 /u01/app/11.2.0/grid  

 [grid@node1 grid]$ cd OPatch/  

 [grid@node1 OPatch]$ ./opatch apply /inst_src/patch8670579/8670579  

 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/app/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/app/11.2.0/grid/oui  

 Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2012-12-13_11-39-32AM.log  

 Patch history file: /u01/app/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/app/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: 'node2'  

 Local node: 'node1'  

 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.  

 (Oracle Home = '/u01/app/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/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/ahseteco.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/am11rkg.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/amsha.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/cpui32.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/sha.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/x931rand.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/am11dkg.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/am931rnd.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/amsharnd.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/ghash.o"  

 Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a"  with "lib/libnnz11.a/shacomm.o"  

 Copying file to "/u01/app/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.  

 #上面提示patch已經成功  

 Patching in rolling mode.  

 The node 'node2' will be patched next.  

 Please shutdown Oracle instances running out of this ORACLE_HOME on 'node2'.  

 (Oracle Home = '/u01/app/11.2.0/grid')  

 Is the node ready for patching? [y|n]  

 #這裡提示節點2是否已準備好，我這裡選擇了n，所以下面給出了錯誤提示  

 #我這裡採取的是單節點patch的方法  

 OPatch failed with error code 130  

 #Author: Robinson  

 #接下來單獨在第二個節點patch，之後在執行root.sh，一路高歌阿...  

   #注意patch的時候check一下ORACLE_HOME環境變數以及perl -v 查看perl的版本，應當高於5.00503  

   #感覺Oracle 11g 32 bit版本問題挺多的。儘可能安裝64bit測試。還有一點說明，安裝oracle database後也要patch 8670579，否則dbca報錯。  

5、附[ID 1068212.1]  

 GRID INSTALLATION ROOT.SH fails with Failure with signal 11 Failed to create or upgrade OLR [ID 1068212.1] To Bottom    

 --------------------------------------------------------------------------------  

 Modified:Mar 21, 2012Type:PROBLEMStatus:PUBLISHEDPriority:3 Comments (0)      

 In this Document  

   Symptoms  

   Cause  

   Solution  

   References  

 --------------------------------------------------------------------------------  

 Applies to:  

 Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 and later   [Release: 11.2 and later ]  

 Information in this document applies to any platform.  

 Symptoms  

 During installation of Grid Infrastructure root.sh and de-install fail with:  

 "Failure with signal 11 from command: <grid home>/bin/ocrconfig -local -upgrade oracle oinstall  

 Failed to create or upgrade OLR"  

 And in the alert<node>.log of clusterware (<CRS_HOME>/log/<node>/):  

 [client(2294)]CRS-2106:The OLR location <grid hoe>/cdata/bumucsvm5.olr is inaccessible.  

 Details in <grid home>/log/<node>/client/ocrconfig_nnnn.log.  

 And in this log:  

 Oracle Database 11g Clusterware Release 11.2.0.1.0 - Production Copyright 1996, 2009 Oracle. All rights reserved.  

 2010-02-26 14:36:48.183: [ OCRCONF][3047065280]ocrconfig starts...  

 2010-02-26 14:36:48.184: [ OCRCONF][3047065280]Upgrading OCR data  

 2010-02-26 14:36:48.185: [ OCROSD][3047065280]utread:3: Problem reading buffer 9ea9000 buflen 4096 retval 0 phy_offset 102400 retry 0  

 2010-02-26 14:36:48.185: [ OCROSD][3047065280]utread:3: Problem reading buffer 9ea9000 buflen 4096 retval 0 phy_offset 102400 retry 1  

 2010-02-26 14:36:48.185: [ OCROSD][3047065280]utread:3: Problem reading buffer 9ea9000 buflen 4096 retval 0 phy_offset 102400 retry 2  

 2010-02-26 14:36:48.185: [ OCROSD][3047065280]utread:3: Problem reading buffer 9ea9000 buflen 4096 retval 0 phy_offset 102400 retry 3  

 2010-02-26 14:36:48.185: [ OCROSD][3047065280]utread:3: Problem reading buffer 9ea9000 buflen 4096 retval 0 phy_offset 102400 retry 4  

 2010-02-26 14:36:48.185: [ OCROSD][3047065280]utread:3: Problem reading buffer 9ea9000 buflen 4096 retval 0 phy_offset 102400 retry 5  

 2010-02-26 14:36:48.185: [ OCRRAW][3047065280]propriogid:1_1: Failed to read the whole bootblock. Assumes invalid format.  

 2010-02-26 14:36:48.185: [ OCRRAW][3047065280]proprioini: all disks are not OCR/OLR formatted  

 2010-02-26 14:36:48.185: [ OCRRAW][3047065280]proprinit: Could not open raw device  

 2010-02-26 14:36:48.186: [ default][3047065280]a_init:7!: Backend init unsuccessful : [26]  

 2010-02-26 14:36:48.186: [ OCRCONF][3047065280]Exporting OCR data to [OCRUPGRADEFILE]  

 2010-02-26 14:36:48.187: [ OCRAPI][3047065280]a_init:7!: Backend init unsuccessful : [33  

 Another indication for this error is that deinstall will fail with the following error:  

 ######################## CHECK OPERATION START ########################  

 Install check configuration START  

 #  

 # An unexpected error has been detected by HotSpot Virtual Machine:  

 #  

 # SIGSEGV (0xb) at pc=0x87af135e, pid=2767, tid=3086526144  

 #  

 # Java VM: Java HotSpot(TM) Server VM (1.5.0_17-b02 mixed mode)  

 # Problematic frame:  

 # C [libnnz11.so+0x3c35e]  

 #  

 # An error report file with more information is saved as hs_err_pidnnnn.log  

 #  

 # If you would like to submit a bug report, please visit:  

 # http://java.sun.com/webapps/bugreport/crash.jsp  

 #  

 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 <GRID_HOME>/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 <GRID_HOME>/install/rootcrs.pl -deconfig -force  

 - Install the Patch as Oracle User (opatch apply)  

 - Rerun root.sh  

 References  

 BUG:9166347 - GRID INSTALLATION ROOT.SH AND DEINSTALL FAIL WITH HOTSPOT VIRTUAL MACHINE SIGSEG  

 NOTE:942076.1 - X86 DBCA, NETCA GIVE JAVA HOTSPOT ERROR IF ON X86_64 HARDWARE  

 NOTE:957903.1 - 11gR2 OUI Crashes: An Unexpected Error Has Been Detected By Java HotSpot Virtual Machine, libjvm.so

oracle視頻教程請關注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html