Friday, March 4, 2011

Adding Services to CRS stack in RAC

I was trying to add RAC database  services to the CRS stack after the RAC database has been built. I was getting the  following errors:

au11qapeo0tels2:RACDB2:/opt/app/crs/oracle/product/11.1.0/crs/bin>srvctl add service -d RACDB -s RACBD2 -r RACDB2 -a RACDB2 -P none
PRKP-1087 : RACDB2 is specified as both preferred and available instance lists for service RACDB2

Assumptions for adding the services
--------------------------------------------
RAC database: RACDB
Instances : RACDB1, RACDB2

Service_name : RACDB1 and RACDB2

Service RACDB1 will be running on only instance : RACDB1

Service RACDB2 will be running on only instance : RACDB2

Solution:
I Have ran using the following commands and it worked:
srvctl add service -d RACDB -s RACDB2 -r RACDB2 -P none

srvctl start service -d RACDB -s RACDB1 -i RACDB1
srvctl start service -d RACDB -s RACDB2 -i RACDB2

HA Resource Target State
----------- ------ -----
ebr_vip1 ONLINE ONLINE on node2
ora.RACDB.RACDB1.RACDB1.srv ONLINE ONLINE on node1
ora.RACDB.RACDB1.cs ONLINE ONLINE on node1
ora.RACDB.RACDB1.inst ONLINE ONLINE on node1
ora.RACDB.RACDB2.RACDB2.srv ONLINE ONLINE on node2
ora.RACDB.RACDB2.cs ONLINE ONLINE on node2
ora.RACDB.RACDB2.inst ONLINE ONLINE on node2
ora.RACDB.db ONLINE ONLINE on node1
ora.node1.LISTENER_node1.lsnr ONLINE ONLINE on node1
ora.node1.gsd ONLINE ONLINE on node1
ora.node1.ons ONLINE ONLINE on node1
ora.node1.vip ONLINE ONLINE on node1
ora.node2.LISTENER_node2.lsnr ONLINE ONLINE on node2
ora.node2.gsd ONLINE ONLINE on node2
ora.node2.ons ONLINE ONLINE on node2
ora.node2.vip ONLINE ONLINE on node2


node1:RACDB1:/opt/app/crs/oracle/product/11.1.0/crs/bin>srvctl status service -d RACDB
Service RACDB1 is running on instance(s) RACDB1
Service RACDB2 is running on instance(s) RACDB2

No comments:

Post a Comment