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

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 /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
上面的描述說明了兩種情況。
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
#Blog : http://blog.csdn.net/robinson_0612
#接下來單獨在第二個節點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: /bin/ocrconfig -local -upgrade oracle oinstall
Failed to create or upgrade OLR"
And in the alert.log of clusterware (/log//):
[client(2294)]CRS-2106:The OLR location /cdata/bumucsvm5.olr is inaccessible.
Details in /log//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:
#
#
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
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

Failed to create or upgrade OLR

相關文章