Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    32

    Unanswered: How to retrieve the IP for Oracle databse?

    Many thanks in advance.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Check this out:
    http://tinyurl.com/6d5eo2k

    (first link)

  3. #3
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57
    Code:
    SELECT 
    sys_context('USERENV', 'CURRENT_SCHEMAID') as SCHEMA_ID, 
    sys_context('USERENV', 'CURRENT_SCHEMA') AS SCHEMA_NAME ,
    sys_context('USERENV', 'DB_NAME') AS DB_NAME,
    sys_context('USERENV', 'HOST') AS HOST_NAME,
    sys_context('USERENV', 'OS_USER') AS CURRENT_USER,
    sys_context('USERENV', 'IP_ADDRESS') AS CURRENT_USER,
    sys_context('USERENV', 'SERVER_HOST') AS CURRENT_USER
    FROM DUAL;
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •