<div>
try to use ping command.<br />
ping nyspcor01g<br />
if nyspcor01g is a hostname you should get back recolved IP
</div>


try to use ping command.
ping nyspcor01g
if nyspcor01g is a hostname you should get back recolved IP

<div>
Dear thomasliju,<br />
<br />
<br />
You will find by the below 2 commands, give a try now<br />
<br />
ifconfig -a &nbsp;<br />
<br />
cat /etc/hosts | grep &lt;server_name&gt;
</div>


Dear thomasliju,


You will find by the below 2 commands, give a try now

ifconfig -a  

cat /etc/hosts | grep <server_name>

<div>
Since the question was originally posted in the Oracle Database topic area, I'll assume you want an Oracle solution as well.<br />
<br />
use the UTL_INADDR package<br />
<br />
<br />
select UTL_INADDR.get_host_addres<wbr />s('nyspcor<wbr />01g') from dual;<br />
<br />
Note, in 11g or higher databases you'll need an ACL that allows the RESOLVE privilege
</div>


Since the question was originally posted in the Oracle Database topic area, I'll assume you want an Oracle solution as well.

use the UTL_INADDR package


select UTL_INADDR.get_host_address('nyspcor01g') from dual;

Note, in 11g or higher databases you'll need an ACL that allows the RESOLVE privilege

<div>
This is good for any servers..
</div>


<div>
thomasliju,<br />
<br />
Can you explain why you accepted the post you did? ifconfig and /etc/hosts had both been posted previously.
</div>


thomasliju,

Can you explain why you accepted the post you did? ifconfig and /etc/hosts had both been posted previously.

<div>
<div class="content wysiwyg-content">
How will we find the ip address for this machine<br />
<br />
nyspcor01g[oracle:coreaux1<wbr />]<br />
<br />
This is sunsolaris
</div>
</div>


How will we find the ip address for this machine

nyspcor01g[oracle:coreaux1]

This is sunsolaris

to find ip address

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.