EM 12c: EM_GROUP_MEMBER_SYNCUP Scheduler Job is Running for a Long Time in Enterprise Manager 12c Cloud Control (Doc ID 1923004.1)

Last updated on AUGUST 13, 2015

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

In 12.1.0.4.0 cloud control, EM_GROUP_MEMBER_SYNCUP is running for a long time. Following SQL is shown in AWR report of repository database:

================
79fgmjxku9z5v DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN EM_GROUP.SYNC_UP_GROUP_MEMBERSHIP(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
=======================

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms