SKGXP: ospid nnn: network interface query failed for IP address 169.254.nn.nn When there's no network issue (Doc ID 2089284.1)

Last updated on APRIL 11, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.

Symptoms

Database/ASM alert log file shows errors stating the HAIP IP address is not available:  

Sat Nov 21 05:13:02 2015
SKGXP: ospid 17080: network interface query failed for IP address 169.254.70.200.
SKGXP: [error 0]
Sat Nov 21 05:13:19 2015
Errors in file
<PATH>/trace/INST1_ora_24995.trc
(incident=20481):
ORA-00603: ORACLE server session terminated by fatal error
ORA-27544: Failed to map memory region for export
ORA-27300: OS system dependent operation:bind failed with status: 126
ORA-27301: OS failure message: Cannot assign requested address
ORA-27302: failure occurred at: sskgxpsock
Incident details in:
<PATH>/incdir_20481/INTS1_ora_24995_i20481.trc

  

orarootagent log shows the check action failed on the HAIP IP address and the IP was removed 

...

2015-11-21 05:12:52.288791 : USRTHRD:33: {0:17:2} Failed to check169.254.74.200 on igb4
2015-11-21 05:12:52.289087 : USRTHRD:33: {0:17:2} (null) category: 0, operation: , loc: , OS error: 0, other:
...
2015-11-21 05:13:00.493066 : USRTHRD:34: {0:17:2} NetInterface::sStopIp }
2015-11-21 05:13:00.493127 : USRTHRD:34: {0:17:2} VipActions::stopIp }
2015-11-21 05:13:00.493278 : USRTHRD:34: {0:17:2} thread shutdown
2015-11-21 05:13:00.493308 : USRTHRD:34: {0:17:2} thread shutdown
2015-11-21 05:13:00.493385 : USRTHRD:34: {0:17:2} VipActions::startIp {
2015-11-21 05:13:00.493498 : USRTHRD:33: {0:17:2} HAIP:  CleanDeadThreads -i, '169.254.74.200'  inf 'igb8'
2015-11-21 05:13:00.493543 : USRTHRD:33: {0:17:2} Thread:[NetHAWork] stop {
2015-11-21 05:13:00.493575 : USRTHRD:33: {0:17:2} Thread:[NetHAWork] Thread stop:thread acquire lock:203bcb0
2015-11-21 05:13:00.493604 : USRTHRD:33: {0:17:2} Thread:[NetHAWork] Thread stop:thread join pThnd:1ffdba8
2015-11-21 05:13:00.494337 : USRTHRD:20: {0:17:2} HAIP: assigned ip '169.254.26.0'

  

There was no errors reported in the OS log nor a high workload on the machine.

 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms