Production Issue in AIX Oracle RAC [errpt output : DUPLICATE IP ADDRESS DETECTED IN THE NET]
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.
Last edited by Franklin52; 09-01-2014 at 11:55 AM..
Reason: Please use code tags
I am setting this up on 5.3 and the problem is I cannot remember how to allocate two IP addresses to a NIC. I have setup an alias on EN0 but when I list it with ifconfig -a it still only shows 1 network address (after a reboot). I know there is something I must do but for the life of me cannot... (1 Reply)
Hello, system generated emails sent to users from production scripts within Aix arent going out. In the errpt -a output I see:
_______________________________________________________
LABEL: SRC_SVKO
IDENTIFIER: BC3BE5A3
Date/Time: Tue Mar 13 16:28:07 EDT 2012
Sequence... (2 Replies)
Discussion started by: NycUnxer
2 Replies
LEARN ABOUT LINUX
ndb_print_backup_file
NDB_PRINT_BACKUP_(1) MySQL Database System NDB_PRINT_BACKUP_(1)NAME
ndb_print_backup_file - print NDB backup file contents
SYNOPSIS
ndb_print_backup_file file_name
DESCRIPTION
ndb_print_backup_file obtains diagnostic information from a cluster backup file.
Usage
ndb_print_backup_file file_name
file_name is the name of a cluster backup file. This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup
directory. These files are found in the data node's backup directory under the subdirectory BACKUP-#, where # is the sequence number for
the backup. For more information about cluster backup files and their contents, see Section 17.5.3.1, "MySQL Cluster Backup Concepts".
Like ndb_print_schema_file and ndb_print_sys_file (and unlike most of the other NDB utilities that are intended to be run on a management
server host or to connect to a management server) ndb_print_backup_file must be run on a cluster data node, since it accesses the data node
file system directly. Because it does not make use of the management server, this utility can be used when the management server is not
running, and even when the cluster has been completely shut down.
Additional Options
None.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 NDB_PRINT_BACKUP_(1)
09-01-2014
Production Issue in AIX Oracle RAC [errpt output : DUPLICATE IP ADDRESS DETECTED IN THE NET]
