ORA-27369: job EXECUTABLE failed with exit code:The storage control blocks were destroyed
Hi, Everybody.
Who has found out the issues as fellows:
# ADDITIONAL_INFO:
EXTERNAL_LOG_ID="job_265297_744068",ORA-27369: job EXECUTABLE failed with exit code:The storage control blocks were destroyed
# ERRORS:
Invalid username or password
And my scheduler job code as below:
- SET termout ON
- PROMPT
- PROMPT RECOMPILE TIER22
- PROMPT
- begin
- dbms_utility.compile_schema('TIER22', false);
- end;
- /
- PROMPT
- PROMPT Delete existing Backup-Job and Credentials
- PROMPT
- begin
- dbms_scheduler.drop_job(job_name => 'DAILY_CREATE_BACKUP');
- dbms_scheduler.drop_job(job_name => 'WEEKLY_CLEANUP');
- dbms_credential.drop_credential('T2_OS_CREDENTIAL');
- dbms_credential.drop_credential('T2_DB_CREDENTIAL');
- end;
- /
- PROMPT