tivoli work scheduler - TWS job is getting abended

Question

While executing the job, I am getting below error Job.sh is the script - while executing it in tws I am getting below error

path of the script - job.sh: sqlplus: not found

Can any please help on this

Thanks

question from:https://stackoverflow.com/questions/65917533/tws-job-is-getting-abended

Answer 1

I don't know how Tivoli works, but you are writing to run a "job.sh" script, so I assume it is a shell script. Normally when working with oracle it is a good idea to enter absolute paths, so your script could be

   #!/bin/sh
   $ORACLE_HOME=<your path of oracle installation>
   $ORACLE_SID=<your instance name>
   $PWD=<Position of your sql script>
    ..........
   $ORACLE_HOME/bin/sqlplus login/password @$PWD/script.sql

I hope that's what you were looking for.