My Oracle Support Banner

OEM 13c : All jobs in OEM stuck in running status when EM audit is enabled. (Doc ID 2648496.1)

Last updated on MARCH 12, 2020

Applies to:

Enterprise Manager Base Platform - Version 13.3.0.0.0 to 13.4.0.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

OEM version 13.3 OR 13.4

EM repository version :19c

Submitting simple OS command job stuck in running status forever.

 

EMDiag log after executing the following command shows errors:

$repvfy dump job_health

From : job_health_2020_03_11_124757.log

Error: ORA-22990: LOB locators cannot span transactions
ORA-06512: at "SYSMAN.EM_JOB_AUDIT", line 447
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 505
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 942
ORA-06512: at "SYS.DBMS_LOB", line 727
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 924
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 490
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 419
ORA-06512: at "SYSMAN.EM_JOB_AUDIT", line 431
ORA-06512: at "SYSMAN.MGMT_JOB_EXEC_UPDATE_BEFORE", line 41
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 7893
ORA-06512: at "SYSMAN.EM_JOB_DISPATCH", line 3530

ERROR updating step:3735 to status:4

 

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.