6 Replies Latest reply: Jun 14, 2012 4:18 AM by 738125 RSS

    Get Server IP address in oracle 11g

    ganex27lin
      Hi,

      I want to find IP address of my oracle server(11g).
      SELECT UTL_INADDR.GET_HOST_ADDRESS IPAddress
      FROM dual
      When I execute the above code to get Server IP address it shows the result set as
      fe80::5096:9f30:6dbe:ab7b%11
      How can decrypt my IP from that.

      Note: From Oracle 11g only I getting this problem In !0g and all by using UTL_INADDR.GET_HOST_ADDRESS IPAddress i get server IP clearly.

      Please give me your suggestions.