Ip Address In Sys_context('Userenv','Ip_address') Has Leading Zeroes Removed

(Doc ID 370297.1)

Last updated on APRIL 24, 2017

Applies to:

Operating System Dependent Interface - Version: to - Release: 10.1 to
Operating System Dependent Interface - Version: to   [Release: 10.1 to ]
IBM z/OS on System z
IBM z/OS (OS/390)
Listener Service joblog on zOS



In previous releases the IP address contained zeros. After upgrade from to the zeros are truncated. So it gives the correct IP-Adress now.

The net log shows the zeroes included.

JOBLOG from Netservice  (same in 10.1.* , 10.2.* , 9.2.*) :
MIN0733I Socket 0000 connected Subtask Kid1, IP
MIN0742I Socket 0000 closed Subtask Kid1, IP
-----> Ip addresses are not displayed correctly . The correct IP-Address would be

Connect to :
SYS_CONTEXT('USERENV','IP_ADDRESS')         ----> this the correct decimal address
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release

SQL> Connected. (to
SYS_CONTEXT('USERENV','IP_ADDRESS')      ----->  this is not  correct decimal address - correct is would be


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