Grid Control - debug de targets

Limpar agent (remoção de todos os targets, inclusive o agent):

exec mgmt_admin.CLEANUP_AGENT('svr0000.adm.infra:3872');

Apagar targets manualmente:

exec mgmt_admin.delete_target('$NOME_TARGET','$TIPO_TARGET');

Forçar exclusão de targets:

exec mgmt_admin.delete_target_internal('$NOME_TARGET','$TIPO_TARGET');

Bug para inserir novo target:



java.sql.SQLException: ORA-20600: The specified target is in the process of being deleted.(target name = SID)(target type = oracle_database)(target guid = 21D8EFD67CCF409D7CDB41DCFD1F9D94)
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


Workround:


select * from MGMT_TARGETS_LOAD_TIMES where target_guid='21D8EFD67CCF409D7CDB41DCFD1F9D94';

delete from MGMT_TARGETS_LOAD_TIMES where target_guid='21D8EFD67CCF409D7CDB41DCFD1F9D94';