Oracle DBA Tips and Techniques

By Arjun Raja

Archive for February, 2014

DELETE/REMOVE TARGET FROM CLOUD/GRID CONTROL REPOSITORY

Posted by Arjun Raja on February 11, 2014

To remove a target from the database repository –

Login as sysman

SQL> select target_name,target_type from mgmt_targets where target_name like ‘%LN%’;

TARGET_NAME
——————————————————————————–
TARGET_TYPE
—————————————————————-
LNAC_sys
oracle_dbsys

SQL> exec mgmt_admin.delete_target(‘LNAC_sys’,’oracle_dbsys’);

PL/SQL procedure successfully completed.

To delete agent :

SQL> select target_name from mgmt_targets where target_type=’oracle_emd’;
SQL> exec mgmt_admin.cleanup_agent(’Server1:3872′);

Posted in Oracle 12c Cloud Control, Uncategorized | Tagged: , | Leave a Comment »