Drishti,

You are specifying the wrong hostname in your tnsnames.ora file.

HOST=server name or IP address and not dbname.

Hope this helps.

Cheers
pst