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 JUNE 26, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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:
SKGXP: ospid 17080: network interface query failed for IP address 169.254.xx.xxx.
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.xx.xxx 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.xx.xxx' 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.xx.0'
There was no errors reported in the OS log nor a high workload on the machine.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |