-
1. Re: How to remove a member from "database system" in EM12c Cloud Control?
Satya Chandan-Oracle Sep 6, 2018 5:44 PM (in response to 2850698)Hello,
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.
Warning
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)
Regards,
Satya
-
2. Re: How to remove a member from "database system" in EM12c Cloud Control?
Nishant Baurai Sep 6, 2018 5:56 PM (in response to 2850698)Hi,
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
Regards,
Nishant
-
3. Re: How to remove a member from "database system" in EM12c Cloud Control?
2850698 Sep 6, 2018 6:11 PM (in response to Satya Chandan-Oracle)I'm not trying to remove database system but only a member of it.
-
4. Re: How to remove a member from "database system" in EM12c Cloud Control?
Sharma,Deepak Sep 6, 2018 6:23 PM (in response to 2850698)Did you tried using emcli from the OMS server?
-
6. Re: How to remove a member from "database system" in EM12c Cloud Control?
2850698 Sep 6, 2018 9:09 PM (in response to Nishant Baurai)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)
-
7. Re: How to remove a member from "database system" in EM12c Cloud Control?
2850698 Sep 7, 2018 2:01 AM (in response to Sharma,Deepak)If this is something that can be done through GUI, I prefer using GUI.
I'm not familiar with emcli.
-
8. Re: How to remove a member from "database system" in EM12c Cloud Control?
Ian Baugaard Sep 7, 2018 7:41 AM (in response to 2850698)Hi,
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?
Thanks
Ian
-
9. Re: How to remove a member from "database system" in EM12c Cloud Control?
2850698 Sep 7, 2018 5:44 PM (in response to Ian Baugaard)6 members:
2 Database Instance
2 Listener
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?
-
10. Re: How to remove a member from "database system" in EM12c Cloud Control?
Sharma,Deepak Sep 7, 2018 6:03 PM (in response to 2850698)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:
emcli sync
3)Get the list of targets
emcli get_target
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>"
Example:
$./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