Any specific reason you want to remove just the Database System (suffix_sys) target? When the related Database Target is removed from OEM Cloud Control the system target is removed automatically.
You have chosen to remove the target SID (Database Instance). This database target is associated with database system and service. Removing the database target will delete the following associated targets. Do you want to proceed?
- Database System (SID_sys)
- Database Services (4)
You can not remove the 'database system' (e.g ORCL_sys) target only. If you try to remove the 'database system' target it will remove the other member targets within it and you will see the following message before proceeding:
You have chosen to remove the target ORCL_sys (Database System). This database system has database target ORCL (Database Instance) as key member. The database target will also be removed if the database system is removed. Do you want to proceed?
For more information about 'database system' target see Doc ID 1543605.1: EM 12c, EM 13c: Understanding the Database System (oracle_dbsys) Target in Enterprise Manager Cloud Control 12c and 13c
I'm not trying to remove database system but only a member of it.
Did you tried using emcli from the OMS server?
This will also remove the database system and I do not want to remove the database system too.
I believe you will get this warning:
You have chosen to remove the target ORCL (Database Instance). This database target is associated with database system. Removing the database target will delete the following associated targets. Do you want to proceed?
- Database System (ORCL_sys)
If this is something that can be done through GUI, I prefer using GUI.
I'm not familiar with emcli.
Could you please give us some more information? You have a database system with 'x' number of members. Could you please provide a listing of members (And their target types) and also indicate which member you want to remove?
2 Database Instance
2 Oracle Home
So, I want to remove 1 Database Instance, 1 Listener and 1 Oracle Home.
I believe this is the result of adding Database Instance which has same name as existing Database Instance in Cloud Control. The new Database Instance will be named with suffix 1 automatically and added to the existing Database System by default.
Does EM12c offer any way to disassociate member from database system in GUI or commnad line (emcli) at all?
You can delete a target using emcli:
1)Login to EMCLI from your OMS server
emcli login -username=sysman -password=XXXXX
2)Then sync your targets:
3)Get the list of targets
4)To delete an agent and its targets
$ emcli delete_target -name=”target_host_name:3872″ -type=”oracle_emd” -delete_monitored_targets
Note: The above deletes the Agent and ALL its monitored targets from the repository.
- "-delete_monitored_targets" : Delete the targets monitored by the specified Management Agent. Applicable only with the oracle_emd target type.
5) To delete a specific target:
$<EMCLI_HOME>/emcli delete_target -name="<target_name>" -type="<target_type>"
$./emcli get_targets -targets="DBname:oracle_database"
$./emcli delete_target -name="DB1" -type="oracle_database" -delete_monitored_targets -async
You can also follow the instructions at Oracle DOC ID:1459204.1