Home » Server Options » RAC & Failsafe » SRVCTL status show offline even sevice is up
SRVCTL status show offline even sevice is up [message #399830] Fri, 24 April 2009 04:23 Go to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
Hi,

I have a 3 nodes RAC and creating a new service to allow user to connect only the first 2 nodes.

I have created a new service called 2-NODES.test.com
by altering below parameters.

ALTER SYSTEM SET service_names='123.test.com','2-NODES' SCOPE=BOTH SID='Nodes-1';
ALTER SYSTEM SET service_names='123.test.com','2-NODES' SCOPE=BOTH SID='Node-2';

i have no problem perform the crs_stop -all and crs-start -all where all service started back normally. my problem start happen when i perform the srvctl stop/start. after I performed stop and start back. the instance in the CRS_STAT is ok but the service (123P.test.com)is offline when check crs_stat. And the funny thing is that my service is up (2-NODES.test.com) when i check the lsnrctl status . any idea why?

1. srvctl stop database -d 123
2. srvctl start database -d 123
3. crs_stat -t :all online except
NAME=ora.123.2-NODES.Nodes-1.srv
NAME=ora.123.2-NODES.Nodes-2.srv
NAME=ora.123.2-NODES.cs
Re: SRVCTL status show offline even sevice is up [message #399831 is a reply to message #399830] Fri, 24 April 2009 04:26 Go to previous messageGo to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
when i manully startup below 3 offline, it can online back.

NAME=ora.123.2-NODES.Nodes-1.srv
NAME=ora.123.2-NODES.Nodes-2.srv
NAME=ora.123.2-NODES.cs

do i need to add or modify something so it can online automatically?
Re: SRVCTL status show offline even sevice is up [message #401120 is a reply to message #399830] Fri, 01 May 2009 12:56 Go to previous message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
win3vin wrote on Fri, 24 April 2009 14:53
Hi,

I have created a new service called 2-NODES.test.com
by altering below parameters.

ALTER SYSTEM SET service_names='123.test.com','2-NODES' SCOPE=BOTH SID='Nodes-1';
ALTER SYSTEM SET service_names='123.test.com','2-NODES' SCOPE=BOTH SID='Node-2';





^^^^
Firstly this way of adding services is wrong.

You need to add this via the srvctl add service command. This way the Clusterware and the Instance registration of the service takes place properly.

Via the srvctl command information also gets added to OCR.
I am not sure currently in which state your services are...but they surely seem to be running wierdly because of the wrong way in which you added them.


Please use the srvctl commands to add the services.

Thx.
Previous Topic: Understanding Local and Remote Listener.
Next Topic: Oracle RAC with Sun Cluster 3.2 and shared QFS
Goto Forum:
  


Current Time: Thu Mar 28 15:35:13 CDT 2024