##########################
## Error
##########################
ORA-20600: The specified target is in the process of being deleted.
### Full Error
Saving instance oralin_1 to repository and agent https://host01:3872/emd/main...java.sql.SQLException: ORA-20600: The specified target is in the process of being deleted.(target name = oralin_1)(target type = oracle_database)(target guid = 31427C7C89C2C89148EB7B775E90E20D) ORA-06512: at "SYSMAN.TARGETS_INSERT_TRIGGER", line 46 ORA-04088: error during execution of trigger 'SYSMAN.TARGETS_INSERT_TRIGGER' ORA-06512: at "SYSMAN.EM_TARGET", line 2283 ORA-06512: at "SYSMAN.MGMT_TARGET", line 2720 ORA-06512: at line 1
... finished.
Saving instance oralin_2 to repository and agent https://host02:3872/emd/main... ... finished.
Properties for instance oralin have been updated.
##########################
# Error Occurred
##########################
When trying to add “oralin_1” instance in OEM. Above errors has occurred.
##########################
## Command Executed
##########################
Add instance of a cluster in OEM
##########################
## Issue Description.
##########################
Couple of minutes back, “oralin_1” instance was deleted through OEM and the same was tried to add back.
Checking the instance registration details in OEM Repository database,
Set lines 200
col target_name for a30
select target_name, target_type, target_guid from mgmt_targets where target_name like '%oralin%' and target_type='oracle_database';
TARGET_NAME TARGET_TYPE TARGET_GUID
------------------------------ ---------------------------------------------------------------- --------------------------------
oralin_2 oracle_database 83F1FC27B89BAEFB9F4077620D700303
##########################
## Solution
##########################
Only the 2nd instance details were available. So tried to register the same after 2 minutes and it worked like charm.
TARGET_NAME TARGET_TYPE TARGET_GUID
------------------------------ ---------------------------------------------------------------- --------------------------------
oralin_2 oracle_database 83F1FC27B89BAEFB9F4077620D700303
oralin_1 oracle_database 31427C7C89C2C89148EB7B775E90E20D
