E-SEC: PSACCESSLOG Shows LOGIPADDRESS As "UNKNOWN" or "JavaClient" (Doc ID 1334041.1)

Goal

When does the LOGIPADDRESS in the PSACCESSLOG table show an entry of "Unknown" or "JavaClient? What causes this?

Also is there an enhancement request to resize the LOGIPADDRESS field of the PSACCESSLOG. This field contains the reverse DNS entry when available instead of the actual IP address. In a sample of the last 30 days of data approximately 27% of the values in that field are exactly 40 characters long which implies that a large number of those were truncated to fit in the field. Having the reverse DNS entry is nice but is subject to change and may not have a matching forward DNS entry.

Recommended enhancement

1. Create a second field for the Reverse DNS value when available. This field can be VARCHAR2(255) to accommodate most host names.
2. Store only the raw IP address in the LOGIPADDRESS field. 40 characters is sufficient to hold IPv4 and IPv6 addresses.

Solution

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