ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied

Hi

I was trying to set up a test job in Enterprise manager and I got this error when it tried running the script.

I've created the script on a RAC cluster . It contains the following:

#!/bin/ksh

. /oracle/.kshrc

env >> /tmp/t.txt
which sqlplus >> /tmp/t.txt

sqlplus scott/abc_at_ORACLE123<<-!
set serveroutput on size 1000000
select 'Hello World' from dual
/
!

I've ran this successfully via the command line. Could someone advise as to what I am missing or did wrong?

I had a look at metalink and check the points given there but I seem to have them covered.

Regards

Justin Received on Sun Dec 14 2008 - 22:41:53 CST