1

I have the following pl/sql script that should execute the shell script script.sh. When I runt the code below In SQLDeveloper I get:

    Error report -
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing login executable failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sjseccel 1
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 20
27370. 00000 -  "job slave failed to launch a job of type EXECUTABLE"
*Cause:    The scheduler ran into an error when the job slave tried to start
           a job of type EXECUTABLE. The rest of the error stack will provide
           more detailed information on what the exact problem was.
*Action:   Correct the problem specified in the error stack and reschedule
           the job.

The file exists and has the correct permissions on my system. Is something that I am doing wrong? Also, the provided credentials seem to be the correct ones.

An here is the code:

set serveroutput on;

BEGIN
    DBMS_SCHEDULER.create_credential(
        credential_name => 'user_cred',
        username        => 'user',
        password        => 'pass');  
END;   
/

begin
      DBMS_SCHEDULER.CREATE_JOB (
        job_name           => 'test_prog',
         job_type           => 'EXECUTABLE',
        job_action         => '/home/user/Desktop/foo/script.sh',
         enabled            => TRUE,
         credential_name => 'user_cred'
      );
    dbms_scheduler.run_job('test_prog');
end;
/

1 Answer 1

0

It looks like external scheduler jobs are not available in the XE edition.

3
  • why do you think so?
    – miracle173
    Commented May 17, 2017 at 3:35
  • On my system, ubuntu 17.04, oracle needs to check the credentials provided before executing the job. In order to do this, it needs to use an executable, jssu, which is not present on my XE installation, but appears to exist in the EE installation. Am I wrong?
    – cristid9
    Commented May 17, 2017 at 17:06
  • for Oracle 11.2 EE I found $ORACLE_HOME/bin/jssu
    – miracle173
    Commented May 18, 2017 at 13:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.