In Oracle 10g you can use following command on SQL*Plus to connect to another database:
SQL> conn USERNAME/PASSWORD@HOSTNAME:PORT/SID

In that case you don't need a tnsnames.ora. Only your sqlnet.ora need the following entry:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME)