Issue

When running the following sqlplus remotely using ssh, we run into problems because some parameter disappears.

ssh servername "su linus -c \". /opt/local/bin/.tools.sh >/dev/null 2>&1;ORACLE_HOME=/opt/3rdpty/oracle/product/10.2.0; export ORACLE_HOME;ORACLE_SID=PSMF;export ORACLE_SID; /opt/3rdpty/oracle/product/10.2.0/bin/sqlplus -s username/password@connect_identifier  @/tmp/fileAsSFq3.sql\""

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Having a look at the processes during the runtime of the script:

# ps -ef | grep sqlplus
root 5729 5727 0 03:27 ? 00:00:00 su linus -c . /opt/local/bin/.tools.sh >/dev/null 2>&1;ORACLE_HOME=/opt/3rdpty/oracle/product/10.2.0; export ORACLE_HOME;ORACLE_SID=PSMF;export ORACLE_SID; /opt/3rdpty/oracle/product/10.2.0/bin/sqlplus -s username/password@connect_identifier @/tmp/fileAsSFq3.sql
linus 5730 5729 0 03:27 ? 00:00:00 /opt/3rdpty/oracle/product/10.2.0/bin/sqlplus -s @/tmp/fileAsSFq3.sql
                                                                                  ^^^ 

The issue is that between -s and @/tmp/fileAsSFq3.sql the login/password disappears:

sqlplus -s @/tmp/fileAsSFq3.sql
         ^^^