ORA-27369: job of type EXECUTABLE failed with exit code: Login executable not setuid-root
Hello,
I am trying to create a job with job_type=>'external_script' but failed with dbms_scheduler:
ORA-27369: job of type EXECUTABLE failed with exit code: Login executable not setuid-root
Version: 19.7/os: Red had 7
Credential user is the oracle bin owner.
select osuser from v$session where type='BACKGROUND';
oracle
scheduler directory permission:
drwxr-xr-x. 3 oracle oinstall 17 Jan 26 08:40 /u01/app/product/19.3.0.0/scheduler
BEGIN
DBMS_CREDENTIAL.CREATE_CREDENTIAL('ORACLE_CRED', 'oracle', '...');
END;
/
exec dbms_scheduler.create_job(job_name => 'EXT_SCRIPT', job_type => 'EXTERNAL_SCRIPT',job_action => '/u01/app/dba/lldba/os_script.sh', credential_name => 'ORACLE_CRED',enabled => false,auto_drop => false);