I am new to oracle and would like to find out the
name of a oracle server.How can this be done.
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
Hope one of these would help you.
Life is a journey, not a destination!
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.
The OS i am using is Windows 2000.
Thanks a lot guys.Both your answers where
very usefull.I really appreciate your help.
Click Here to Expand Forum to Full Width