Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add target database to EM 12c fails w/ duplicate entity error message...

BurmaShaveMar 1 2013 — edited Mar 5 2013
This is making me nuts...

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...
SQL> begin
2 mgmt_admin.delete_target_internal('BIDEV','oracle_database');
3 end;
4 /
begin
*
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:

oracle@d-bidb $ $AGENT_HOME/emctl config agent listtargets
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
[d-bidb.foo.com, host]
[d-bidb.foo.com:3872, oracle_emd]
[agent12c3_16_d-bidb, oracle_home]
[LISTENER_d-bidb.foo.com, oracle_listener]
[OraDb11g_home1_1_d-bidb, oracle_home]
[BITST.foo.com, oracle_database]

I'm not seeing the solution. Can someone provide some guidance please? Are there particular EM repository sysman tables to check or perhaps configuration files?

Any help is much appreciated. - thx.

Edited by: user12877664 on Mar 1, 2013 10:51 AM

Edited by: user12877664 on Mar 1, 2013 10:55 AM

Edited by: user12877664 on Mar 1, 2013 11:16 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2013
Added on Mar 1 2013
2 comments
5,135 views