When I created schedule job
BEGIN
DBMS_SCHEDULER.create_job
(job_name => 'DF_Partitions',
repeat_interval => 'FREQ=HOURLY;INTERVAL=2',
job_type => 'EXECUTABLE',
job_action => '/home/admin/bin/df.sh',
enabled => TRUE,
comments => 'Check Partitions on System'
);
END;
By I set permission on file
#chown oracle:dba /home/admin/bin/df.sh
#chmod 750 /home/admin/bin/df.sh
But I found "ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied " in schedule log.
So, I resolved that i changed permission on $ORACLE_HOME/bin/extjob file.
#chown oracle:dba $ORACLE_HOME/bin/extjob
Thursday, August 31, 2006
Subscribe to:
Post Comments (Atom)
1 comment:
Thanks that helped me
Post a Comment