在紅旗DC server 6.0上安裝oracle 11gR2時出現的錯誤，以及解決辦法

前端時間在紅旗DC server 6.0上安裝oracle 11gR2時出現了幾個錯誤，經過不斷的排查，最終解決了這些錯誤，現將其整理如下，以供大家參考，如果需補充的請大家補充。

1．  在校驗時會碰到如下兩個錯誤：

a）PRVF-5150的錯誤，此錯誤可以忽略。

這個是oracle的一個bug，可以不用管，具體見：Device Checks for ASM Fails with PRVF-5150: Path ORCL: is not a valid path [ID 1210863.1]

b)PRVF-5623，PRVF-5636

這種錯誤可以忽略

2．  在第一個節點上執行root.sh指令碼後，報下面的錯誤：

 

./root.sh  on node1:

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 script.

Now product-specific root actions will be performed.

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

Creating trace directory

LOCAL ADD MODE

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

OLR initialization - 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

ACFS-9200: Supported

Invalid kernel variation 'AXS3'.

Operation aborted.

CRS-2672: Attempting to start 'ora.mdnsd' on 'xxxx_db-01'

CRS-2676: Start of 'ora.mdnsd' on 'xxxx_db-01' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'xxxx_db-01'

CRS-2676: Start of 'ora.gpnpd' on 'xxxx_db-01' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'xxxx_db-01'

CRS-2672: Attempting to start 'ora.gipcd' on 'xxxx_db-01'

CRS-2676: Start of 'ora.cssdmonitor' on 'xxxx_db-01' succeeded

CRS-2676: Start of 'ora.gipcd' on 'xxxx_db-01' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'xxxx_db-01'

CRS-2672: Attempting to start 'ora.diskmon' on 'xxxx_db-01'

CRS-2676: Start of 'ora.diskmon' on 'xxxx_db-01' succeeded

CRS-2676: Start of 'ora.cssd' on 'xxxx_db-01' succeeded

ASM created and started successfully.

Disk Group DATA created successfully.

clscfg: -install mode specified

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4256: Updating the profile

Successful addition of voting disk 4b0f3c0e9c3c4f89bf3f7280c0a20d07.

Successfully replaced voting disk group with +DATA.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group

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

 1. ONLINE   4b0f3c0e9c3c4f89bf3f7280c0a20d07 (ORCL:DATA01) [DATA]

Located 1 voting disk(s).

CRS-2672: Attempting to start 'ora.asm' on 'xxxx_db-01'

CRS-2676: Start of 'ora.asm' on 'xxxx_db-01' succeeded

CRS-2672: Attempting to start 'ora.DATA.dg' on 'xxxx_db-01'

CRS-2676: Start of 'ora.DATA.dg' on 'xxxx_db-01' succeeded

ACFS-9200: Supported

ACFS-9200: Supported

CRS-2672: Attempting to start 'ora.registry.acfs' on 'xxxx_db-01'

CRS-5016: 程式 "/u01/app/11.2.0/grid/bin/acfsregistrymount" (由代理 "/u01/app/11.2.0/grid/bin/orarootagent.bin" 衍生, 用於操作 "start") 失敗: 詳細資訊見 "(:CLSN00010:)" (位於 "/u01/app/11.2.0/grid/log/xxxx_db-01/agent/crsd/orarootagent_root/orarootagent_root.log")

CRS-2674: Start of 'ora.registry.acfs' on 'xxxx_db-01' failed

CRS-4000: Command Start failed, or completed with errors.

FirstNode configuration failed at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 8373.

/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed

 

2.1此錯誤是紅旗DC Sserver6.0中的bug，因此需要在執行root.sh前修改/u01/app/11.2.0/grid/lib/osds_acfsroot.pm檔案中的一行程式碼（兩個節點都修改）,並執行2.2後，再執行root.sh：

具體補丁包：/tmp/osds_acfsroot.pm.diff

