Forums | 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...

Murali said...

How to ping the ip address in oracle using query or procedure or anymethod ?.

Tim... said...

Hi.

You could shell out to the OS to do this I guess, or use an executable job.

http://www.oracle-base.com/articles/8i/shell-commands-from-plsql.php

http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php

Remember, these days most servers are configured to drop pings, so pinging them will fail...

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

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)