2 Replies Latest reply: May 23, 2013 7:09 AM by user164232 RSS

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

    730722
      I am trying to run a shell script through dbms_scheduler. The Shell scripts calls the oracle procedure which insert a record to the Debug table.

      Code for generating the script

      declare
      begin
      dbms_scheduler.create_job(
      job_name=>'test_call_unix'
      ,job_type=>'executable'
      ,job_action=>'/carsd/Input/Current/BAM/calling_proc.sh'
      ,start_date => SYSDATE
      ,repeat_interval => 'FREQ=SECONDLY; INTERVAL=1'
      ,enabled=>TRUE
      ,auto_drop => TRUE
      ,comments=> 'Calling unxi sh'
      );
      end;

      the shell script (calling_proc.sh)

      touch called.log
      sqlplus $ORA_USER/$ORA_PWD@$ORA_HOST << EOF1
      exec p1_sh;
      exit;
      EOF1

      I gave chmod 777 calling_proc.sh

      this the error which i got in ALL_SCHEDULER_JOB_RUN_DETAILS table

      ORA-27369: job of type EXECUTABLE failed with exit code: 274662
      STANDARD_ERROR="Oracle Scheduler error: Config file is not owned by root or is writable by group or other or extjob is not setuid and owned by root"

      Thanks in advance
      Jeeva.