啟動VIP報CRS-1028/CRS-0223致使VIP狀態為UNKNOWN故障分析與解決,crs-1028crs-0223
CRS版本為10.2.0.4
1、VIP State為UNKNOWN
[root@XXdb1 ~]# crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.dxp.db application ONLINE ONLINE XXdb1 ora....p1.inst application ONLINE ONLINE XXdb1 ora....p2.inst application ONLINE ONLINE XXdb2 ora....SM1.asm application ONLINE ONLINE XXdb1 ora....B1.lsnr application OFFLINE OFFLINE ora.XXdb1.gsd application ONLINE ONLINE XXdb1 ora.XXdb1.ons application ONLINE ONLINE XXdb1 ora.XXdb1.vip application ONLINE UNKNOWN XXdb1 ora....SM2.asm application ONLINE ONLINE XXdb2 ora....B2.lsnr application OFFLINE OFFLINE ora.XXdb2.gsd application ONLINE ONLINE XXdb2 ora.XXdb2.ons application ONLINE ONLINE XXdb2 ora.XXdb2.vip application ONLINE UNKNOWN XXdb2 ora.zsXXdb.db application ONLINE ONLINE XXdb1 ora....b1.inst application ONLINE ONLINE XXdb1 ora....b2.inst application ONLINE ONLINE XXdb2 |
2、手動啟動VIP時報CRS-1028/CRS-0223錯誤
[root@XXdb1 ~]# crs_start ora.XXdb1.vip CRS-1028: Dependency analysis failed because of: 'Resource in UNKNOWN state: ora.XXdb1.vip' CRS-0223: Resource 'ora.XXdb1.vip' has placement error. |
3、分析crsd日誌
2014-07-05 16:10:08.813: [ CRSAPP][1524836704]0StartResource error for ora.XXdb1.vip error code = -1 2014-07-05 16:10:08.826: [ CRSEVT][1524836704]0CAAMonitorHandler :: 0:Could not execute /home/oracle/product/10.2.0/crs/bin/racgwrap(stop) for ora.XXdb1.vip category: 1234, operation: scls_canexec, loc: , OS error: 0, other: no exe permission, file /home/oracle/product/10.2.0/crs/bin/racgwrap |
發現因為在作業系統上,因為對racgwrap檔案沒有執行許可權
4、對racgwrap檔案賦予O=x許可權
#chmod o=x /home/oracle/product/10.2.0/crs/bin/racgwrap |
5、再次啟動VIP,crsd中報出相關其它錯誤
2014-07-05 16:26:05.473: [ CRSAPP][1524836704]0StartResource error for ora.XXdb1.vip error code = 1 |
6、分析vip log
Oracle Database 10g CRS Release 10.2.0.4.0 Production Copyright 1996, 2008 Oracle. All rights reserved. 2014-07-05 17:25:03.565: [ RACG][2540928256] [26035][2540928256][ora.XXdb1.vip]: clsrcexecut: scls_process_spawn() error, status = 1, command = /home/oracle/product/10.2.0/crs/bin/racgeut Category: 1234 Operation: scls_canexec Location: Other: no exe permission, file /home/oracle/product/10.2.0/crs/bin/racgeut OS Error: Error 0 2014-07-05 17:25:03.565: [ RACG][2540928256] [26035][2540928256][ora.XXdb1.vip]: clsrcexecut: scls_process_spawn() error, status = 1, command = /home/oracle/product/10.2.0/crs/bin/racgeut Category: 1234 Operation: scls_canexec Location: Other: no exe permission, file /home/oracle/product/10.2.0/crs/bin/racgeut OS Error: Error 0 2014-07-05 17:25:03.566: [ RACG][2540928256] [26035][2540928256][ora.XXdb1.vip]: end for resource = ora.XXdb1.vip, action = start, status = 1, time = 0.030s 2014-07-05 17:25:03.634: [ RACG][2540928256] [26040][2540928256][ora.XXdb1.vip]: clsrcrundetach: scls_process_spawn() error, status = 1, command = /home/oracle/product/10.2.0/crs/bin/racgmain Category: 1234 Operation: scls_canexec Location: Other: no exe permission, file /home/oracle/product/10.2.0/crs/bin/racgmain OS Error: Error 0 |
從vip log中,又發現,最少存在有對racgeut、racgmain兩個檔案沒有執行許可權
7、賦予更多的許可權解決
看來不止止是一兩個檔案不具有許可權了,為了儘快解決問題,決定對/home/oracle/product/10.2.0/crs/bin/*都主賦予執行許可權,對極對/home/oracle/product/10.2.0/crs/bin/racg*的擁有者改更改成root使用者:
#chmod o=x /home/oracle/product/10.2.0/crs/bin/* #chown root /home/oracle/product/10.2.0/crs/bin/racg* |
到此再啟動vip,已可以正常啟動
本文作者:踩點,從事”系統架構、作業系統、存放裝置、資料庫、中介軟體、應用程式“六個層面系統性的效能最佳化工作
歡迎加入 系統效能最佳化專業群 ,共同探討效能最佳化技術。群號:258187244
我想問下對於Oracle RAC crs-vip漂移的問題
你這個有點奇怪,一般情況都是2個vip在一個節點上,你這裡的情況是2個vip的位置互換了。
雖然根據你提供的資訊還不能判斷為什麼會這樣,但是你可以試試crs_stop和crs_start命令,關閉vip再在正確的節點上重啟vip資源。然後應該就可以啟動監聽了。