set ORACLE_SID as well, that error looks more like caused by a local connection without ORACLE_SID set than a remote connection using service name