This discussion is archived
6 Replies Latest reply: Jun 14, 2012 2:18 AM by 738125 RSS

Get Server IP address in oracle 11g

ganex27lin Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points