Adding a target in Grid Control fails with either "ora-20600: The specified target is in the process of being deleted" or "Duplicate Name Exists" or "No Cluster is detected on the host (Doc ID 436679.1)

Last updated on JUNE 10, 2016

Applies to:

Enterprise Manager Base Platform - Version 10.1.0.4 to 11.1.0.1 [Release 10.1 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 07-Aug-2013

Symptoms

This problem occurs when adding a target to Grid Control. This same target has been previously removed from the Grid Control console, and is now being added back There are various symptoms to this problem, not all symptoms are seen on all systems. Symptoms can be dependent on the version of Grid Control, and the target type being added. In all cases there is an error shown on the console when adding a target. In all cases, the target has previously been discovered by the OMS but has been deleted. The error occurs when attempting to add the target (after it has previously been deleted). In all cases the target no longer exists in sysman.mgmt_targets. Symptoms can include:-

 

ORA-20600: The specified target is in the process of being deleted.(target name = ORCL.WORLD)(target type = oracle_database)(target guid = C8D7E24B75CAFAF5E95EE30D146827E0) ORA-06512: at "SYSMAN.TARGETS_INSERT_TRIGGER", line 24 ORA-04088: error during execution of trigger
'SYSMAN.TARGETS_INSERT_TRIGGER' ORA-06512: at "SYSMAN.MGMT_TARGET", line 2720 ORA-06512: at line 1


ORA-20600: The specified target is in the process of being deleted.(target name = ORACLE1)(target type = rac_database)(target guid = EFCA9943F435914CB2C0B4D3E493CC33)


exception ORA-20600: The specified target is in the process of being deleted. Either the target is not cleaned completely or the deletion is still in progress. (target name = my_cluster)(target type = cluster)(target guid = 3134A4B0BAD2F22214A2BA5E69038E97)
ORA-06512: at "SYSMAN.TARGETS_AVAILABILITY_DEFAULT", line 115
ORA-04088: error during execution of trigger 'SYSMAN.TARGETS_AVAILABILITY_DEFAULT'

 

 

Duplicate Name exists

or

No cluster is detected on the host

 

 

2011-10-28 14:16:12,323 [Thread-47] ERROR perf.sitemap saveProperties.1715 - Exception caught when saving to repository
java.sql.SQLException: ORA-20600: The specified target is in the process of being deleted.(target name = TEST01)(target type = rac_database)(target guid = 8DB9F199AB853A9A1BDFA327D5634E0C)
ORA-06512: at "SYSMAN.TARGETS_INSERT_TRIGGER", line 36
ORA-04088: error during execution of trigger 'SYSMAN.TARGETS_INSERT_TRIGGER'
ORA-06512: at "SYSMAN.EM_TARGET", line 1918
ORA-06512: at "SYSMAN.MGMT_TARGET", line 2705
ORA-06512: at line 1
The target being added will not exist in the repository if queried from mgmt_targets eg. Log into the repository database as sysman/<sysman password> using sql*plus:-

SQL> select target_name, target_type, target_guid from mgmt_targets where target_name='&target_name' and target_type='&target_type';

tip: target_type will generally be one of:-
oracle_database, rac_database, oracle_listener, cluster, osm_instance etc.
The target type for a particular target can be checked via the entry for this target in the <AGENT_HOME>/sysman/emd/targets.xml file)

 

 

In some cases, the target will still exist in the agent's $ORACLE_HOME/sysman/config/emd/targets.xml file and will be considered a monitored target by the agent. This can be checked via:-

emctl config agent listtargets

In some cases, the target will no longer exist in the agent targets.xml file.

 

 

2009-06-05 10:13:26,260 [SeverityLoad https://:3872/emd/main/] DEBUG XMLLoader.Handler processInsertException.471 -
Process Insert SQL Exception ORA-20613: Severity for unknown target.
(target guid = D7F75B1E22346D7CD4EB4D413813A4DA)
ORA-06512: at "SYSMAN.EM_VIOLATION_CHECKS", line 197
ORA-04088: error during execution of trigger 'SYSMAN.EM_VIOLATION_CHECKS'
loadFile = null emdURL = https://<machineName>:3872/emd/main/
java.sql.SQLException: ORA-20613: Severity for unknown target. (target guid =
D7F75B1E22346D7CD4EB4D413813A4DA)
ORA-06512: at "SYSMAN.EM_VIOLATION_CHECKS", line 197
ORA-04088: error during execution of trigger 'SYSMAN.EM_VIOLATION_CHECKS'



Changes

Target has been previously discovered by Grid Control, but then deleted and is now being added back.

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