# Remove a host from Enterprise Manager Cloud Control (OMS) API

**URL:** <https://www.batmunkh.net/t/remove-a-host-from-enterprise-manager-cloud-control-oms-api/1308>\
**Category:** Oracle Database\
**Tags:** em, cloud-control, oms\
**Created:** [September 7, 2021, 4:10pm UTC](https://www.batmunkh.net/t/remove-a-host-from-enterprise-manager-cloud-control-oms-api/1308 "2021-09-07T16:10:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [September 7, 2021, 4:10pm UTC](https://www.batmunkh.net/t/remove-a-host-from-enterprise-manager-cloud-control-oms-api/1308/1 "2021-09-07T16:10:38Z")

</div>

OMS -с зарим устахгүй болсон host уудыг SQL промптоос устгаж болно

1. host -оо олно

```auto
set lin200
col target_name for a66
select distinct target_name,target_type from SYSMAN.MGMT$TARGET where target_name like ‘%HOSTNAME%’

```

1. host-ийг устгана

```auto
SQL> exec sysman.mgmt_admin.cleanup_agent('HOSTNAME.ORACLOUD.MN:3872');

PL/SQL procedure successfully completed.

SQL>

```