Skip to content

DBMS_SCHEDULER not working oraoperator oracle deployed pod #226

@alinaqvion-hash

Description

@alinaqvion-hash

We have tried scheduling the backup using DBMS_SCHEDULER, which is not working. Is this supported in container environment?

SQL>
SQL> BEGIN
DBMS_SCHEDULER.create_job(
job_name => 'RMAN_FULL_BACKUP_JOB',
job_type => 'EXECUTABLE',
job_action => '/home/oracle/rman_full_backup.sh', -- path inside the pod
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=HOURLY; INTERVAL=1', -- run every 1 hour
enabled => TRUE,
auto_drop => FALSE,
comments => 'RMAN Full Backup every 1 hour inside OraOperator pod'
);
END;
/ 2 3 4 5 6 7 8 9 10 11 12 13

PL/SQL procedure successfully completed.

SQL> BEGIN
DBMS_SCHEDULER.run_job('RMAN_FULL_BACKUP_JOB');
END;
/ 2 3 4
BEGIN
*
ERROR at line 1:
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:Waiting for extjob to send child
failed with status: 62
ORA-27301: OS failure message: Timer expired
ORA-27302: failure occurred at: sjsec 6d
ORA-06512: at "SYS.DBMS_ISCHED", line 242
ORA-06512: at "SYS.DBMS_SCHEDULER", line 566
ORA-06512: at line 2
SQL>

=======
SQL> BEGIN
DBMS_SCHEDULER.run_job('RMAN_FULL_BACKUP_JOB');
END;
/ 2 3 4
BEGIN
*
ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: 7 Invalid username or
password
ORA-06512: at "SYS.DBMS_ISCHED", line 242
ORA-06512: at "SYS.DBMS_SCHEDULER", line 566
ORA-06512: at line 2

SQL>

2026-03-30T13:49:17.107893+00:00
PSMFPDB(3):Errors in file /opt/oracle/diag/rdbms/psmf/PSMF/trace/PSMF_j000_336474.trc:
ORA-12012: error on auto execute of job "SYSTEM"."RMAN_FULL_BACKUP_JOB"
ORA-27369: job of type EXECUTABLE failed with exit code: 7 Invalid username or password

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions