shell - Sqlplus command is not working via plink -

shell - Sqlplus command is not working via plink -

i have shell script in using sqlplus command fetch info database (installed on linux). same script working fine on linux environment. when execute script on window environment via using below batch file.

set oracle_term=xterm set oracle_base=/home/pwcadm/app/pwcadm set oracle_home=/home/pwcadm/app/pwcadm/product/11.2.0/client_1 set oracle_hostname=kyora02.kymab.local set oracle_sid=orcl set ora_nls11=$oracle_home/nls/data set lang=en_us.utf-8 set path=/opt/collabnet_subversion/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/x11r6/bin:/root/bin:/home/pwcadm/app/pwcadm/product/11.2.0/client_1/bin:/home/pwcadm/app/pwcadm/product/11.2.0/client_1/bin:/home/pwcadm/app/pwcadm/product/11.2.0/client_1/lib/site_perl/5.8.3/i686-linux-thread-multi:/home/pwcadm/app/pwcadm/product/11.2.0/client_1/perl/lib/5.10.0/x86_64-linux-thread-multi:/home/pwcadm/app/pwcadm/product/11.2.0/client_1/perl/bin:/home/pwcadm/informatica/powercenter9.1.0.3/server/bin set ld_library_path=/home/pwcadm/app/pwcadm/product/11.2.0/client_1/lib:/home/pwcadm/app/pwcadm/product/11.2.0/client_1/lib32:/home/pwcadm/informatica/powercenter9.1.0.3/server/bin cd c:\program files\putty plink csaadm@172.16.122.11 -pw csaadm /app/csa/reg_automation/scripts/check_gan_insert.sh

batch file prompting below error message. have set paths.

c:\program files\putty>plink csaadm@172.16.122.11 -pw csaadm /app/csa/reg_automa tion/scripts/check_gan_insert.sh error 6 initializing sql*plus sp2-0667: message file sp1<lang>.msb not found sp2-0750: may need set oracle_home oracle software directory fail /app/csa/reg_automation/scripts/check_gan_insert.sh: line 27: [: -ne: unary oper ator expected

check_gan_insert.sh

account_global_count=$(echo " set heading off set feedback off set verify off set trimspool on set trimout off set pagesize 0 set space 0 whenever sqlerror exit 2; select count(*) account_global name='test'; "|/home/pwcadm/app/pwcadm/product/11.2.0/client_1/bin/sqlplus -s ${db_username}/${db_password}@${connecting_string}) eror_msg=$(echo ${account_global_count} |grep ora|wc -l) if [ ${eror_msg} -ne 0 ] echo "${account_global_count}" exit; fi if [ ${account_global_count} -ne 0 ] echo "pass" else echo "fail" fi

please help.

we haven't plenty info problem, here guess:

you have set oracle_home env. var each time log in (or add together in auto executable scripts), you have extend path (use export path=$path:$oracle_home/bin), also, may need start oracle instance.

check these 3 points , update question if problem still not solved.

shell sqlplus putty