AIX

1)We have 2 node cluster RAC on AIX:

Code:

->test1
->test3

2) After rebooting server both the node sequentailly, we are getting below error from errpt command :

Code:

# errpt |more
IDENTIFIER TIMESTAMP  T C RESOURCE_NAME  DESCRIPTION
FE2DEE00   0901223914 P S SYSXAIXIF      DUPLICATE IP ADDRESS DETECTED IN THE NET

**********************

Code:

#errpt -a -j FE2DEE00

LABEL:          AIXIF_ARP_DUP_ADDR
IDENTIFIER:     FE2DEE00

Date/Time:       Mon Sep  1 22:38:48 GMT+08:00 2014
Sequence Number: 373934
Machine Id:      00C4162F4C00
Node Id:         infra-test1
Class:           S
Type:            PERM
WPAR:            Global
Resource Name:   SYSXAIXIF

Description
DUPLICATE IP ADDRESS DETECTED IN THE NET

Failure Causes
ARP RESPONSE RECEIVED FOR MY IP ADDRESS

        Recommended Actions
        CONTACT NETWORK ADMINISTRATOR

Detail Data
DUPLICATE IP ADDRESS
0ACD 330E
MAC ADDRESS
0015 1778 65D8
*****************

-> We checked the IP address and mac address from errpt output with network team:

Detail Data
DUPLICATE IP ADDRESS
0ACD 330E
MAC ADDRESS
0015 1778 65D8

->Another window sql server (sql01 and sql03 server and their instaces) are using the mac address 0015 1778 65D8.

->I checked with Windows team, they checked the all IP used by sql01 and sql03 server as well as instaces. But I can't see any if the IP as well as VIP is same as my AIX server IP & VIP.

->Kindly advice and help what I sholud look for finding root cause as well as resolve it.

->It is impacting production database as well as causing slowness issue to database.

Thanks & Regards,

---------- Post updated 09-02-14 at 01:41 AM ---------- Previous update was 09-01-14 at 10:50 PM ----------

Hi All,

Kindly reply to this issue as it is a production one. Our database faing slowness issue.

It means what it says. You have a duplicate IP address somewhere in your environment. Isolate network segments and trace is the only solution.

Hi fpmurph,

For thanks for your reply and information.

you are correct. In our network, two server were having same MAC address (as mentioned in my previous post).

Below are the steps that we performed to resolve the issue:

->First network admin disable the port that is used by sql01 for MAC(all actiivty performed on one server at one time).

->Then we checked for duplicate error in Test01 server and test03 server.

->Error were not coming.

->Once n/w team enable the port again on sql01 server, then we again start recieving the same error on both sever.

->We tried to reboot both sql01 and sql03 server. But after when sql server comeup, error was still these.

->This time network admin tried to clear the ARP table for specific MAC address and we rebooted the sql01 server.

->View the errpt log in test01 server. Now we were not receiving "Duplicate IP detacted in net".

->Same step we followed for othese sql03 server and after another AIX server(test03) also was not receing error in errpt command.

->We check with our network team for reasoning.

->According to them, there was no issue with switch becuase switch only use to contain server MAC ans related IP address.

->That is the window server(sql01 and sql03 server) that was causing issue by generating same MAC address as AIX server.

->Still I am not sure about the reason which cause the sql machine to generate same MAC address.

->Last weekend window team did patching on Window server.

->Now our database and application are running fine.

Request you to all folks, if any one know baot the reason how window server can generate same MAC address as other machine or what are the situation, where this situation occure. Kindly update on this post.

Thnaks & Regards,