You need to have oracle client installed along with the tnsnames.ora file on your pc. This file should contain an entry of the database you are trying to connect to.
To find the ip address of the server, just do the following on the command line:
c:\ping server_name

the hostname you're asking will be the server name which hosts the database that you are trying to connect to.