try putting in ip address of your host in the tnsnames.ora files and listener...

It apparently can't find the host, so make sure that the server is
--up
-- ping'able
--tnsping..Since here you get the error...
-- no SA activity took place like rename the machine,etc...
-- use net8/servives utility to test the connection, comparing the *.ora files isn't really that advisable.