Tuesday, October 03, 2006

Clearing UNKNOWN status of CRS resources

If you get the following errors whilst starting up nodeapps on a 10G RAC
cluster

bart-> srvctl start nodeapps -n bart
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.bart.gsd' has placement error.
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.bart.ons' has placement error.

Check the status of these resources.

bart-> ./ShowCRS | grep UNK
ora.bart.gsd ONLINE UNKNOWN on bart
ora.bart.ons ONLINE UNKNOWN on bart

To clear the state of the resource you have to use the force option
in the crs_stop command

bart-> crs_stop ora.bart.gsd -f
Attempting to stop `ora.bart.gsd` on member `bart`
Stop of `ora.bart.gsd` on member `bart` succeeded.


bart-> crs_stop ora.bart.ons -f
Attempting to stop `ora.bart.ons` on member `bart`
Stop of `ora.bart.ons` on member `bart` succeeded.

bart-> srvctl start nodeapps -n bart
bart-> ./ShowCRS | grep UNK

bart-> ./ShowCRS | grep bart
ora.bart.gsd ONLINE ONLINE on bart
ora.bart.ons ONLINE ONLINE on bart
ora.bart.vip ONLINE ONLINE on bart

ShowCRS is a shell script which is based on Metalink Note 259301.1

7 comments:

Anonymous said...

Nice blog you got, and I seem to have exactly this problem now. But where did you get ShowCRS?

Fairlie Rego said...

ShowCRS is a shell script which formats the crs_stat output.
When Oracle bought Compaq's clusterware it appears that the names of the commands been changed from caa_* to crs_*.
The script is from Metalink note
259301.1

Anonymous said...

Any idea what causes this in the first place? I'm running RAC with Veritas Storage Foundation, if that matters. I've had trouble starting instances with srvctl too, but a sqlplus startup works fine.

Anonymous said...

A nice article....I had exaclty same issue on Oracle 10gR2 on RHEL4 and it is resolved.

Keep it up
Thanks and Best Regards

Anonymous said...

Nice and short article...Solved my problem....Thanks

Anonymous said...

Very good command and helped me to resolve my issue.

Thanks
MN

Ambasa Subhas Ladwa said...

Nice Explaination.