Starting VIP reports CRS-1028/CRS-0223 causes VIP status to UNKNOWN Fault Analysis and Resolution, crs-1028crs-0223

Source: Internet
Author: User

Starting VIP reports CRS-1028/CRS-0223 causes VIP status to UNKNOWN Fault Analysis and Resolution, crs-1028crs-0223

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



Question about Oracle RAC crs-vip drift

This is a bit strange to you. Generally, two VIPs are on one node. Here, the positions of the two VIPs are changed.
Although you still cannot determine why this is the case based on your information, you can try the crs_stop and crs_start commands to disable vip and restart vip resources on the correct node. Then you can start the listener.


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.