Shell Programming and Scripting

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

SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

-rwsr-x--- 1 root   oinstall 1249595 Mar  9  2013 extjob

-rw-r----- 1 root oinstall 1534 Dec 21  2005 externaljob.ora
run_user = nobody
run_group = nobody

dbms_scheduler.create_job( 
							job_name => 'ABC_JOB', 
							job_type => 'executable', 
							job_action => 'abc/def/gh/xyz.sh', 
							start_date => sysdate, 
							enabled => TRUE 
						 ); 
						 

xyz.sh
------
#Configuration Part
USERNM=XXXXX
PSSWD=YYYYY
CONNSTR=ZZZZZ
T2USRPWD=${USERNM}/${PSSWD}@${CONNSTR}

#Setting oracle path variables
export ORACLE_SID=ZZZZZ
export ORACLE_HOME=/abc/def/ghi/....../dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin

sqlplus -S ${T2USRPWD}
spool abc/def/gh/xyz.log
select * from dual;
spool off;
exit;

sqlplus -s /nolog <<EOF
connect ${T2USRPWD}
spool abc/def/gh/xyz.log
select * from dual;
spool off;
exit;
EOF