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服務即可。
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- IBM aix下oracle 9.2.0.5 rac 升級到oracle 9.2.0.8IBMAIOracle
- Oracle RAC 10.2.0.5升級到11.2.0.4遇到的問題Oracle
- aix 6.1上rac升級到10.2.0.4AI
- 【江楓 】AIX平臺升級到Oracle10.2.0.4的幾個問題AIOracle
- oracle 10.2.0.1 rac 升級到10.2.0.4 rac時,dbua升級的元件列表Oracle元件
- oracle 10 rac 升級 10.2.0.1升級到10.2.0.5Oracle
- oracle9207 rac 升級到9208異常問題Oracle
- 升級到MySQL5.7版本需注意的問題MySql
- Oracle 升級到 11.2.0.2 注意事項Oracle
- oracle rac 10.2.0.1 升級到 oracle 10.2.0.4Oracle
- 單節點oracle升級10.2.0.1.0-10.2.0.4.0Oracle
- ReactNative升級0.56.0注意問題React
- 配置Oracle RAC需要注意的問題Oracle
- oracle 10.2.0.4 rac 升級到oracle 10.2.0.5 rac步驟Oracle
- oracle rac 11.2.0.3 升級到11.2.0.4Oracle
- HP UNIX - oracle rac 10.2.0.3 升級10.2.0.4問題Oracle
- Oracle 10g rac升級需要注意的事項Oracle 10g
- oracle 12c rac 在aix 7.1 上安裝需要注意的IOCP問題OracleAI
- oracle cluster 10.2.0.1 for aix 6.1 升級到10.2.0.4會出現vip offline問題OracleAI
- Oracle 10g rac升級(10.2.0.1 Rac到10.2.0.4)Oracle 10g
- ORACLE RAC 的滾動升級Oracle
- RAC升級到10.2.0.4碰到的幾個問題及處理辦法
- AIX上安裝、升級Oracle 10g RAC的情況總結AIOracle 10g
- 在IBM AIX 安裝oracle 軟體的注意問題IBMAIOracle
- ORACLE EBS R12 1201 -> 1204 升級中特別注意事項Oracle
- oracle 9.2.0.4升級到9.2.0.8時exp匯出時遇到的問題Oracle
- 使用DBUA升級 Oracle 11.2.0.4到Oracle 19C的問題記錄Oracle
- Oracle10g RAC : 10.2.0.1 升級到 10.2.0.4Oracle
- AIX平臺升級11.2需要注意的補丁AI
- Windows 系統安裝Oracle升級到9.2.0.8 後,exp問題WindowsOracle
- 資料升級到5.1所遇到的問題
- aix6安裝oracle 10g rac問題AIOracle 10g
- Oracle Database 11.1.0.7 for Windows升級到11.2.0.3.4 for Linux遇到的問題OracleDatabaseWindowsLinux
- Oracle10.2.0.1升級到10.2.0.4碰到的Text file busy問題Oracle
- linux下oracle RAC10.2.0.1升級到10.2.0.4LinuxOracle
- oracle 10g rac升級Oracle 10g
- oracle over()的使用和需要特別注意的地方Oracle
- aix升級opensshAI