Friday, April 01, 2011

Clean up the Oracle Enterprise Manager installation for re-install.

Installing Oracle Enterprise Manager to monitoring your middleware environment; such as Fusion Applications, Service Bus, SOA Suite is not just a walk in the park. As long you type the correct parameters and checked the pre-requisteis carefully, you could install this via the next-next-finish method.

But if you make a mistake, you would like to re-run the task. The installaer gives you this option, but as this still fails, you like to start all over again.

Te clean up your environment execute the following steps:

  • Remove directories on the application server
  • Change oracle-installer files
  • Remove OEM object from database

rm -rf /opt/weblogic/Middleware/oms11g 
rm -rf /opt/weblogic/Middleware/oracle_common 
rm -rf /opt/weblogic/Middleware/Oracle_WT 
rm -rf /opt/weblogic/Middleware/agent11g 
rm -rf /opt/weblogic/Middleware/.gcinstall_temp
rm -rf /opt/weblogic/gc_inst
vi /home/weblogic/oraInventory/oui/srcs.lst
vi /home/weblogic/oraInventory/ContentsXML/inventory.xml

After removing the directories and change the files that contains the installed products, you have to clean-up the database objects for OEM. This can be done via scripts, such as:

RepManager "database.vijfhuizen.local" 1521 ORCL -action drop

You can also use the following script.

delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';
commit;

drop user mgmt_view cascade;
drop user sysman cascade;
drop user sysman_mds cascade;

