Borndba

My OMS installed in very poor configuration. Can’t take any load. I applied a template by mistake for 750 target in a shot. My OMS crashed. It didnt’ came up. I tried bouncing, no luck. But i see some activity in my trace file.
Looks like it’s applying or doing something.
Ok, how long it is going to take before my OMS back up. Since my OMS crashed i can’t see how many pending jobs. Here i used below query to figure out how much pending and how much completed.

SELECT target_type “Target Type”,
target_name “Destination Target”,
template_name “Last Applied Template”,
copy_type “Apply Option”,
execution_status “Status”
FROM
(
SELECT mts.template_name template_name,
mt.target_name target_name,
mt.target_type target_type,
mtc.copy_type copy_type,
DECODE(muodt.execution_status,
1, ‘PENDING’,
5, ‘COMPLETE’,
2, ‘EXECUTING’,
3, ‘ABORTED’,
4, ‘FAILED’) execution_status,
mtc.created_date,
RANK () OVER (PARTITION BY mt.target_name,mt.target_type ORDER BY mtc.created_date
DESC ) rk
FROM mgmt_update_operations_details muodt,
mgmt_update_operations_data muoda,
mgmt_update_template_data_map mutdm,
mgmt_template_copies mtc,
mgmt_targets mt,
mgmt_templates mts
WHERE muodt.operation_guid = muoda.operation_guid
AND muoda.data_set_guid = mutdm.data_set_guid
AND muoda.data_set_type = 4
AND mutdm.template_copy_guid = mtc.template_copy_guid
AND mt.target_guid = muodt.destination_target_guid
AND mtc.template_guid = mts.template_guid
)
WHERE rk <=1
and template_name ='Prod - Database - Template' ==> my template name
ORDER BY 1,3,2 ;

convert this post to pdf.

I am trying to remove agent from OEM. It’s running for quite a while and no result seen. If your case is like this, you can use below command to remove.

exec mgmt_admin.cleanup_agent(‘hostname:1830′);

if you want to delete any target from command line use

exec mgmt_admin.delete_target(‘target_name’,'oracle_database’);

followed by

commit;

convert this post to pdf.