2 Replies Latest reply on Sep 28, 2012 4:29 AM by user11942774

    Dbms_scheduler error in calling a schell script.


      I am trying to execute a shell script which is called from a procedure.
      below are the changes which i have made and after that i am still getting error as below:
      Please help me as to where i am going wrong:

      Steps takesm:
      1) rdbms/admin/externaljob.ora file to add the below info
      run_user = oracle
      run_group = dba
      2) And have changed the bin/extjob file must be permissions to 4750 (-rwsr-x---)
      3) The shell script is having full permission(777) and starts with #!/bin/ksh
      4) - bin/extjobo sfile should have normal 755 (rwxr-xr-x)
      5) - bin/jssu should have setuid permissions i.e. with 4750 (-rwsr-x---)

      ORA-27369: job of type EXECUTABLE failed with exit code: 255
      STANDARD_ERROR="execve: Exec format error"

      Oracle Database 11g Enterprise Edition Release - 64bit
       DBMS_SCHEDULER.create_job (
            job_name              => 'gatekr3',
            job_type              => 'EXECUTABLE',
            job_action            => '/home/cobr_sftp/var/download/test_abh.sh',
             number_of_arguments   => 0,  
            enabled               => true,
            comments              => 'CREATE_PROGRAM test using a schell script'
      Edited by: user11942774 on Sep 27, 2012 1:22 AM