Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Identifying Host Names and IP Addresses - This article presents a mixed bag of Oracle functionality relating to the identification of host names and IP addresses for Oracle clients and servers.



Mat said...

I think that it's a good article

SomeOneElse said...

i think the same

Mofizbd@gmail.com said...

Many many things for this. Its very much help full for me

Asad said...

dear all
I am using this command... to get the name of machine

select UTL_INADDR.Get_Host_Name('IP Address...') from dual;

it is accurately replying me machine name.
but my server is configured on SAN along with LAN.

so my server has two IP addresses. and when i try to get the IP address through name of server .....

select UTL_INADDR.Get_Host_Address('Machine Name ...') from dual;

it simply returns me SAN ip address but i need LAN ip address

how can I get????

Regards.

Tim... said...

Hi.

The short answer is I don't know. You need to contact Oracle support.

Cheers

Tim...

PS. Questions in the forum, not in the comments.

Manish Mohan said...

You can use SYS_CONTEXT('USERENV', 'SERVER_HOST_IP')

Tim... said...

Hi.

SERVER_HOST_IP is not a valid parameter. See the docs.

http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions184.htm#SQLRF06117

Cheers

Tim...

DO NOT ask technical questions here, that's what my forum is for!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)