Skip to Main Content
Forums

SQL & PL/SQL

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!

Get Server IP address in oracle 11g

ganex27linMay 19 2011 — edited Jun 14 2012
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2012
Added on May 19 2011
#11g, #oracle, #server
6 comments
12,028 views