Thursday, April 22, 2010

CRS-1006 : No more members to consider

When trying to start a service that in crs_stat -t seems offline.

ora.DB.MYSRV.DB1.srv ONLINE OFFLINE on node1

Trying to stop the service saids that the service is stopped.
Trying to remove the service saids that the service is running.

The you have to stop the service manually from each instance.

On each instance do.

sqlplus / as sysdba
show parameter service

-- If you see you service listed there then do

exec DBMS_SERVICE.STOP_SERVICE('MYSERVICE','MYINSTANCE');

show parameter service

-- The service must have been disappeared now.

After you complete the following procedure then start the service again on the preferred instance.


References

http://forums.oracle.com/forums/thread.jspa?messageID=3626152
http://surachartopun.com/2009/03/srvctl-start-service-prkp-1030-failed.html

Thursday, April 15, 2010

11g new features Articles

A very nice collection of Articles for the 11g new features in ORACLE-BASE.

http://www.oracle-base.com/articles/11g/Articles11g.php