Adding a target sparc-based 11.2 database in EM 12c fails with the following error:
oracle.sysman.emSDK.core.target.DuplicateEntityException: ORA-20500: BIDEV.foo.com:oracle_database:d-bidb.foo.com:https://d-bidb.foo.com:3872/emd/main/:3:0 ORA-06512: at "SYSMAN.EM_TARGET", line 3377 ORA-06512: at line 1 - ORA-20500: BIDEV.foo.com:oracle_database:d-bidb.foo.com:https://d-bidb.foo.com:3872/emd/main/:3:0 ORA-06512: at "SYSMAN.EM_TARGET", line 3377 ORA-06512: at line 1
I've tried: exec mgmt_admin.delete_target('BIDEV','oracle_database'); but that accomplishes nothing. Also...
ERROR at line 1:
ORA-20206: The target does not exist or may have already been deleted: Target
name = BIDEV and Target type = oracle_database
ORA-06512: at "SYSMAN.MGMT_ADMIN", line 1117
ORA-06512: at line 2
I dropped the existing local EM repository for the database and reattempted adding the target resulting in the same failure.
Select TARGET_NAME from sysman.mgmt_targets_delete; returns zero rows.
On the target host where the mgmt agent and BIDEV db server resides, the following emctl command does not identify that the mgmt agent knows it exists:
Jayakumar, thank you for the response and clarification of the procedures. Remarkably, this problem fixed itself somehow?? Yesterday I cannot register the BIDEV.foo.com and today I open OEM and bingo...it is registered and the omagent has been gathering data for almost a week ??? So, I dunno what finally reset...
I reviewed the autodiscovery output and there was a duplicate entry for BIDEV.foo.com_1 which I deleted after the fact.
Finally, I'm not sure what you mean by "12c BP1 or 12c PS1".