Oracle DBA Tips and Techniques

By Arjun Raja

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′);

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: