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

Yajnas · #1 (**permalink**) 08-11-2009

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.

raj_betfair · #2 (**permalink**) 08-11-2009

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

Yajnas · #3 (**permalink**) 08-11-2009

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

debasisdas · #4 (**permalink**) 08-11-2009

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

Yajnas · #5 (**permalink**) 08-11-2009

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!

Yajnas · #6 (**permalink**) 08-25-2009

Can anyone give any other solution in this regard ?

susarlasireesha · #7 (**permalink**) 08-25-2009

Use this

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

ecearund · #8 (**permalink**) 08-25-2009

@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

Yajnas · #9 (**permalink**) 08-27-2009

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

Yajnas · #10 (**permalink**) 08-28-2009

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.

h.sallahuddin · #11 (**permalink**) 08-30-2009

what is difference between oracle apps and oracle and oracle9i

debasisdas · #12 (**permalink**) 08-30-2009

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

Yajnas · #13 (**permalink**) 08-31-2009

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.

nehrumosuru · #14 (**permalink**) 5 Days Ago

use this command to capture ip address

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to test client server application load?	unique_uni2000	Testing Issues	2	02-05-2009 07:13 AM
Web Service and Client Server Application	saravananistqb	Testing Issues	0	01-06-2009 10:04 AM
client server application	hitesh_shah19	Web Testing	1	10-07-2008 08:40 AM
client server application	hitesh_shah19	Web Testing	3	09-04-2008 08:10 PM
Client server application	balajip82	LoadRunner	1	04-29-2008 06:56 PM

The Following User Says Thank You to raj_betfair For This Useful Post:
Yajnas

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

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

Similar Threads