ORA-27369: job of type EXECUTABLE failed with exit code: The storage control blocks were destroyed
Error:
Following error occurred during running he job which uses the window credentials to execute the RMAN backup script
ORA-27369: job of type EXECUTABLE failed with exit code: The storage control blocks were destroyed.
SQL> exec dbms_scheduler.run_job(job_name => 'JOB$_764');
BEGIN dbms_scheduler.run_job(job_name => 'JOB$_764'); END;
*
ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: The storage control blocks were destroyed.
ORA-06512: at "SYS.DBMS_ISCHED", line 238
ORA-06512: at "SYS.DBMS_SCHEDULER", line 568
ORA-06512: at line 1
Cause
This error occurred due to wrong username or password is defined in the Credential procedure, you need to use the valid Operating system username and password
Solution:
Verify the Credential name used in Job then check its username password for Operating system and you can also check its not disabled at Oracle Credential view.
1. Verify the username which you are using for this job:
Col job_name for a15
select job_name,job_type,credential_name from dba_scheduler_jobs where job_name = 'JOB$_764';
JOB_NAME JOB_TYPE CREDENTIAL_NAME --------------- ---------------- ------------------------- JOB$_764 BACKUP_SCRIPT ORACLE_BKPUSER
2. Verify the credential is Enabled/disabled
If its enabled then means username and password is not working, you need to verify at Operating system level by login.
COLUMN credential_name FORMAT A25
COLUMN username FORMAT A20
COLUMN windows_domain FORMAT A20
SELECT credential_name,
username,
windows_domain,enabled
FROM all_credentials where credential_name = 'ORACLE_BKPUSER'
ORDER BY credential_name;
CREDENTIAL_NAME USERNAME WINDOWS_DOMAIN ENABL ------------------------- ---------- -------------- ----- ORACLE_BKPUSER oracle TRUE
--For enable
EXEC DBMS_CREDENTIAL.enable_credential('ORACLE_BKPUSER');
--For Disable
EXEC DBMS_CREDENTIAL.disable_credential('ORACLE_BKPUSER');
3. For Change username and password for existing credential:
--For change username
Exec DBMS_CREDENTIAL.update_credential(credential_name => 'ORACLE_BKPUSER',attribute => 'username', value => 'oracle');
--For change password
EXEC DBMS_CREDENTIAL.update_credential(credential_name => 'ORACLE_BKPUSER',attribute => 'password', value => 'password123');
4. For Creating and Dropping Credentials
--For Creating Normal user
exec dbms_scheduler.create_credential( credential_name => 'ORACLE_BKPUSER', username => 'Oracle', password => 'Password123');
--For Creating Domain user
exec dbms_scheduler.create_credential( credential_name => 'ORACLE_BKPUSER', username => 'oracle', password => 'Password123', windows_domain => 'ORCL' );
--For drop User Credentials
EXEC DBMS_CREDENTIAL.drop_credential('ORACLE_BKPUSER');