Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

IP Address Doesnt turn from offline to online Expand / Collapse
Author
Message
Posted Friday, June 07, 2013 11:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501


Hi I got a problem, I think it is a little bit weird kind of problem, I haven't find anything regarding this issue;

An error was logged in the Cluster and Event Log, saying Event ID:1609
Error:0x80071397 "The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"

i have done all need to be done, but couldnot get the IP address online manually.

its a 4 node cluster, 2 acts as primary and other 2 as secondrary,

We have 5 applications over 4 depends on one node of primary and the left one on the other node.
Rest two nodes remain as DR in case of failover.


there are 2 IP Address for each node. In which one always remain online, the never respond to PING atleast, but one of them does respond but never comes online on selecting the option "Bring thus resource to online"

How can i bring this IP address online. Please find all the work i have done on this issue.

As i found few sujjestion from friends and also google, i Tried all of them resulting no solution.

Suggestion 1: Restart the servers.

ATTEMPT 1: I have shifted all the application to node 2 from node1, Restarted the NOde 1, Done the same with the node 2;

Result: Nothing.

Suggestion 2: Try from all the nodes to bring the IP address online.
Attempt 2: Tried, no use. Not even one got turned in.

On pinging any of the IP Address except 1 does show timed out, the exceptional IP Address does respond, but i dont know why its not getting online when requested.

Suggestion 3: I found a post in some forum saying that, the IP Address from node which holds the quorum does only gets online, rest remain in offline.
Attempt 3: said to manager the same thing, he suggested me to work more on it.


Suggestion 4: Check subnet mask,
Attempt 4: Checked every Subnet mask, does remain similar. but i could never make those IP address online from offline.

BUT: when i was working on this matching the subnet masks; I found all the IP Address in different nodes, except the the IP's which i am not able to make them online, Including the one which got pinged success.

I found another thing over here, I check the IPconfiguration in all the nodes, pinged all the IP's in all the nodes, including IP's which are online,

The IP's which are shown online does ping in all the nodes (which is common)
But the IP's Which are offline doesnt ping with the nodes of Primary and
on pinging those on secondary nodes they doesnt reported as "timed out" but "Host not reachable"

Does this sign anything, i haven't found anything on this, when i searched.

When i report the same thing to my manager and try to involve Networking and Windows Admins in to it. He said gonna check it next monday..

I havent found perfect solution till now, i was working on this since 3 days, done a lot of googling, but could not find it any where.

Hope i gave all the details. If any one had already faced such kind of issue, Please expalin me wat need to be done, Also let me know am i in right path for the solution,

CAN ANY ONE HELP ME ON THIS...

Please note***ROOKIE*** here
Post #1461174
Posted Monday, June 10, 2013 4:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:08 AM
Points: 5,952, Visits: 12,830
rajborntodare (6/7/2013)
"The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"

Open the properties tab for the clustered IP address resource and go to the "Advanced Policies" tab. Ensure that any nodes are checked where you wish to bring the resource online.


rajborntodare (6/7/2013)
But the IP's Which are offline doesnt ping with the nodes of Primary and
on pinging those on secondary nodes they doesnt reported as "timed out" but "Host not reachable"

If a clustered IP address resource is offline then you won't be able to ping it!



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1461466
Posted Monday, June 10, 2013 12:02 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
Every Node has been checked as Possible owners,

even though, not resolved
Post #1461694
Posted Tuesday, June 11, 2013 1:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
Come on PROs Help me out guys.........

No one did face such situation yet?????????????
Post #1462352
Posted Tuesday, June 11, 2013 1:39 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
I agree with u but exactly happened is this

Out of 4 IP address from 4 different application,

one gets pinged but i can not bring that online.

other 3 doesn't ping
Post #1462355
Posted Tuesday, June 11, 2013 1:45 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:08 AM
Points: 5,952, Visits: 12,830
Check the event logs for further info as to why the resource will not come online.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1462356
Posted Tuesday, June 11, 2013 6:22 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:56 PM
Points: 237, Visits: 761

Is the P address already in use by another resource?
Post #1462430
Posted Wednesday, June 12, 2013 6:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
No! it is assigned for the particular application itself
Post #1462588
Posted Wednesday, June 12, 2013 6:42 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:59 AM
Points: 2,078, Visits: 2,410
It could be that the IP cluster resource is unable to determine which node of the cluster is the owner of the group. I'm not a Windows cluster administrator so I don't know how to resolve this nicely. When that happened we just rebooted one of the (2-node) cluster nodes.

Perheps it can be solved if you delete and re-create the IP-resource?


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1462598
Posted Wednesday, June 12, 2013 6:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
Nothing descriptive in Event Logs;

"Failover Cluster Manager failed while managing one or more cluster. The error was 'An error occurred while attempting to bring the resource 'SQLPRD02_Group1_10.56.56.205' online.'. For more information see the Failover Cluster Manager Diagnostic channel."

I have checked the Diagnostic channel... nothing descriptive than this info

Event ID: 4683
Post #1462599
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse