Specifying Oracle Service Name in UNIX Profile
Use the TWO_TASK variable and set it to [server]/[service]

export TWO_TASK=server.example.com/mydb

This will override ORACLE_SID and make a sqlnet connection to the DB.