EM 12c : Host And Agent Not Getting Discovered In OEM After Agent Installation 'ORA-20500: Multiple hosts detected for' Reported in emoms_pbs.log (Doc ID 2082982.1)

Last updated on NOVEMBER 27, 2015

Applies to:

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

Symptoms

Newly installed 12c agent is not showing on 12c cloud console.emoms_pbs.log reports ORA-20500: Multiple hosts detected for agent URL exception



Following query from repository database shows  target_name and monitoring EMD_URL mismatch

SQL>select ENTITY_NAME, ENTITY_TYPE, MANAGE_STATUS, PROMOTE_STATUS, EMD_URL ,broken_str from EM_MANAGEABLE_ENTITIES where emd_url like '%mysqleng.oracle.com%';

*****************
entity_name                          entity_type            emd_url
--------------------------------------------------------------------------------------
ceumysql.oracle.com:3872       oracle_emd        https://mysqleng.oracle.com:3872/emd/main/
ceumysql.oracle.com                host              https://mysqleng.oracle.com:3872/emd/main/
**************

/gc_inst/em/EMGC_OMS1/sysman/log/emoms_pbs.log reports following ORA-20500 error

2015-11-26 17:52:49,130 [GCLoader[metadata] - https://mysqleng.oracle.com:3872/emd/main/] ERROR gcloader.DataLoader logp.251 - LOADER ERROR: Failed to upload metadata oracle.sysman.emSDK.core.target.DuplicateEntityException: ORA-20500: Multiple hosts detected for :(agent URL = https://mysqleng.oracle.com:3872/emd/main/)
oracle.sysman.emSDK.core.target.DuplicateEntityException: ORA-20500: Multiple hosts detected for :(agent URL = https://mysqleng.oracle.com:3872/emd/main/)
2015-11-26 17:52:49,240 [GCLoader[metadata] - https://mysqleng.oracle.com:3872/emd/main/] ERROR gcloader.Receiver logp.251 - UPLOAD FAILED: emdUrl=https://mysqleng.oracle.com:3872/emd/main/ trackingKey=19.1448578366797 type=metadata e=oracle.sysman.emSDK.core.target.DuplicateEntityException: ORA-20500: Multiple hosts detected for :(agent URL = https://mysqleng.oracle.com:3872/emd/main/)
oracle.sysman.emSDK.core.target.DuplicateEntityException: ORA-20500: Multiple hosts detected for :(agent URL = https://mysqleng.oracle.com:3872/emd/main/)

$emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 12.1.0.4.0
OMS Version            : 12.1.0.4.0
Protocol Version       : 12.1.0.1.0
Agent Home             : C:/OracleAgent12c/agent_inst
Agent Log Directory    : C:/OracleAgent12c/agent_inst\sysman\log
Agent Binaries         : C:\OracleAgent12c\core\12.1.0.4.0
Agent Process ID       : 2500
Parent Process ID      : 3812
Agent URL              : https://mysqleng.oracle.com:3872/emd/main/
Local Agent URL in NAT : https://mysqleng.oracle.com:3872/emd/main/
Repository URL         : https://aidbmonitor.oracle.com:1159/empbs/upload
Started at             : 2015-11-26 14:34:30
Started by user        : MYSQLENG$
Operating System       : Windows version 6.1 (amd64)
Last Reload            : (none)
Last successful upload                       : (none)
Last attempted upload                        : 2015-11-26 14:39:07
Total Megabytes of XML files uploaded so far : 0
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 55.23%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2015-11-26 17:51:46
Last successful heartbeat to OMS             : 2015-11-26 17:51:46
Next scheduled heartbeat to OMS              : 2015-11-26 17:52:46

---------------------------------------------------------------
Agent is Running and Ready

$emctl upload agent

Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully

$emctl config agent addinternaltargets

Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.

$emctl config agent listtargets

Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
$emctl pingOMS
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD pingOMS completed successfully

Shows no internal targets at agent side

$emctl listplugins agent

Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
oracle.sysman.oh    12.1.0.4.0           C:\OracleAgent12c\plugins\oracle.sysman.oh.agent.plugin_12.1.0.4.0

$emctl listplugins agent -type all

Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
oracle.sysman.oh    12.1.0.4.0           C:\OracleAgent12c\plugins\oracle.sysman.oh.agent.plugin_12.1.0.4.0
oracle.mysql.omys   12.1.0.2.0           C:\OracleAgent12c\plugins\oracle.mysql.omys.discovery.plugin_12.1.0.2.0
oracle.sysman.db    12.1.0.6.0           C:\OracleAgent12c\plugins\oracle.sysman.db.discovery.plugin_12.1.0.6.0
oracle.sysman.emas  12.1.0.6.0           C:\OracleAgent12c\plugins\oracle.sysman.emas.discovery.plugin_12.1.0.6.0
oracle.sysman.oh    12.1.0.4.0           C:\OracleAgent12c\plugins\oracle.sysman.oh.discovery.plugin_12.1.0.4.0

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