Execute Shel Script with Job

[maxberkeuer]

Good Morning!

Use the Oracle 11G seat

I created a job to run a backup script with DataPump.

Select all

begin 
  sys.dbms_scheduler.create_job(job_name            => 'BACKUP_DATA_PUMP', 
                                job_type            => 'EXECUTABLE', 
                                job_action          => '/home/oracle/scripts/data_pump/executa_backup.sh', 
                                start_date          => to_date('24-12-2015 08:16:55', 'dd-mm-yyyy hh24:mi:ss'), 
                                repeat_interval     => 'Freq=Daily;Interval=1', 
                                end_date            => to_date(null), 
                                job_class           => 'DEFAULT_JOB_CLASS', 
                                enabled             => true, 
                                auto_drop           => false, 
                                comments            => ''); 
end; 
/ 

When I run JOB, I return the error:

Select all

ORA-27369: o trabalho do tipo EXECUTABLE falhou com código de saída: 274666 
STANDARD_ERROR="Oracle Scheduler error: Cannot access or open configuration file."

in a search, I checked That is allowed error in the /u01/app/oracle/product/11.2.0/xe/bin/extjob file
I gave permissions 777 in the file and still did not solve.

Does anyone know what I should do?

Thanks!

[stcoutinho]

Hello Maxberkeuer,

I searched a little on the subject and maybe the problem is related to user accredences in the OS.

Take a look at this link to see if it helps you to heal this problem. The link seemed useful to me:
https://community.oracle.com/thread/557102?tstart=0
Hugs and good luck,

Sergio

[maxberkeuer]

Thank you Sergio!

I will check these permissions and then set here if it worked.

Hugs!