Thursday, 8 December 2011

crs-0223: resource 'ora.racN.resource" has placement in RAC 10gr2

This error usually happens when Oracle Clusterware and Oracle Database software are in version 10.2.0.1 or 10.2.0.2.  There are 2 ways to fix this issue:
  1. Upgrade the current Oracle Clusterware and Oracle Database software to the lastest version (10.2.0.5 or 11G). This way takes time and has to consider some other aspects.
  2. Temporarily fix by using manual commands.
In this article I will use the second method to fix this issue:
  • Firstly, check current CRS as well as other Cluster services using the following command            
                        $ crs_stat -l
  • List all services with status OFFLINE and UNKNOWN
  • Shutdown these services and clear their status with command
                        $ crs_stop -f   "service_name"
replace "service_name" with name of service which has been listed with status OFFLINE and UNKNOWN
  • restart all these services with command
                        $ crs_start "service_name"
  • Check status of these services again