My Oracle Support Banner

OME 13c : Gather Optimizer Statistics jobs from OEM fails with 'Error: Failed to commit:ORA-27476: "SYS"."GATHERSTATS_4456729" does not exist ORA-06512: at (Doc ID 2903339.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 13.5 RU06

ACTUAL BEHAVIOR
---------------
Gather Optimizer Statistics jobs from Enterprise Manager fails with 'Error: Failed to commit:

ORA-27476: "SYS"."GATHERSTATS_4456729" does not exist ORA-06512: at
"SYS.DBMS_ISCHED", line 3229 ORA-06512: at "SYS.DBMS_SCHEDULER", line 2966
ORA-06512: at line 2 '

Unexpected error occurred. Please contact Oracle Support with these files.
<EM_INSTANCE_BASE>/user_projects/domains/<domain_name>/servers/<SERVER_NAME>/logs/access.log
<EM_INSTANCE_BASE>/user_projects/domains/<domain_name>/servers/<SERVER_NAME>/logs/<SERVER_NAME>-diagnostic.log
<EM_INSTANCE_BASE>/em/<OMS_NAME>/sysman/log/emoms.trc

 

Performance -> SQL -> Optimizer Statistics -> View -> filter for Object Status:stale -> Select a table-> in Action menu select "Gather" -> Go -> next -> next -> submit

First job submitted after db login is successful, successive jobs submitted in the same session are failing.

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.