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 Monday, June 17, 2013 7:14 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 one got an answer..
Post #1464131
Posted Monday, June 17, 2013 9:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:50 AM
Points: 2,262, Visits: 2,725
please provide an update of all actions you have done since the last post:
- have you checked if perhaps the IP-address is allready in use?
- have you rebooted (if business permits you) one or more cluster nodes?
- have you deleted and re-created the IP-address cluster resouce?


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1464206
Posted Monday, June 17, 2013 9:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:50 AM
Points: 2,262, Visits: 2,725
rajborntodare (6/11/2013)
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


Your remark one gets pinged but i can not bring that online. indicates the IP-address is allready in use by another resource (server/PC/network device). An IP-address has to be unique within a network and can only be assigned to one single device. Check which device is currently using the IP-address (PING -a www.xxx.yyy.zzz or NSLOOKUP) and assign this device another IP-address or assign a different IP-address to the cluster resource of SQL. Make sure the DNS matches all changes in IP-addresses.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1464208
Posted Monday, June 17, 2013 9:26 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
I have tried bringing it online manually,

I have tried by rebooting both the primary servers i have,

they are assigned to the particular applications.

They are manual assigned IP's not DHCP.

i havent tried in deleting and creating new one because i am not much familiar with that work.

My manager said he gonna get ilo permission and then do check the current IP address mentioned.

While checking Ipconfig /all in CMD i havent seen any of the IP address which are offline.

But in wonder one among them does respond to the ping. but when i tried to bring it online it fails.

If you do not get a picture. I can explain everything....AGAIN....
Post #1464212
Posted Monday, June 17, 2013 9:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:15 PM
Points: 12,910, Visits: 32,018
you didn't mention if you followed HanShi's advice about pinging all the ip addresses you think you want to use for your cluster; it really does sound like somethign has already been manually assigned the IP address you think you want to use.

ping 10.0.1.155 or whatever the IP address is;


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1464215
Posted Monday, June 17, 2013 9:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:45 AM
Points: 275, Visits: 863
If the resource is not on line and it responds to a ping, then it is likely being used by something else.

Run nslookup and tracert for the IP. It may give you something useful.
Post #1464219
Posted Monday, June 17, 2013 9:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:50 AM
Points: 2,262, Visits: 2,725
rajborntodare (6/17/2013)
one among them does respond to the ping. but when i tried to bring it online it fails.

If you can ping the IP-address without the corresponding cluster resource being online, this indicates the IP-address is allready in use by another device. Try the following commands (from the commandprompt) to retrieve the name of the device currently using the IP-address:
ping -a {ip-address}
nslookup {ip-address}
When the IP-address is currently in use (you can ping it) it will NOT be possible to bring the IP-cluster resource online. Only when the IP-address fails to be pinged you can bring the cluster resource online.
Shut down the device currently using the IP-address and then you can bring the cluster resource online.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1464221
Posted Monday, June 17, 2013 9: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
Guys,

It gave me some information..

The IP which pings gave the device name on which it got assigned is the same application,

BUT showing offline
Post #1464225
Posted Monday, June 17, 2013 9:53 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
[quote]HanShi (6/17/2013)
[quote]rajborntodare (6/17/2013)

nslookup {ip-address}


on using this command, among 4 3 show non-exixtent domain

only one show the application name as i said in earlier post


rookie here
Post #1464232
Posted Monday, June 17, 2013 10:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 6,306, Visits: 13,605
With the clustered ip resource offline try an RDP connection to the IP address

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1464241
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse