Re: Client session IP address

From: Mark Bole <makbo_at_pacbell.net>
Date: Fri, 25 Feb 2005 15:18:12 GMT
Message-ID: <UkHTd.9294$Pz7.8924@newssvr13.news.prodigy.com>

DA Morgan wrote:

> Irudaya Raj wrote:
> 

>> Hello Everybody,
>> I have a need to know what is the source IP address of every session
>> that gets created on my Oracle 9i instance.
>> I have queried the v$session view, it does show a 'MACHINE' name for
>> users who have connected from apps. like SQLPLUS, but there are
>> connections comming in from JDBC client, Web Servlets,etc., these
>> connections are shown under 'MACHINE' column as the application name
>> itself.
>> But I need to know the IP address from where this application was run.
>>

[...]

> 
> http://www.psoug.org
> click on Morgan's Library
> click on SYS_CONTEXT Function
> 
> Hoepfully you are not working with Windows.

What's the issue with Windows? (the PSOUG web page you reference doesn't say).

To the OP: the listener log file will show you the source IP address for JDBC client connections, although it is not always possible to correlate this to specific sessions in the database -- sometimes you can match them up by timestamp if connections are infrequent enough.

-Mark Bole Received on Fri Feb 25 2005 - 09:18:12 CST