aix oracle 10.2.0.1 升级 10.2.0.4,AIX Oracle RAC 升级到10.2.0.4.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服务即可。

from:http://space.itpub.net/23135684/viewspace-631065

总结

以上是生活随笔为你收集整理的aix oracle 10.2.0.1 升级 10.2.0.4,AIX Oracle RAC 升级到10.2.0.4.0要特别注意的问题 - 爱肯的专栏 ......的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。