Results 1 to 15 of 15

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

  1. #1
    Junior Member
    Join Date
    Apr 2007
    Answers
    16

    Exclamation 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.


  2. #2
    Junior Member
    Join Date
    Aug 2009
    Answers
    1

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

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


  3. #3
    Junior Member
    Join Date
    Apr 2007
    Answers
    16

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

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


  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

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

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


  5. #5
    Junior Member
    Join Date
    Apr 2007
    Answers
    16

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

    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!


  6. #6
    Junior Member
    Join Date
    Apr 2007
    Answers
    16

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

    Can anyone give any other solution in this regard ?


  7. #7
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

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

    Use this

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

    Sireesha

  8. #8
    Contributing Member
    Join Date
    Dec 2008
    Answers
    76

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

    @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


  9. #9
    Junior Member
    Join Date
    Apr 2007
    Answers
    16

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

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


  10. #10
    Junior Member
    Join Date
    Apr 2007
    Answers
    16

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

    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.




  11. #11
    Junior Member
    Join Date
    Aug 2009
    Answers
    1

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

    what is difference between oracle apps and oracle and oracle9i


  12. #12
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

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

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


  13. #13
    Junior Member
    Join Date
    Apr 2007
    Answers
    16

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

    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.




  14. #14
    Junior Member
    Join Date
    Oct 2008
    Answers
    28

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

    use this command to capture ip address

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


  15. #15
    Junior Member
    Join Date
    Mar 2017
    Answers
    1

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

    Quote Originally Posted by Yajnas View Post
    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


  16.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact