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.shError : 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 changeOracle strongly recommends that the CSS daemon run realtimeCreating pre-patch directory for saving pre-patch clusterware files
未对这个错误做处理也能正常的运行Oracle RAC。但是在errpt -a中会出现以下报错:
---------------------------------------------------------------------------LABEL: CORE_DUMPIDENTIFIER: C69F5C9BDate/Time: Mon Mar 29 16:34:52 BEIST 2010Sequence Number: 166Machine Id: 00C79A844C00Node Id: bwgl_db1Class: SType: PERMResource Name: SYSPROCDescriptionSOFTWARE PROGRAM ABNORMALLY TERMINATEDProbable CausesSOFTWARE PROGRAMUser CausesUSER GENERATED SIGNALRecommended ActionsCORRECT THEN RETRYFailure CausesSOFTWARE PROGRAMRecommended ActionsRERUN THE APPLICATION PROGRAMIF PROBLEM PERSISTS THEN DO THE FOLLOWINGCONTACT APPROPRIATE SERVICE REPRESENTATIVEDetail DataSIGNAL NUMBER6USER'S PROCESS ID:180396FILE SYSTEM SERIAL NUMBER12INODE NUMBER21259CORE FILE NAME/u01/app/oracle/crs_1/log/bwgl_db1/crsd/corePROGRAM NAMEcrsd.binSTACK EXECUTION DISABLED0COME FROM ADDRESS REGISTERvmpcopy 6A4PROCESSOR IDhw_fru_id: N/Ahw_cpu_id: N/AADDITIONAL INFORMATIONpthread_k 88??Symptom DataREPORTABLE1INTERNAL ERROR0SYMPTOM CODEPCSS/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> startupORA-27126: unable to lock shared memory segment in coreIBM 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服务即可。