EM 12c, EM 13c: Applying Monitoring Templates to a Particular Database is Stuck in Pending forever

(Doc ID 2213002.1)

Last updated on MARCH 16, 2017

Applies to:

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

Symptoms

Monitoring Template is being applied to a set of database targets. This activity succeeds for all targets except one, for which the status is always shown as Pending.
Forcefully stopping the template apply and re-applying also gets stuck in pending status again.

Submitting a simple 'SQL Plus' job against this database fails with the

Job status showing: Suspended: Target is not ready

A simple 'OS command' job against the Host, where this database is running, succeeds without any errors.

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