ORA-27369: job of type EXECUTABLE failed with exit code: The storage control blocks were destroyed

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');

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.