Starting VIP reports CRS-1028/CRS-0223 causes VIP status to UNKNOWN Fault Analysis and Solution

CRS version 10.2.0.41 and VIPState is UNKNOWN [root @ XXdb1 ~] # Crs_stat-tNameTypeTargetStateHost ------------------------------------------------------------ ora. dxp. dbapplicationONLINEONLINEXXdb1ora... p1.instapplicationONLINEONLIN

CRS version: 10.2.0.4 1. VIP State: UNKNOWN [root @ XXdb1 ~] # Crs_stat-t Name Type Target State Host ---------------------------------------------------------- ora. dxp. db application ONLINE XXdb1 ora... p1.inst application ONLINE ONLIN

CRS version 10.2.0.4

1. the VIP State is UNKNOWN.

[Root @ XXdb1 ~] # Crs_stat-t Name Type Target State Host ------------------------------------------------------------ Ora. dxp. db application ONLINE XXdb1 Ora... p1.inst application ONLINE XXdb1 Ora... p2.inst application ONLINE XXdb2 Ora... SM1.asm application ONLINE XXdb1 Ora... B1.lsnr application OFFLINE Ora. XXdb1.gsd application ONLINE XXdb1 Ora. XXdb1.ons application ONLINE XXdb1 Ora. XXdb1.vip application online unknown XXdb1 Ora... SM2.asm application ONLINE XXdb2 Ora... B2.lsnr application OFFLINE Ora. XXdb2.gsd application ONLINE XXdb2 Ora. XXdb2.ons application ONLINE XXdb2 Ora. XXdb2.vip application online unknown XXdb2 Ora. zsXXdb. db application ONLINE XXdb1 Ora... b1.inst application ONLINE XXdb1 Ora... b2.inst application ONLINE XXdb2

2. Manual VIP startup reports CRS-1028/CRS-0223 Error

[Root @ XXdb1 ~] # Crs_start ora. XXdb1.vip CRS-1028: Dependency analysis failed because: 'Resource in UNKNOWN state: ora. XXdb1.vip' CRS-0223: Resource 'ora. XXdb1.vip 'has placement error.

3. Analyze crsd logs

16:10:08. 813: [CRSAPP] [1524836704] 0 StartResource error for ora. XXdb1.vip error code =-1 16:10:08. 826: [CRSEVT] [1524836704] 0 CAAMonitorHandler: 0: cocould 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

It is found that on the operating system, the racgwrap file has no execution permission.

4. Grant O = x permissions to the racgwrap File

# Chmod o = x/home/oracle/product/10.2.0/crs/bin/racgwrap

5. Start VIP again. Other errors are reported in crsd.

16:26:05. 473: [CRSAPP] [1524836704] 0 StartResource error for ora. XXdb1.vip error code = 1

6. Analyze the vip log

Oracle Database 10g CRS Release 10.2.0.4.0 Production Copyright 1996,200 8 Oracle. All rights reserved. 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 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 17:25:03. 566: [RACG] [2540928256] [26035] [2540928256] [ora. XXdb1.vip]: end for resource = ora. XXdb1.vip, action = start, status = 1, time = 0.030 s 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

From the vip log, we found that at least two files, racgeut and racgmain, have no execution permissions.

7. grant more Permissions

It seems that more than one or two files do not have the permission. To solve the problem as soon as possible, we decided to grant the execution permission to/home/oracle/product/10.2.0/crs/bin, change the owner of/home/oracle/product/10.2.0/crs/bin/racg * to the root user:

# Chmod o = x/home/oracle/product/10.2.0/crs/bin /* # Chown root/home/oracle/product/10.2.0/crs/bin/racg *

Now start the vip instance. The vip instance can be started normally.

Author: stepping on, he is engaged in "system architecture, operating system, storage device, database, middleware, and application" system performance optimization.

Join the system performance optimization professional group to discuss performance optimization technologies. GROUP: 258187244