Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IP Address of Client

657837Apr 21 2010 — edited Jan 29 2013
Hi All,

I have forms and reports application running on 10g database. Users get access to application through Application Server 10g . I have a requirement to know the IP address of my clients machines.

But if i fire select osuser,machine from v$session where program ='frmweb.exe' I get the following output. Can anybody here suggest me how to get IP address of a particular client.

SQL> select osuser,machine from v$session where program ='frmweb.exe';

OSUSER MACHINE
------------------------------ ----------------------------------------------------------------
NT AUTHORITY\ANONYMOUS LOGON GIDC\GIDC-APP1
NT AUTHORITY\ANONYMOUS LOGON GIDC\GIDC-APP1
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2013
Added on Apr 21 2010
14 comments
8,605 views