SQLPlus Connect to Remote Database

On Windows

REM ---------------------------------------

set HOST=hostname.network
set SID=remote_SID
set userid=userid
set pass=password

  sqlplus "%userid%/%pass%@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=%HOST%)(Port=1521))(CONNECT_DATA=(SID=%SID%)))"

REM ---------------------------------------

On Linux

#---------------------------------------

HOST=hostname.network
SID=remote_SID
userid=userid
pass=password

  sqlplus "${userid}/${pass}@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=${HOST})(Port=1521))(CONNECT_DATA=(SID=${SID})))"