CRS-1006: No more members to consider

I had an error which i would call weird cause i couldn’t understand it :). I was asked to start 2-Node 10.2.0.5 RAC db and its services. Interestingly received the below error while starting the service –

ora.test_abc.test.abc.example.com.cs       OFFLINE    OFFLINE
ora.test_abc.test.abc.example.com.test1.srv OFFLINE    OFFLINE
ora.test_abc.test.abc.example.com.test2.srv OFFLINE    OFFLINE

$ srvctl start service -d test_abc -s test.abc.example.com
PRKP-1030 : Failed to start the service test.abc.example.com.
CRS-1006: No more members to consider
CRS-0215: Could not start resource 'ora.test_abc.test.abc.example.com.cs'.

Confused with what the error is, checked the crsd log –

2011-08-29 07:44:58.058: [  CRSRES][1093970240]0Attempting to start `ora.test_abc.test.abc.example.com.cs` on member `xyz0101`
2011-08-29 07:44:58.314: [  CRSRES][1554225472]0startRunnable: setting CLI values
2011-08-29 07:44:58.372: [  CRSRES][1554225472]0Attempting to start `ora.test_abc.test.abc.example.com.test1.srv` on member `xyz0101`
2011-08-29 07:44:58.414: [  CRSRES][1096751424]0Attempting to start `ora.test_abc.test.abc.example.com.test2.srv` on member `xyz0102`
2011-08-29 07:44:58.598: [  CRSAPP][1554225472]0StartResource error for ora.test_abc.test.abc.example.com.test1.srv error code = 1
2011-08-29 07:44:58.663: [  CRSRES][1554225472]0Start of `ora.test_abc.test.abc.example.com.test1.srv` on member `xyz0101` failed.
2011-08-29 07:44:58.690: [  CRSRES][1554225472]0startRunnable: setting CLI values
2011-08-29 07:44:58.699: [  CRSRES][1554225472]0Attempting to start `ora.test_abc.test.abc.example.com.test1.srv` on member `xyz0101`
2011-08-29 07:44:58.715: [  CRSRES][1096751424]0Start of `ora.test_abc.test.abc.example.com.test2.srv` on member `xyz0102` failed.
2011-08-29 07:44:58.718: [ COMMCRS][1484966208]clsc_receive: (0x160fb2b0) error 2
2011-08-29 07:44:58.764: [  CRSAPP][1554225472]0StartResource error for ora.test_abc.test.abc.example.com.test1.srv error code = 1
2011-08-29 07:44:58.777: [  CRSRES][1096751424]0Attempting to start `ora.test_abc.test.abc.example.com.test2.srv` on member `xyz0102`
2011-08-29 07:44:58.836: [  CRSRES][1554225472]0Start of `ora.test_abc.test.abc.example.com.test1.srv` on member `xyz0101` failed.
2011-08-29 07:44:58.843: [  CRSRES][1554225472]0xyz0102 : CRS-1019: Resource ora.test_abc.test.abc.example.com.test1.srv (application) cannot run on xyz0102
2011-08-29 07:44:58.911: [  CRSRES][1096751424]0Start of `ora.test_abc.test.abc.example.com.test2.srv` on member `xyz0102` failed.
2011-08-29 07:44:58.918: [  CRSRES][1096751424]0xyz0101 : CRS-1019: Resource ora.test_abc.test.abc.example.com.test2.srv (application) cannot run on xyz0101
2011-08-29 07:44:59.147: [  CRSAPP][1093970240]0StartResource error for ora.test_abc.test.abc.example.com.cs error code = 1
2011-08-29 07:44:59.212: [  CRSRES][1093970240]0Start of `ora.test_abc.test.abc.example.com.cs` on member `xyz0101` failed.
2011-08-29 07:44:59.263: [  CRSRES][1093970240]0Attempting to start `ora.test_abc.test.abc.example.com.cs` on member `xyz0102`
2011-08-29 07:44:59.410: [  CRSRES][1539533120]0startRunnable: setting CLI values
2011-08-29 07:44:59.484: [  CRSAPP][1539533120]0StartResource error for ora.test_abc.test.abc.example.com.test1.srv error code = 1
2011-08-29 07:44:59.685: [  CRSRES][1539533120]0startRunnable: setting CLI values
2011-08-29 07:44:59.758: [  CRSAPP][1539533120]0StartResource error for ora.test_abc.test.abc.example.com.test1.srv error code = 1
2011-08-29 07:45:00.007: [  CRSRES][1093970240]0Start of `ora.test_abc.test.abc.example.com.cs` on member `xyz0102` failed.
2011-08-29 07:45:00.014: [  CRSRES][1093970240]0CRS-1006: No more members to consider

Lets check the view v$active_services.It displays the active services in the database.So as per view the service is active/running on the database

SYS@test1>; select inst_id,name,blocked from gv$active_services where name like 'TEST%';

   INST_ID NAME                                     BLO
---------- ---------------------------------------- ---
         1 TEST.abc.example.com                    NO
         2 TEST.abc.example.com                    NO

Now the CRS state showed target as Online but state as offline

ora.test_abc.test.abc.example.com.cs       ONLINE     OFFLINE
ora.test_abc.test.abc.example.com.test1.srv ONLINE     OFFLINE
ora.test_abc.test.abc.example.com.test2.srv ONLINE     OFFLINE

$ srvctl stop service -d test_abc -s test.abc.example.com
PRKP-1063 : Service test.abc.example.com is already stopped.

$ srvctl start  service -d test_abc -s test.abc.example.com
PRKP-1030 : Failed to start the service test.abc.example.com.
CRS-1006: No more members to consider
CRS-0215: Could not start resource 'ora.test_abc.test.abc.example.com.cs'.

To resolve the issue, stopped the services using dbms_service on both the nodes

SYS@test1> exec DBMS_SERVICE.STOP_SERVICE('TEST.abc.example.com');

PL/SQL procedure successfully completed.

SYS@test2> exec DBMS_SERVICE.STOP_SERVICE('TEST.abc.example.com');

PL/SQL procedure successfully completed.

SYS@test1> select inst_id,name,blocked from gv$active_services where name like 'TEST%';

no rows selected

Now the service got started without any issue 🙂

$ srvctl start  service -d test_abc -s test.abc.example.com

ora.test_abc.test.abc.example.com.cs       ONLINE     ONLINE on xyz0101
ora.test_abc.test.abc.example.com.test1.srv ONLINE     ONLINE on xyz0101
ora.test_abc.test.abc.example.com.test2.srv ONLINE     ONLINE on xyz0102

Advertisements

2 thoughts on “CRS-1006: No more members to consider

    1. Using the srvctl stop service command , failed with service is already stopped. Correct me if i am wrong, but as far as i know if we create the service using dbms_services it wouldn’t be registered to OCR.So, i am still not sure why i got that error and why was it showing in v$active_services.

      Anand

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s