Run shell script on Oracle 11g I have an oracle database:

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE   11.2.0.1.0  Production"
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


and I would like to run my script stored on db server.

path: /d01/oracle/scripts/super_skripta.sh


The content of my script (test script):

IME=$(date +"%s")

touch /d01/oracle/scripts/$IME


Can someone explain me (step by step) how can I run this script from a oracle database?

I tried to create an executable program like this:

begin
dbms_scheduler.create_program
(
program_name =&gt; 'SUPER_SKRIPTA',
program_type =&gt; 'EXECUTABLE',
program_action =&gt; '/d01/oracle/scripts/super_skripta.sh',
enabled =&gt; TRUE,
comments =&gt; 'super skripta'
);
end;
/


and then create a job:

BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
            job_name =&gt; '"WOLFY"."JOB_SS"',
            program_name =&gt; '"WOLFY"."SUPER_SKRIPTA"',
            start_date =&gt; NULL,
            repeat_interval =&gt; NULL,
            end_date =&gt; NULL,
            enabled =&gt; FALSE,
            auto_drop =&gt; FALSE,
            comments =&gt; '',

            job_style =&gt; 'REGULAR');




    DBMS_SCHEDULER.SET_ATTRIBUTE( 
             name =&gt; '"WOLFY"."JOB_SS"', 
             attribute =&gt; 'logging_level', value =&gt; DBMS_SCHEDULER.LOGGING_OFF);



    DBMS_SCHEDULER.enable(
             name =&gt; '"WOLFY"."JOB_SS"');
END;


but it does not work...
Environment:

[oracle@o61 ~]$ ls -l /home/oracle/myscript*
-rwxr-xr-x. 1 oracle oinstall 44 Mar 25 17:38 /home/oracle/myscript.sh
[oracle@o61 ~]$ cat /home/oracle/myscript.sh
#!/bin/bash
touch /home/oracle/myscript.out
[oracle@o61 ~]$

[oracle@o61 ~]$ ls -l $ORACLE_HOME/bin/extjob*
-rwsr-x---. 1 root   oinstall 1254574 Nov  1 21:01 /u01/app/oracle/product/11.2.0/dbhome_1/bin/extjob
-rwx------. 1 oracle oinstall 1254574 Nov  1 21:01 /u01/app/oracle/product/11.2.0/dbhome_1/bin/extjobo
-rwsr-x---. 1 root   oinstall 1254292 Oct 19 14:54 /u01/app/oracle/product/11.2.0/dbhome_1/bin/extjobO
-rw-------. 1 oracle oinstall 1254292 Oct 19 14:54 /u01/app/oracle/product/11.2.0/dbhome_1/bin/extjoboO

[oracle@o61 ~]$ grep -v "^#" $ORACLE_HOME/rdbms/admin/externaljob.ora

run_user = oracle
run_group = oinstall


Then create a job that is executed once then dropped:

[oracle@o61 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 25 17:42:13 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

begin
  dbms_scheduler.create_job
  (
    job_name =&gt; 'RUN_SCRIPT',
job_type =&gt; 'EXECUTABLE',
job_action =&gt; '/home/oracle/myscript.sh',
enabled =&gt; true,
auto_drop =&gt; true
  );
end;
 11  /

PL/SQL procedure successfully completed.

SQL&gt;
SQL&gt; exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@o61 ~]$ ls -l /home/oracle/myscript.*
-rw-r--r--. 1 oracle oinstall  0 Mar 25 17:42 /home/oracle/myscript.out
-rwxr-xr-x. 1 oracle oinstall 44 Mar 25 17:38 /home/oracle/myscript.sh
[oracle@o61 ~]$