to find ip address

How will we find the ip address for this machine

nyspcor01g[oracle:coreaux1]

This is sunsolaris
thomaslijuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

helpfinderIT ConsultantCommented:
try to use ping command.
ping nyspcor01g
if nyspcor01g is a hostname you should get back recolved IP
0
slightwv (䄆 Netminder) Commented:
Try:
ifconfig -a
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
omarfaridCommented:
you may run the command

ifconfig -a

which will show you the network interfaces and their IPs

OR

you could run

grep `hostname` /etc/hosts

OR

nslookup `hostname`
0
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Shahnawaz AhmedCloud Migration EngineerCommented:
Dear thomasliju,


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

ifconfig -a  

cat /etc/hosts | grep <server_name>
0
sdstuberCommented:
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
0
thomaslijuAuthor Commented:
This is good for any servers..
0
slightwv (䄆 Netminder) Commented:
thomasliju,

Can you explain why you accepted the post you did? ifconfig and /etc/hosts had both been posted previously.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Unix OS

From novice to tech pro — start learning today.