Thread: How to capture client machine IP address from Oracle 10g application server?

Hi,

I want to capture ip address of the machines, that are logging into my oracle 10g application.
I tried with SYS_CONTEXT, UTL_INADDR but these two are giving application ip and database server ip. But I want the local machine ip in which this application is being used.

Please help me ASAP with the solution.

Thanks.

select sys_context('USERENV', 'HOST') from dual

But if I am using this statement.. in application it is giving me the ip of application not of the local machine.

try to use TOAD or PLSQL DEVELOPER ,that will give you the complete list of users connencted to the database

Thanks Debasis.

I have tried this in database tools, its returning system ip. But when I use this particular statement in FORMs and trying to capture the value it is returning Application Server IP.

Now exactly the scenario is: I have a login form. So I want to know the system ip address whoever the user is logging into that application. So I am inserting the ip address into a table from the successfully loged in users. But instead of giving machine/system ip application ip is getting inserted.

Hope this clarifies my question!

Can anyone give any other solution in this regard ?

@Yajnas,

Query to retrieve remote client IP adress and local client IP adress.

Code:

select utl_inaddr.get_host_address(host_name), host_name from v$instance;

Query to retrieve server ip address

Code:

select sys_context( 'userenv', 'ip_address' ) from dual

It will return null if the user is not using TCP/IP

But its not working inside a Form builder. Its replying the server ip only.

Thank You all of you for your valuable suggetions.

I got the solution by attaching Webutil.pll and Webutil.olb in my form. WEBUTIL_CLIENTINFO.GET_HOST_NAME, WEBUTIL_CLIENTINFO.GET_IP_ADDRESS are the functions which returns client machine name and IP address in application server.

what is difference between oracle apps and oracle and oracle9i

You need to understand what is Oracle first, go and read some books to understand the basic stuff.

Hi,

Oracle - It is the Software who provides you the facility to use database as Oracle9i, 10g (These are the different versions of Oracle database).

Oracle Apps: Oracle provided frontend development tool/server application through which you can develop your business logics by connecting to any database versions.

use this command to capture ip address

select sys_context( 'userenv', 'ip_address' ) from dual

Originally Posted by Yajnas

Thank You all of you for your valuable suggetions.

I got the solution by attaching Webutil.pll and Webutil.olb in my form. WEBUTIL_CLIENTINFO.GET_HOST_NAME, WEBUTIL_CLIENTINFO.GET_IP_ADDRESS are the functions which returns client machine name and IP address in application server.

Hi Yajnas

I also facing the same problem. can you kindly inbox me the webutils and demo form.if possible else knidly guide me how to get rid of this problem.

Regards