8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Identifying Host Names and IP Addresses


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.

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

https://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!