drop public synonym SMP_EMD_TARGET_OBJ_ARRAY;
drop public synonym SMP_EMD_TARGET_OBJ;
drop public synonym SMP_EMD_STRING_ARRAY_ARRAY;
drop public synonym SMP_EMD_STRING_ARRAY;
drop public synonym SMP_EMD_NVPAIR_ARRAY;
drop public synonym SMP_EMD_NVPAIR;
drop public synonym SMP_EMD_INTEGER_ARRAY_ARRAY;
drop public synonym SMP_EMD_INTEGER_ARRAY;
drop public synonym SMP_EMD_DELETE_REC_ARRAY;
drop public synonym SMP_EMD_AVAIL_OBJ;
drop public synonym SETEMVIEWUSERCONTEXT;
drop public synonym MGMT_VIEW_UTIL;
drop public synonym MGMT_USER;
drop public synonym MGMT_TYPE_PROPERTIES;
drop public synonym MGMT_TARGET_PROPERTIES;
drop public synonym MGMT_TARGET_MEMBERSHIPS;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym MGMT_TARGETS;
drop public synonym MGMT_TARGET;
drop public synonym MGMT_STRING_METRIC_HISTORY;
drop public synonym MGMT_SEVERITY_OBJ;
drop public synonym MGMT_SEVERITY_ARRAY;
drop public synonym MGMT_SEVERITY;
drop public synonym MGMT_PREFERENCES;
drop public synonym MGMT_PAF_PROCS_LATEST;
drop public synonym MGMT_PAF_JOBS;
drop public synonym MGMT_PAF$STATES;
drop public synonym MGMT_PAF$PROCEDURES;
drop public synonym MGMT_PAF$INSTANCES;
drop public synonym MGMT_PAF$APPLICATIONS;
drop public synonym MGMT_NAME_VALUES;
drop public synonym MGMT_NAME_VALUE;
drop public synonym MGMT_METRIC_THRESHOLDS;
drop public synonym MGMT_METRIC_ERRORS;
drop public synonym MGMT_METRIC_COLLECTIONS;
drop public synonym MGMT_METRICS_RAW;
drop public synonym MGMT_METRICS_COMPOSITE_KEYS;
drop public synonym MGMT_METRICS_1HOUR;
drop public synonym MGMT_METRICS_1DAY;
drop public synonym MGMT_METRICS;
drop public synonym MGMT_MESSAGES;
drop public synonym MGMT_LONG_TEXT;
drop public synonym MGMT_LOG;
drop public synonym MGMT_JOB_TARGET;
drop public synonym MGMT_JOB_SCHEDULE;
drop public synonym MGMT_JOB_PARAMETER;
drop public synonym MGMT_JOB_OUTPUT;
drop public synonym MGMT_JOB_EXEC_SUMMARY;
drop public synonym MGMT_JOB_EXECUTION;
drop public synonym MGMT_JOB_EXECPLAN;
drop public synonym MGMT_JOBS;
drop public synonym MGMT_JOB;
drop public synonym MGMT_IP_TGT_GUID_ARRAY;
drop public synonym MGMT_GUID_OBJ;
drop public synonym MGMT_GUID_ARRAY;
drop public synonym MGMT_GLOBAL;
drop public synonym MGMT_DELTA_VALUES;
drop public synonym MGMT_DELTA_VALUE;
drop public synonym MGMT_DELTA_ID_VALUES;
drop public synonym MGMT_DELTA_IDS;
drop public synonym MGMT_DELTA_ENTRY_VALUES;
drop public synonym MGMT_DELTA_ENTRY;
drop public synonym MGMT_DELTA;
drop public synonym MGMT_CURRENT_SEVERITY;
drop public synonym MGMT_CURRENT_METRIC_ERRORS;
drop public synonym MGMT_CURRENT_METRICS;
drop public synonym MGMT_CURRENT_AVAILABILITY;
drop public synonym MGMT_CREDENTIAL;
drop public synonym MGMT_COLLECTION_PROPERTIES;
drop public synonym MGMT_AVAILABILITY;
drop public synonym MGMT_AS_ECM_UTIL;
drop public synonym MGMT_ADMIN;
drop public synonym MGMT$WEBSPHERE_MODULES;
drop public synonym MGMT$WEBSPHERE_JDBCDATASOURCE;
drop public synonym MGMT$WEBSPHERE_APPLICATION;
drop public synonym MGMT$WEBLOGIC_SERVER;
drop public synonym MGMT$WEBLOGIC_MODULES;
drop public synonym MGMT$WEBLOGIC_JDBCDATASOURCE;
drop public synonym MGMT$WEBLOGIC_APPLICATION;
drop public synonym MGMT$WEBCACHE_TO_OHS_ROUTING;
drop public synonym MGMT$WEBCACHE_SITEMAPPINGS;
drop public synonym MGMT$WEBCACHE_SITEALIASES;
drop public synonym MGMT$WEBCACHE_PERFRELATED;
drop public synonym MGMT$WEBCACHE_ORIGIN_SERVERS;
drop public synonym MGMT$WEBCACHE_ORIGINSERVERS;
drop public synonym MGMT$WEBCACHE_OPERATIONPORTS;
drop public synonym MGMT$WEBCACHE_LISTENPORTS;
drop public synonym MGMT$WEBCACHE_CONFIGFILES;
drop public synonym MGMT$WEBCACHE_CLUSTERMEMBERS;
drop public synonym MGMT$WEBCACHE_CLUSTERINFO;
drop public synonym MGMT$TXN_PERF_RAW;
drop public synonym MGMT$TXN_PERF_HOUR;
drop public synonym MGMT$TXN_PERF_DAY;
drop public synonym MGMT$TEMPLATE_POLICY_SETTINGS;
drop public synonym MGMT$TEMPLATE_METRIC_SETTINGS;
drop public synonym MGMT$TEMPLATE_METRICCOLLECTION;
drop public synonym MGMT$TEMPLATES;
drop public synonym MGMT$TARGET_TYPE_PROPERTIES;
drop public synonym MGMT$TARGET_TYPE_DEF;
drop public synonym MGMT$TARGET_TYPE;
drop public synonym MGMT$TARGET_PROPERTIES;
drop public synonym MGMT$TARGET_POLICY_SETTINGS;
drop public synonym MGMT$TARGET_POLICY_EVAL_SUMM;
drop public synonym MGMT$TARGET_POLICIES;
drop public synonym MGMT$TARGET_NOTIF_METR_NOTCOV;
drop public synonym MGMT$TARGET_NOTIFICATION_RULES;
drop public synonym MGMT$TARGET_METRIC_SETTINGS;
drop public synonym MGMT$TARGET_METRIC_COLLECTIONS;
drop public synonym MGMT$TARGET_MEMBERS;
drop public synonym MGMT$TARGET_FLAT_MEMBERS;
drop public synonym MGMT$TARGET_COMPOSITE;
drop public synonym MGMT$TARGET_COMPONENTS;
drop public synonym MGMT$TARGET_ASSOCIATIONS;
drop public synonym MGMT$TARGET;
drop public synonym MGMT$STORAGE_REPORT_VOLUME;
drop public synonym MGMT$STORAGE_REPORT_PATHS;
drop public synonym MGMT$STORAGE_REPORT_NFS;
drop public synonym MGMT$STORAGE_REPORT_LOCALFS;
drop public synonym MGMT$STORAGE_REPORT_KEYS;
drop public synonym MGMT$STORAGE_REPORT_ISSUES;
drop public synonym MGMT$STORAGE_REPORT_DISK;
drop public synonym MGMT$STORAGE_REPORT_DATA;
drop public synonym MGMT$STEP_METRICS_RAW;
drop public synonym MGMT$STEP_METRICS_HOURLY;
drop public synonym MGMT$STEP_METRICS_DAILY;
drop public synonym MGMT$STEP_GROUPS;
drop public synonym MGMT$STEPS;
drop public synonym MGMT$SOFTWARE_PATCHSETS;
drop public synonym MGMT$SOFTWARE_PATCHES_IN_HOMES;
drop public synonym MGMT$SOFTWARE_OTHERS;
drop public synonym MGMT$SOFTWARE_ONEOFF_PATCHES;
drop public synonym MGMT$SOFTWARE_HOME_PROPERTIES;
drop public synonym MGMT$SOFTWARE_HOMES;
drop public synonym MGMT$SOFTWARE_DEPENDENCIES;
drop public synonym MGMT$SOFTWARE_COMP_PATCHSET;
drop public synonym MGMT$SOFTWARE_COMPONENT_PSU;
drop public synonym MGMT$SOFTWARE_COMPONENT_PATCH;
drop public synonym MGMT$SOFTWARE_COMPONENT_ONEOFF;
drop public synonym MGMT$SOFTWARE_COMPONENTS;
drop public synonym MGMT$RAC_TOPOLOGY;
drop public synonym MGMT$RACDB_INTERCONNECTS;
drop public synonym MGMT$PR_HOME_INFO;
drop public synonym MGMT$PR_HOMES_AFFECTED_COUNT;
drop public synonym MGMT$PR_APPL_PATCHES_TO_OH_TGT;
drop public synonym MGMT$PR_APPL_PATCHES_TO_OH;
drop public synonym MGMT$POLICY_VIOL_NOTIF_LOG;
drop public synonym MGMT$POLICY_VIOL_ANNOTATIONS;
drop public synonym MGMT$POLICY_VIOLATION_HISTORY;
drop public synonym MGMT$POLICY_VIOLATION_CURRENT;
drop public synonym MGMT$POLICY_VIOLATION_CTXT;
drop public synonym MGMT$POLICY_VIOLATION_CONTEXT;
drop public synonym MGMT$POLICY_PARAMETERS;
drop public synonym MGMT$POLICIES;
drop public synonym MGMT$PA_RECOM_METRIC_SOURCE;
drop public synonym MGMT$PA_AFFTED_TARGETS;
drop public synonym MGMT$PA_AFFTED_HOST_OH;
drop public synonym MGMT$PA_AFFTED_HOST_GUID_OH;
drop public synonym MGMT$PATCH_ADVISORIES;
drop public synonym MGMT$OVM_VS_VSP_ASSOC;
drop public synonym MGMT$OVM_VS_PERF_SUMMARY;
drop public synonym MGMT$OVM_OS_HW_SUMMARY;
drop public synonym MGMT$OVM_HW_NIC;
drop public synonym MGMT$OVM_GVM_SUMMARY;
drop public synonym MGMT$OS_SUMMARY;
drop public synonym MGMT$OS_PROPERTIES;
drop public synonym MGMT$OS_PATCHES;
drop public synonym MGMT$OS_KERNEL_PARAMS;
drop public synonym MGMT$OS_HW_SUMMARY;
drop public synonym MGMT$OS_FS_MOUNT;
drop public synonym MGMT$OS_COMPONENTS;
drop public synonym MGMT$ORACLE_SW_GRP_TARGETS;
drop public synonym MGMT$ORACLE_SW_GRP_INSTALL;
drop public synonym MGMT$ORACLE_SW_ENT_TARGETS;
drop public synonym MGMT$ORACLE_SW_ENT_INSTALL;
drop public synonym MGMT$OHS_VIRTUALHOSTS;
drop public synonym MGMT$OHS_PERFRELATED;
drop public synonym MGMT$OHS_LISTENADDRESSES;
drop public synonym MGMT$OHS_GENERAL;
drop public synonym MGMT$OHS_CONFIGFILES;
drop public synonym MGMT$OHS_CIPHERSUITES;
drop public synonym MGMT$OC4J_WEBMODULEURLS;
drop public synonym MGMT$OC4J_WEBMODULESETTINGS;
drop public synonym MGMT$OC4J_RESOURCECONFIG;
drop public synonym MGMT$OC4J_PORTRANGES;
drop public synonym MGMT$OC4J_NATIVEDATASOURCES;
drop public synonym MGMT$OC4J_MODULES;
drop public synonym MGMT$OC4J_MANAGEDDATASOURCES;
drop public synonym MGMT$OC4J_J2EE_MODULES;
drop public synonym MGMT$OC4J_GLOBALWEBSETTINGS;
drop public synonym MGMT$OC4J_DEPLOYED_APPS;
drop public synonym MGMT$OC4J_DEPLOYEDAPPS;
drop public synonym MGMT$OC4J_DATASOURCES;
drop public synonym MGMT$OC4J_CONNECTIONPOOLS;
drop public synonym MGMT$OC4J_CONFIGFILES;
drop public synonym MGMT$OC4J_APPLICATIONINFO;
drop public synonym MGMT$OC4J_ALL_DATA_SOURCES;
drop public synonym MGMT$MS_LATEST_APPLIED;
drop public synonym MGMT$MS_APPLY_HISTORY;
drop public synonym MGMT$MISSING_TARGETS_IN_GROUPS;
drop public synonym MGMT$MISSING_TARGETS;
drop public synonym MGMT$METRIC_HOURLY;
drop public synonym MGMT$METRIC_ERROR_HISTORY;
drop public synonym MGMT$METRIC_ERROR_CURRENT;
drop public synonym MGMT$METRIC_DETAILS_SINGLE_STR;
drop public synonym MGMT$METRIC_DETAILS_SINGLE_NUM;
drop public synonym MGMT$METRIC_DETAILS_MULTI_STR;
drop public synonym MGMT$METRIC_DETAILS_MULTI_NUM;
drop public synonym MGMT$METRIC_DETAILS;
drop public synonym MGMT$METRIC_DAILY;
drop public synonym MGMT$METRIC_CURRENT;
drop public synonym MGMT$METRIC_COLLECTION;
drop public synonym MGMT$METRIC_CATEGORIES;
drop public synonym MGMT$MESSAGES;
drop public synonym MGMT$JOB_TARGETS;
drop public synonym MGMT$JOB_STEP_HISTORY;
drop public synonym MGMT$JOB_NOTIFICATION_LOG;
drop public synonym MGMT$JOB_EXECUTION_HISTORY;
drop public synonym MGMT$JOB_ANNOTATIONS;
drop public synonym MGMT$JOBS;
drop public synonym MGMT$JBOSS_RESCONF;
drop public synonym MGMT$JBOSS_PROTOCONF;
drop public synonym MGMT$JBOSS_POOLSCONF;
drop public synonym MGMT$JBOSS_DSCONF;
drop public synonym MGMT$JBOSS_APPSCONF;
drop public synonym MGMT$INTERFACE_STATS;
drop public synonym MGMT$IAS_SIMPLE_PORTS;
drop public synonym MGMT$IAS_PORT_RANGES;
drop public synonym MGMT$IAS_PORTS;
drop public synonym MGMT$IAS_OPMNCONFIG;
drop public synonym MGMT$IAS_MEMBERTARGETS;
drop public synonym MGMT$IAS_INSTALL_SETTINGS;
drop public synonym MGMT$IAS_GENERAL;
drop public synonym MGMT$IAS_DEPLOYEDAPPS;
drop public synonym MGMT$IAS_DCMCONFIG;
drop public synonym MGMT$IAS_CONSOLECONFIG;
drop public synonym MGMT$IAS_CONFIG_PROPS;
drop public synonym MGMT$IAS_CONFIGFILES;
drop public synonym MGMT$HW_NIC;
drop public synonym MGMT$HOSTPATCH_HOST_COMPL;
drop public synonym MGMT$HOSTPATCH_HOSTS;
drop public synonym MGMT$HOSTPATCH_GRP_COMPL_HIST;
drop public synonym MGMT$HOSTPATCH_GROUPS;
drop public synonym MGMT$HOMES_AFFECTED;
drop public synonym MGMT$HA_RMAN_CONFIG_ALL;
drop public synonym MGMT$HA_RMAN_CONFIG;
drop public synonym MGMT$HA_MTTR;
drop public synonym MGMT$HA_INIT_PARAMS_ALL;
drop public synonym MGMT$HA_INIT_PARAMS;
drop public synonym MGMT$HA_INFO_ALL;
drop public synonym MGMT$HA_INFO;
drop public synonym MGMT$HA_FILES_ALL;
drop public synonym MGMT$HA_FILES;
drop public synonym MGMT$HA_BACKUP;
drop public synonym MGMT$GRP_METRICS_RAW;
drop public synonym MGMT$GRP_METRICS_HOURLY;
drop public synonym MGMT$GRP_METRICS_DAILY;
drop public synonym MGMT$GROUP_MEMBERS;
drop public synonym MGMT$GROUP_FLAT_MEMBERSHIPS;
drop public synonym MGMT$GROUP_DERIVED_MEMBERSHIPS;
drop public synonym MGMT$ESA_WITH_GRANT_REPORT;
drop public synonym MGMT$ESA_WITH_ADMIN_REPORT;
drop public synonym MGMT$ESA_TRC_AUD_PERM_REP_NT;
drop public synonym MGMT$ESA_TRC_AUD_PERM_REPORT;
drop public synonym MGMT$ESA_TABSP_OWNERS_REPORT;
drop public synonym MGMT$ESA_SYS_PUB_PKG_REPORT;
drop public synonym MGMT$ESA_PUB_PRIV_REPORT;
drop public synonym MGMT$ESA_POWER_PRIV_REPORT;
drop public synonym MGMT$ESA_OH_PERMISSION_REPORT;
drop public synonym MGMT$ESA_OH_OWNERSHIP_REPORT;
drop public synonym MGMT$ESA_KEY_OBJECTS_REPORT;
drop public synonym MGMT$ESA_EXMPT_ACCESS_REPORT;
drop public synonym MGMT$ESA_DIRECT_PRIV_REPORT;
drop public synonym MGMT$ESA_DBA_ROLE_REPORT;
drop public synonym MGMT$ESA_DBA_GROUP_REPORT;
drop public synonym MGMT$ESA_CREATE_PRIV_REPORT;
drop public synonym MGMT$ESA_CONN_PRIV_REPORT;
drop public synonym MGMT$ESA_CATALOG_REPORT;
drop public synonym MGMT$ESA_BECOME_USER_REPORT;
drop public synonym MGMT$ESA_AUDIT_SYSTEM_REPORT;
drop public synonym MGMT$ESA_ANY_PRIV_REPORT;
drop public synonym MGMT$ESA_ANY_DICT_REPORT;
drop public synonym MGMT$ESA_ALL_PRIVS_REPORT;
drop public synonym MGMT$EM_HOMES_PLATFORM;
drop public synonym MGMT$ECM_VISIBLE_SNAPSHOTS;
drop public synonym MGMT$ECM_CURRENT_SNAPSHOTS;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY6;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY5;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY4;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY3;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY2;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY1;
drop public synonym MGMT$ECM_CONFIG_HISTORY;
drop public synonym MGMT$E2E_RAW;
drop public synonym MGMT$E2E_HOURLY;
drop public synonym MGMT$E2E_1DAY;
drop public synonym MGMT$DELTA_VIEW_DETAILS;
drop public synonym MGMT$DELTA_VIEW;
drop public synonym MGMT$DELTA_VENDOR_SW;
drop public synonym MGMT$DELTA_PATCHSET_DETAILS;
drop public synonym MGMT$DELTA_PATCHSETS;
drop public synonym MGMT$DELTA_OS_KERNEL_PARAMS;
drop public synonym MGMT$DELTA_OS_COMP_DETAILS;
drop public synonym MGMT$DELTA_OS_COMPONENTS;
drop public synonym MGMT$DELTA_ORACLE_HOME;
drop public synonym MGMT$DELTA_ONEOFF_PATCHES;
drop public synonym MGMT$DELTA_INIT;
drop public synonym MGMT$DELTA_HOST_CONFIG;
drop public synonym MGMT$DELTA_HARDWARE;
drop public synonym MGMT$DELTA_FS_MOUNT;
drop public synonym MGMT$DELTA_COMPONENT_DETAILS;
drop public synonym MGMT$DELTA_COMPONENTS;
drop public synonym MGMT$DB_TABLESPACES_ALL;
drop public synonym MGMT$DB_TABLESPACES;
drop public synonym MGMT$DB_SGA_ALL;
drop public synonym MGMT$DB_SGA;
drop public synonym MGMT$DB_ROLLBACK_SEGS_ALL;
drop public synonym MGMT$DB_ROLLBACK_SEGS;
drop public synonym MGMT$DB_REDOLOGS_ALL;
drop public synonym MGMT$DB_REDOLOGS;
drop public synonym MGMT$DB_OPTIONS_ALL;
drop public synonym MGMT$DB_OPTIONS;
drop public synonym MGMT$DB_LICENSE_ALL;
drop public synonym MGMT$DB_LICENSE;
drop public synonym MGMT$DB_INIT_PARAMS_ALL;
drop public synonym MGMT$DB_INIT_PARAMS;
drop public synonym MGMT$DB_FEATUREUSAGE;
drop public synonym MGMT$DB_DBNINSTANCEINFO_ALL;
drop public synonym MGMT$DB_DBNINSTANCEINFO;
drop public synonym MGMT$DB_DATAFILES_ALL;
drop public synonym MGMT$DB_DATAFILES;
drop public synonym MGMT$DB_CONTROLFILES_ALL;
drop public synonym MGMT$DB_CONTROLFILES;
drop public synonym MGMT$CS_EVAL_SUMMARY_STANDARD;
drop public synonym MGMT$CS_EVAL_SUMMARY_RULE;
drop public synonym MGMT$CS_CONFIG_STANDARDS;
drop public synonym MGMT$CSM_WATCHLIST;
drop public synonym MGMT$CSM_URL_HOURLY;
drop public synonym MGMT$CSM_URL_DIST_HOURLY;
drop public synonym MGMT$CSM_URL_DIST_DAILY;
drop public synonym MGMT$CSM_URL_DAILY;
drop public synonym MGMT$CSM_SUBNET_HOURLY;
drop public synonym MGMT$CSM_SUBNET_DIST_HOURLY;
drop public synonym MGMT$CSM_SUBNET_DIST_DAILY;
drop public synonym MGMT$CSM_SUBNET_DAILY;
drop public synonym MGMT$CSM_REGION_HOURLY;
drop public synonym MGMT$CSM_REGION_DIST_HOURLY;
drop public synonym MGMT$CSM_REGION_DIST_DAILY;
drop public synonym MGMT$CSM_REGION_DAILY;
drop public synonym MGMT$CSM_REGION;
drop public synonym MGMT$CSM_MT_URL_HOURLY;
drop public synonym MGMT$CSM_MT_URL_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_URL_DIST_DAILY;
drop public synonym MGMT$CSM_MT_URL_DAILY;
drop public synonym MGMT$CSM_MT_METRIC_DETAILS;
drop public synonym MGMT$CSM_MT_IP_HOURLY;
drop public synonym MGMT$CSM_MT_IP_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_IP_DIST_DAILY;
drop public synonym MGMT$CSM_MT_IP_DAILY;
drop public synonym MGMT$CSM_MT_DSR_HOURLY;
drop public synonym MGMT$CSM_MT_DSR_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_DSR_DIST_DAILY;
drop public synonym MGMT$CSM_MT_DSR_DAILY;
drop public synonym MGMT$CSM_METRIC_DETAILS;
drop public synonym MGMT$CSM_IP_HOURLY;
drop public synonym MGMT$CSM_IP_DIST_HOURLY;
drop public synonym MGMT$CSM_IP_DIST_DAILY;
drop public synonym MGMT$CSM_IP_DAILY;
drop public synonym MGMT$CSM_DOMAIN_HOURLY;
drop public synonym MGMT$CSM_DOMAIN_DIST_HOURLY;
drop public synonym MGMT$CSM_DOMAIN_DIST_DAILY;
drop public synonym MGMT$CSM_DOMAIN_DAILY;
drop public synonym MGMT$CSA_HOST_SW;
drop public synonym MGMT$CSA_HOST_RULES;
drop public synonym MGMT$CSA_HOST_OS_PROPERTIES;
drop public synonym MGMT$CSA_HOST_OS_FILESYSTEMS;
drop public synonym MGMT$CSA_HOST_OS_COMPONENTS;
drop public synonym MGMT$CSA_HOST_NICS;
drop public synonym MGMT$CSA_HOST_IOCARDS;
drop public synonym MGMT$CSA_HOST_CUSTOM;
drop public synonym MGMT$CSA_HOST_CPUS;
drop public synonym MGMT$CSA_HOST_COOKIES;
drop public synonym MGMT$CSA_FAILED;
drop public synonym MGMT$CSA_COLLECTIONS;
drop public synonym MGMT$CSA_CLIENT_RULE_VIOLS;
drop public synonym MGMT$CSA_CLIENTS;
drop public synonym MGMT$CPF_PATCH_INFO;
drop public synonym MGMT$CPF_PATCH_DATA;
drop public synonym MGMT$CPF_HOMES_INFO;
drop public synonym MGMT$CPF_ADVISORY_INFO;
drop public synonym MGMT$CONNECTOR_TYPE;
drop public synonym MGMT$CONNECTOR;
drop public synonym MGMT$CLUSTER_INTERCONNECTS;
drop public synonym MGMT$BLACKOUT_HISTORY;
drop public synonym MGMT$BLACKOUTS;
drop public synonym MGMT$AVAIL_ALERT_HISTORY;
drop public synonym MGMT$AVAILABILITY_HISTORY;
drop public synonym MGMT$AVAILABILITY_CURRENT;
drop public synonym MGMT$AUDIT_LOG;
drop public synonym MGMT$APPL_PATCH_AND_PATCHSET;
drop public synonym MGMT$APPLIED_PATCHSETS;
drop public synonym MGMT$APPLIED_PATCHES;
drop public synonym MGMT$ALERT_NOTIF_LOG;
drop public synonym MGMT$ALERT_HISTORY;
drop public synonym MGMT$ALERT_CURRENT;
drop public synonym MGMT$ALERT_ANNOTATIONS;
drop public synonym EMD_MNTR;
drop public synonym ECM_UTIL;
drop synonym DBSNMP.MGMT_EMREP_OOB_MONITORING;

drop tablespace mgmt_tablespace including contents and datafiles cascade constraints;
drop tablespace mgmt_ecm_depot_ts including contents and datafiles cascade constraints;
drop tablespace mgmt_ad4j_ts including contents and datafiles cascade constraints;