內容如下：

--- /u01/app/11.2.0/grid/lib/osds_acfsroot.pm   2011-03-02 13:51:41.000000000 +0800

+++ /u01/app/11.2.0/grid/lib/osds_acfsroot.pm.new       2011-03-02 13:51:25.000000000 +0800

@@ -712,7 +712,7 @@

     # case, it's an internal error that should have been caught before we got

     # here and so we just bail. We don't want to fail the entire oracle install

     # and so return USM_NOT_SUPPORTED so that OUI can complete sans USM.

-    if (!(($variation eq 'el5') ||

+    if (!(($variation eq 'el5') || ($variation eq 'AXS3') ||

           ($variation eq 'el5PAE') || ($variation eq 'el5xen')))

     {

       lib_error_print(9999, "Invalid kernel variation '$variation'.");

 

 

patch -p0 < /tmp/osds_acfsroot.pm.diff

 

2.2 新增核心目錄：

cd $ORACLE_HOME/install/usm/EL5/x86_64/2.6.18-8

cp -a 2.6.18-8.el5-x86_64 2.6.18-8.AXS3-x86_64

 

3．  當第一個節點執行root.sh檔案後，在第二個節點上執行root.sh檔案，會報如下錯誤：

   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]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

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 script.

Now product-specific root actions will be performed.

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

Creating trace directory

LOCAL ADD MODE

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

OLR initialization - successful

Adding daemon to inittab

ACFS-9200: Supported

Invalid kernel variation 'AXS3'.

Operation aborted.

CRS-4402: CSS 守護程式已在獨佔模式下啟動, 但在節點 xxxx_db-01 (編號為 1) 上發現活動 CSS 守護程式, 因此正在終止

An active cluster was found during exclusive startup, restarting to join the cluster

Failed to start Oracle Clusterware stack

Failed to start Cluster Synchorinisation Service in clustered mode at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1016.

/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed

這是oracle 11.2.0.2上的一bug，需要打補丁：p9974223_112020_Linux-x86-64.zip

打補丁的方法如下：

a）兩個節點上（root）：

/crs/install/rootcrs.pl -unlock

b）兩個節點上（grid）：

/u01/app/11.2.0/grid/OPatch/opatch napply -local -oh /u01/app/11.2.0/grid -id 9974223

c）兩個節點上（root）：

/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch

4．  將補丁打完後，在節點2上再次執行root.sh，即可安裝完成。

5．  在後續的校驗中可能出現scan ip不一致的問題，如：

資訊: 正在檢查 "dbnode-scan" 的名稱解析設定...

資訊: ERROR:

資訊: PRVF-4664 : 發現與 SCAN 名稱 "dbnode-scan" 不一致的名稱解析條目

資訊: ERROR:

資訊: PRVF-4657 : "dbnode-scan" (IP 地址: 192.168.1.129) 的名稱解析設定檢查失敗

資訊: ERROR:

資訊: PRVF-4664 : 發現與 SCAN 名稱 "dbnode-scan" 不一致的名稱解析條目

可以忽略。

 

6．  安裝完後，發現資料庫的時間是錯的，grid，oracle日誌的時間也是錯的，和正確的時間差了16個小時整。

時區錯誤的解決辦法：

Oracle使用者下：srvctl setenv database -d track -t TZ=Asia/Beijing

但是這樣只能解決oracle的時區時間，對於grid的時區時間卻沒有改變過來，

要想徹底解決時區的問題，

需要修改：$GRID_HOME/crs/install/s_crsconfig__env.txt

詳細見How To Change Timezone for 11gR2 Grid Infrastructure [ID 1209444.1]

因此，建議在安裝完grid後，檢查一下此檔案的內容，如果錯誤，調整完後，再安裝oracle資料庫軟體，建庫就不會出現時區錯誤。

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12129601/viewspace-709864/，如需轉載，請註明出處，否則將追究法律責任。