CREATE table bob (a varchar2(100));

#!/bin/bash
echo "TEST"
sqlplus -s <user>/<pass> <<EOF

begin
  
  insert into bob (a) values ('TESTED');

  COMMIT;

end;
/

exit;

EOF

echo "************************************"

begin
    dbms_scheduler.create_job(
        job_name => 'my_external_job',
        job_type => 'EXECUTABLE',
        job_action => '/home/oracle/training_scripts/test_script.sh',
        auto_drop => false,
        enabled => true);
end;
/

begin
    dbms_scheduler.run_job( 'my_external_job');
end;
/

ORA-27369: job of type EXECUTABLE failed with exit code: 274666 Oracle Scheduler error: Cannot access or open configuration file.?6
ORA-06512: at "SYS.DBMS_ISCHED", line 209
ORA-06512: at "SYS.DBMS_SCHEDULER", line 594
ORA-06512: at line 2

cd $ORACLE_HOME/rdbms/admin
sudo vi externaljob.ora
change run_user to oracle, run_group to dba
save file

cd $ORACLE_HOME/bin
sudo chown root extjob
sudo chmod 4750 extjob

oracle@DB-19C-OL8:[/u01/app/oracle/product/19.0.0/dbhome_prod/rdbms/install]$ grep ext *
config_filemap.sbs:# Note that the ordering of the libraries in this file is extremely           #
config_filemap.sbs:## The next row needs to be commented out only for Solaris on EMC storage
config_filemap.sbs:## The next row can be comented out on ALL UNIX PLATFORMS if no other
filemap.ora:# Note that the ordering of the libraries in this file is extremely           #
filemap.ora:## The next row needs to be commented out only for Solaris on EMC storage
filemap.ora:## The next row can be comented out on ALL UNIX PLATFORMS if no other
install.excl:bin/extjob
grep: instantclient: Is a directory
grep: rdbms: Is a directory
rootadd_rdbms.sh:# copy extjobo to extjob if it doesn't exist
rootadd_rdbms.sh:if [ ! -f $ORACLE_HOME/bin/extjob -a -f $ORACLE_HOME/bin/extjobo ]; then
rootadd_rdbms.sh:       $CP -p $ORACLE_HOME/bin/extjobo $ORACLE_HOME/bin/extjob
rootadd_rdbms.sh:if [ -f $ORACLE_HOME/bin/extjob ]; then
rootadd_rdbms.sh:       $CHOWN root $ORACLE_HOME/bin/extjob
rootadd_rdbms.sh:       $CHMOD 4750 $ORACLE_HOME/bin/extjob
rootadd_rdbms.sh:if [ -f $ORACLE_HOME/rdbms/admin/externaljob.ora ]; then
rootadd_rdbms.sh:       $CHOWN root $ORACLE_HOME/rdbms/admin/externaljob.ora
rootadd_rdbms.sh:       $CHMOD 640 $ORACLE_HOME/rdbms/admin/externaljob.ora
rootadd_rdbms.sh:# Bug#25068882: properly set up extproc executable
rootadd_rdbms.sh:if [ -f $ORACLE_HOME/bin/extproc ]; then
rootadd_rdbms.sh:        $CHMOD g+s $ORACLE_HOME/bin/extproc
rootadd_rdbms.sh:if [ -f $ORACLE_HOME/rdbms/admin/externaljob.ora.orig ]; then
rootadd_rdbms.sh:       $RM -f $ORACLE_HOME/rdbms/admin/externaljob.ora.orig
grep: sbs: Is a directory
setup_processor_group.sh:  echo "Next step: create a new proc group using option -create"
oracle@DB-19C-OL8:[/u01/app/oracle/product/19.0.0/dbhome_prod/rdbms/install]$
oracle@DB-19C-OL8:[/u01/app/oracle/product/19.0.0/dbhome_prod/rdbms/install]$ grep jssu *
grep: instantclient: Is a directory
grep: rdbms: Is a directory
rootadd_rdbms.sh:if [ -f $ORACLE_HOME/bin/jssu ]; then
rootadd_rdbms.sh:        $CHOWN root $ORACLE_HOME/bin/jssu
rootadd_rdbms.sh:        $CHMOD 4750 $ORACLE_HOME/bin/jssu
grep: sbs: Is a directory
oracle@DB-19C-OL8:[/u01/app/oracle/product/19.0.0/dbhome_prod/rdbms/install]$

-rwsr-x---. 1 root oinstall 3023080 Sep 12 08:51 extjob
-rwxr-xr-x. 1 oracle oinstall 2335704 Sep 12 08:51 jssu
-rw-r-----. 1 root oinstall 1531 Sep 20 15:41 externaljob.ora

-rwsr-x---. 1 root oinstall 1630688 Sep 20 13:17 extjob
-rwsr-x---. 1 root oinstall 47064 Sep 20 13:17 jssu
-rw-r-----. 1 root oinstall 1536 Sep 21 10:18 externaljob.ora

begin
   dbms_scheduler.create_job (job_name    => 'myjob',
                              job_type    => 'executable',
                              job_action  => '/bin/sh',
                              number_of_arguments => 1,
                              auto_drop   => true);
   dbms_scheduler.set_job_argument_value ('myjob', 1, '/home/oracle/script.sh');
   dbms_scheduler.run_job ('myjob');
end;
/ 

BEGIN
dbms_scheduler.create_credential(
  credential_name => 'MY_OS_CREDS',
  username        => '<username>',
  password        => '<password>');
END;
/

begin
    dbms_scheduler.create_job(
        job_name => 'my_external_job',
        job_type => 'EXECUTABLE',
        job_action => '/home/<app user>/training_scripts/test_script.sh',
        auto_drop => false,
        credential_name => 'MY_OS_CREDS',
        enabled => true);
end;
/

begin
    dbms_scheduler.run_job( 'my_external_job');
end;
/

ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing login executable failed with status: 13
ORA-27301: OS failure message: Permission denied
ORA-27302: failure occurred at: sjseccel 1
ORA-06512: at "SYS.DBMS_ISCHED", line 209
ORA-06512: at "SYS.DBMS_SCHEDULER", line 594
ORA-06512: at line 2

12.1.0.2.0

-rwsr-x---. 1 root oinstall 1630688 Sep 20 13:17 extjob

12.2.0.1.0

-rwsr-x---+ 1 root oinstall 2241816 Jan 22  2018 extjob

12.1.0.2.0

getfacl extjob
# file: extjob
# owner: root
# group: oinstall
# flags: s--
user::rwx
group::r-x
other::---


12.2.0.1.0

getfacl extjob
# file: extjob
# owner: root
# group: oinstall
# flags: s--
user::rwx
group::r-x
group:dba:rwx                   #effective:r-x
mask::r-x
other::---