Also have a look at sqlnet.ora on the machine acting as client. If it contains something like
NAMES.DEFAULT_DOMAIN = STUPID.CH
then this is appended to a connection string if that does not explicitly include a domain (i.e. has a dot in it) before it is looked up in tnsnames.ora. Failure to find SID.STUPID.CH gives an ORA-12154 too.