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:
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