SRVCTL status show offline even sevice is up [message #399830] |
Fri, 24 April 2009 04:23  |
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 #401120 is a reply to message #399830] |
Fri, 01 May 2009 12:56  |
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.
|
|
|