My Oracle Support Banner

Job is faling with use_current_session => true in 11.2.0.4 (Doc ID 2830512.1)

Last updated on DECEMBER 31, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Job is faling with use_current_session => true in 11.2.0.4.
Job is successful while using use_current_session => false as below.

BEGIN dbms_scheduler.run_job(job_name => '{job_name}',use_current_session => false); END;

Otherwise it is failing with below error. With true it is failing and also it fails if not using use_current_session parameter

BEGIN dbms_scheduler.run_job(job_name => '{job_name}',use_current_session => true); END;
Error report -
ORA-20003: Refresh type XXX unable to access XXX database. Refresh failed.
ORA-06512: at "XXX.PKG_ENTITLEMENTS_UTL", line 465
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_ISCHED", line 196
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1

SQL> begin
  dbms_scheduler.run_job(job_name => 'XXX.job_name');
end;
/

begin
*
ERROR at line 1:
ORA-20003: Refresh type XXX unable to access XXX database. Refresh failed.
ORA-06512: at "XXX.job_name", line 465
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_ISCHED", line 196
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 2

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.