ITPub博客

首页 > Linux操作系统 > Linux操作系统 > AIX Oracle RAC 升级到10.2.0.4.0要特别注意的问题

AIX Oracle RAC 升级到10.2.0.4.0要特别注意的问题

原创 Linux操作系统 作者:尛样儿 时间:2010-04-02 12:17:55 0 删除 编辑
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博客 ” ,链接:https://blog.itpub.net/23135684/viewspace-631065/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle数据库管理员,Oracle数据库系统构架员;2012年7月出版《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》一书;Oracle 10g OCM。

注册时间:2010-01-05

  • 博文量
    483
  • 访问量
    5648757