AIX Oracle RAC 升級到10.2.0.4.0要特別注意的問題

尛樣兒發表於2010-04-02
AIOracle
AIX Oracle RAC 升級到10.2.0.4.0過程有如下報錯(直接升級到10.2.0.4不需要應用Patch:6160398)：
root@bwgl_db2:/u01/app/oracle/crs_1/bin# /u01/app/oracle/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id to have the following OS capabilities :
 
by running command then 'crsctl stop crs' and 'crsctl start crs'.
The CSS daemon, ocssd.bin, will not run in realtime without  this change
Oracle strongly recommends that the CSS daemon run realtime
Creating pre-patch directory for saving pre-patch clusterware files

未對這個錯誤做處理也能正常的執行Oracle RAC。但是在errpt -a中會出現以下報錯：
---------------------------------------------------------------------------
LABEL:          CORE_DUMP
IDENTIFIER:     C69F5C9B

Date/Time:       Mon Mar 29 16:34:52 BEIST 2010
Sequence Number: 166
Machine Id:      00C79A844C00
Node Id:         bwgl_db1
Class:           S
Type:            PERM
Resource Name:   SYSPROC        

Description
SOFTWARE PROGRAM ABNORMALLY TERMINATED

Probable Causes
SOFTWARE PROGRAM

User Causes
USER GENERATED SIGNAL

    Recommended Actions
    CORRECT THEN RETRY

Failure Causes
SOFTWARE PROGRAM

    Recommended Actions
    RERUN THE APPLICATION PROGRAM
    IF PROBLEM PERSISTS THEN DO THE FOLLOWING
    CONTACT APPROPRIATE SERVICE REPRESENTATIVE

Detail Data
SIGNAL NUMBER
           6
USER'S PROCESS ID:
                180396
FILE SYSTEM SERIAL NUMBER
          12
INODE NUMBER
       21259
CORE FILE NAME
/u01/app/oracle/crs_1/log/bwgl_db1/crsd/core
PROGRAM NAME
crsd.bin
STACK EXECUTION DISABLED
           0
COME FROM ADDRESS REGISTER
vmpcopy 6A4

PROCESSOR ID
  hw_fru_id: N/A
  hw_cpu_id: N/A

ADDITIONAL INFORMATION
pthread_k 88
??

Symptom Data
REPORTABLE
1
INTERNAL ERROR
0
SYMPTOM CODE
PCSS/SPI2 FLDS/crsd.bin SIG/6 FLDS/pthread_k VALU/88
---------------------------------------------------------------------------

另外根據有些文章所說，在AIX平臺Oracle RAC升級到10.2.0.4.0之後，如果要將sga_lock設定為TRUE。也需要做同樣的處理，否則在設定sga_lock=TRUE之後啟動會報錯：
SQL> startup
ORA-27126: unable to lock shared memory segment in core
IBM AIX RISC System/6000 Error: 1: Not owner

根據報錯，以上的2種情況都需要做如下處理：
#chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH oracle
#lsuser -a capabilities oracle

設定完成後重啟以下CRS服務即可。

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

相關文章