My Oracle Support Banner

EM 12c: Plugin deployment fails with error " java.lang.IllegalStateException: No central agents of the management servers" (Doc ID 1527762.1)

Last updated on FEBRUARY 16, 2019

Applies to:

Enterprise Manager Base Platform - Version to [Release 12.1]
Information in this document applies to any platform.


Plugin deployment on OMS from EM 12c Console fails with following error:

java.lang.IllegalStateException: No central agents of the management servers could be obtained for plugin deployment. The following query was used to retrieve them -
"SELECT t.target_name, t.emd_url, op.host_url, op.oms_id, op.status, op.unique_oms_name, op.is_first_oms, op.oracle_home, op.server_name, t.host_name , ca.current_status
           FROM gc_oms_info op, mgmt_targets t , mgmt_current_availability ca
           WHERE op.host_name = t.host_name AND op.em_release_version = ? AND op.domain_name = ? AND t.target_type='oracle_emd' AND ca.target_guid = t.target_guid ORDER BY op.oms_id" 

a. Query to get the host name of OMS :

SQL> select p.value OMS_HOST_NAME from mgmt_oms_parameters p where = '<HOSTNAME>';


b. Query to check hostname used to install central/chained agent:

SQL> select t.TARGET_NAME,t.TARGET_TYPE,DECODE(a.current_status,1,'Up','Down') Status from mgmt_targets t,mgmt_current_availability a WHERE t.target_guid = a.target_guid and target_type='oracle_emd' and emd_url like '%OMSHOSTNAME%' order by 1,2 ;

TARGET_NAME                               TARGET_TYPE                      STATUS
<OMSHOSTNAME.DOMAINAME>:<PORT>              oracle_emd                          Up


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

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