siva kumar has given a pretty thorough answer -- but I don't like hard coding the hostname into my programs. If you're already using a tnsnames.ora file, put a copy of it in /etc, and then use the SID to connect. (if you're setting the SID via environmental variables, you need to set TWO_TASK, not ORACLE_SID, as this is a remote database)