Through Datastage, the shell script having Oracle Connection is throwing one error. The same shell script is working fine directly through Unix.
Although, independantly the Oracle is working fine throuth datastage, yet the shell script with the Oracle is not working. The shell script is working only after removing oracle part from the script.
The error which I am getting, is as follows:
The shell script is as follows:/usr/lib/pa20_64/dld.sl: '/opt/ascential/DataStage/DSEngine/java/jre/lib/PA_RISC/hotspot/libjvm.sl' is not a valid load module: Bad magic number
/opt/dsadm/odh_job_individual.sh[38]: 19180 Killed.
#-----------------------
uid=xxxxx
pwd=xxxxx
svr=xxxxx
#Delete the job_rpt files
#-----------------------
rm ${job_report_path}job_report.txt
#Build Oracle connection string and connect and perform preprocessing
#-----------------------
OracleConnstrg=${uid}/${pwd}@${svr}
sqlplus $OracleConnstrg<<! >&2
@drop_index.sql
#-----------------------
Can you please tell that what is the meaning of this error and the significance of this path:
'/opt/ascential/DataStage/DSEngine/java/jre/lib/PA_RISC/hotspot/libjvm.sl'
Also please tell us what to do to successfully call shell script (having Oracle connection) through DataStage.
Thanks in Advance,
Rajeev Prabhu