You can try the following
Use the below query to check status of the target delete
select * from mgmt_targets_delete
where delete_complete_time is null;
You can use the following to force the delete of the database targets
That table is empty ... could it be a bug?
$ sqlplus / as sysdba
SQL*Plus: Release 18.104.22.168.0 Production on Fri Aug 23 17:08:19 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from sysman.mgmt_targets_delete;
no rows selected
Do you see the target in OEM?
Yes, is Up but with "Metric collection error". I can even check the performance of it ( using "Performance Home").
Are there any other targets on the host having issues
Try doing a clear state of the agent
$AGENT_HOME/bin/emctl clearstate agent
There are 8 targets, all working ok (except this one).
(grid)@():/home/grid:>/grid_agent/OracleHomes/agent12c/core/126.96.36.199.0/bin/emctl clearstate agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
EMD clearstate completed successfully
I even tried to resync/resecure/stop-start the agent without sucess.
have you tried to remove the target and add the target back into OEM?
I was hoping to avoid it... but i guess it's the only way to solve the problem. I'll try a few things more and them i will remove it. Thanks