My Oracle Support Banner

Oracle Access Manager 12c (OAM 12.2.1.3) IAU Audit Database Storing IP Addresses as Long Numbers (Doc ID 2491239.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Oracle Platform Security for Java - Version 12.2.1.3.0 and later
Oracle Access Manager - Version 12.2.1.3.0 and later
Information in this document applies to any platform.
Oracle is not responsible for instructions/information from 3rd party sites that may be contained in this KM note.

Symptoms

Oracle Access Manager 12c (OAM 12.2.1.3) IAU Audit Database Storing IP Addresses as Long Numbers

Using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

IAU Audit database storing IP addresses as long numbers

In 12c Audit database table the values in IAU_REMOTEIP are either very long numbers or what appear to be hexadecimal values.
Expecting instead for these values to be the IP address of the client generating the incoming request.

Example:

logging into a protected OAM application generates a row in the IAU table where the IAU_REMOTEIP is <VALUE>.
Expected it to show something like <IP_ADDRESS>



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.