Find out oracle Server name

[ran]

Hi Everyone,
I am new to oracle and would like to find out the
name of a oracle server.How can this be done.

thank u,

Ran

[sambavan]

What is the OS your oracle server is at:

1. You can test it through the tnsnames.ora where the host name is your oracle server name and SID name is the name of the instance that you connect to on that server.

2. You can use the nslookup to see the host name

3. On the unix you can check through

uname -a

Hope one of these would help you.

Sam

[Mr.Hanky]

SELECT * FROM gobal_name;

Will give you the DB name, at least in my shop it will.

In NT try "IPCONFIG /ALL" from a command line, that may work.
MH

[ran]

HI,
The OS i am using is Windows 2000.
Thanks a lot guys.Both your answers where
very usefull.I really appreciate your help.
Thank you,

Regds,
Ran