jinfeng_wang

G-G-S,D-D-U!
BlogJava
管理
400 Posts :: 0 Stories :: 296 Comments :: 0 Trackbacks
oracle11g install dbcontrol
1) Command: emca -deconfig dbcontrol db -repos drop
2)
drop user SYSMAN cascade;

drop user MGMT_VIEW cascade;

drop role MGMT_USER;

drop public synonym MGMT_TARGET_BLACKOUTS;

drop public synonym SETEMVIEWUSERCONTEXT;
drop user sysman cascade;

drop public synonym MGMT_ADMIN;

drop public synonym MGMT_AS_ECM_UTIL;

drop public synonym MGMT_AVAILABILITY;

drop public synonym MGMT_COLLECTION_PROPERTIES;

drop public synonym MGMT_CREDENTIAL;

drop public synonym MGMT_CURRENT_AVAILABILITY;

drop public synonym MGMT_CURRENT_METRICS;

drop public synonym MGMT_CURRENT_METRIC_ERRORS;

drop public synonym MGMT_CURRENT_SEVERITY;

drop public synonym MGMT_DELTA;

drop public synonym MGMT_DELTA_ENTRY;

drop public synonym MGMT_DELTA_ENTRY_VALUES;

drop public synonym MGMT_DELTA_IDS;

drop public synonym MGMT_DELTA_ID_VALUES;

drop public synonym MGMT_DELTA_VALUE;

drop public synonym MGMT_DELTA_VALUES;

drop public synonym MGMT_GLOBAL;

drop public synonym MGMT_GUID_ARRAY;

drop public synonym MGMT_GUID_OBJ;

drop public synonym MGMT_IP_TGT_GUID_ARRAY;

drop public synonym MGMT_JOB;

drop public synonym MGMT_JOBS;

drop public synonym MGMT_JOB_EXECPLAN;

drop public synonym MGMT_JOB_EXECUTION;

drop public synonym MGMT_JOB_EXEC_SUMMARY;

drop public synonym MGMT_JOB_OUTPUT;

drop public synonym MGMT_JOB_PARAMETER;

drop public synonym MGMT_JOB_SCHEDULE;

drop public synonym MGMT_JOB_TARGET;

drop public synonym MGMT_LOG;

drop public synonym MGMT_LONG_TEXT;

drop public synonym MGMT_MESSAGES;

drop public synonym MGMT_METRICS;drop public synonym MGMT_METRICS_1DAY;

drop public synonym MGMT_METRICS_1HOUR;

drop public synonym MGMT_METRICS_COMPOSITE_KEYS;

drop public synonym MGMT_METRICS_RAW;

drop public synonym MGMT_METRIC_COLLECTIONS;

drop public synonym MGMT_METRIC_ERRORS;

drop public synonym MGMT_METRIC_THRESHOLDS;

drop public synonym MGMT_NAME_VALUE;

drop public synonym MGMT_NAME_VALUES;

drop public synonym MGMT_PREFERENCES;

drop public synonym MGMT_SEVERITY;

drop public synonym MGMT_SEVERITY_ARRAY;

drop public synonym MGMT_SEVERITY_OBJ;

drop public synonym MGMT_STRING_METRIC_HISTORY;

drop public synonym MGMT_TARGET;

drop public synonym MGMT_TARGETS;

drop public synonym MGMT_TARGET_BLACKOUTS;

drop public synonym MGMT_TARGET_MEMBERSHIPS;

drop public synonym MGMT_TARGET_PROPERTIES;

drop public synonym MGMT_TYPE_PROPERTIES;

drop public synonym MGMT_USER;

drop public synonym MGMT_VIEW_UTIL;

drop public synonym MGMT$DELTA_ORACLE_HOME;

drop public synonym MGMT$DELTA_OS_COMPONENTS;

drop public synonym MGMT$DELTA_OS_COMP_DETAILS;

drop public synonym MGMT$DELTA_OS_KERNEL_PARAMS;

drop public synonym MGMT$DELTA_PATCHSETS;

drop public synonym MGMT$DELTA_PATCHSET_DETAILS;

drop public synonym MGMT$DELTA_TABLESPACES;

drop public synonym MGMT$DELTA_VENDOR_SW;

drop public synonym MGMT$DELTA_VIEW;

drop public synonym MGMT$DELTA_VIEW_DETAILS;

drop public synonym MGMT$ECM_CURRENT_SNAPSHOTS;

drop public synonym MGMT$ECM_VISIBLE_SNAPSHOTS;

drop public synonym MGMT$GROUP_DERIVED_MEMBERSHIPS;

drop public synonym MGMT$GROUP_FLAT_MEMBERSHIPS;

drop public synonym MGMT$GROUP_MEMBERS;

drop public synonym MGMT$HA_BACKUP;

drop public synonym MGMT$HA_FILES;

drop public synonym MGMT$HA_INFO;

drop public synonym MGMT$HA_INIT_PARAMS;

drop public synonym MGMT$HA_MTTR;

drop public synonym MGMT$HA_RMAN_CONFIG;

drop public synonym MGMT$HW_NIC;

drop public synonym MGMT$METRIC_COLLECTION;

drop public synonym MGMT$METRIC_CURRENT;

drop public synonym MGMT$METRIC_DAILY;

drop public synonym MGMT$METRIC_DETAILS;

drop public synonym MGMT$METRIC_HOURLY;

drop public synonym MGMT$MISSING_TARGETS;

drop public synonym MGMT$MISSING_TARGETS_IN_GROUPS;

drop public synonym MGMT$OS_COMPONENTS;

drop public synonym MGMT$OS_FS_MOUNT;

drop public synonym MGMT$OS_HW_SUMMARY;

drop public synonym MGMT$OS_KERNEL_PARAMS;

drop public synonym MGMT$OS_PATCHES;

drop public synonym MGMT$OS_SUMMARY;

drop public synonym MGMT$SOFTWARE_COMPONENTS;

drop public synonym MGMT$SOFTWARE_COMPONENT_ONEOFF;

drop public synonym MGMT$SOFTWARE_COMP_PATCHSET;

drop public synonym MGMT$SOFTWARE_DEPENDENCIES;

drop public synonym MGMT$SOFTWARE_HOMES;

drop public synonym MGMT$SOFTWARE_ONEOFF_PATCHES;

drop public synonym MGMT$SOFTWARE_OTHERS;

drop public synonym MGMT$SOFTWARE_PATCHES_IN_HOMES;

drop public synonym MGMT$SOFTWARE_PATCHSETS;

drop public synonym MGMT$TARGET;

drop public synonym MGMT$TARGET_COMPONENTS;

drop public synonym MGMT$TARGET_COMPOSITE;

drop public synonym MGMT$TARGET_PROPERTIES;

drop public synonym MGMT$TARGET_TYPE;

drop PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;

drop public synonym EMD_MNTR;

drop public synonym SMP_EMD_AVAIL_OBJ;

drop public synonym SMP_EMD_DELETE_REC_ARRAY;

drop public synonym SMP_EMD_INTEGER_ARRAY;

drop public synonym SMP_EMD_INTEGER_ARRAY_ARRAY;

drop public synonym SMP_EMD_NVPAIR;

drop public synonym SMP_EMD_NVPAIR_ARRAY;

drop public synonym SMP_EMD_STRING_ARRAY;

drop public synonym SMP_EMD_STRING_ARRAY_ARRAY;

drop public synonym SMP_EMD_TARGET_OBJ;

drop public synonym SMP_EMD_TARGET_OBJ_ARRAY;

drop public synonym ECM_UTIL;

drop role mgmt_user;


DROP USER sysman CASCADE;

DROP USER mgmt_view CASCADE;

DROP ROLE MGMT_USER;

ALTER USER dbsnmp ACCOUNT UNLOCK;

ALTER USER dbsnmp identified by dbsnmp;

DROP PUBLIC SYNONYM SETEMVIEWUSERCONTEXT;

DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;

DROP PUBLIC SYNONYM MGMT_AVAILABILITY;

DROP PUBLIC SYNONYM MGMT_CURRENT_AVAILABILITY;

DROP PUBLIC SYNONYM MGMT_SEVERITY_OBJ;

DROP PUBLIC SYNONYM MGMT_SEVERITY_ARRAY;

DROP PUBLIC SYNONYM MGMT_GUID_OBJ; 

DROP PUBLIC SYNONYM MGMT_GUID_ARRAY;

DROP PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;

DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ;

DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ_ARRAY;

DROP PUBLIC SYNONYM SMP_EMD_DELETE_REC_ARRAY;

DROP PUBLIC SYNONYM MGMT_METRICS;

DROP PUBLIC SYNONYM MGMT_TARGETS;

DROP PUBLIC SYNONYM MGMT_TYPE_PROPERTIES;

DROP PUBLIC SYNONYM MGMT_TARGET_PROPERTIES; 

DROP PUBLIC SYNONYM MGMT_METRICS_RAW; 

DROP PUBLIC SYNONYM MGMT_CURRENT_METRICS; 

DROP PUBLIC SYNONYM MGMT_STRING_METRIC_HISTORY; 

DROP PUBLIC SYNONYM MGMT_LONG_TEXT; 

DROP PUBLIC SYNONYM MGMT_METRICS_COMPOSITE_KEYS; 

DROP PUBLIC SYNONYM MGMT_METRICS_1HOUR; 

DROP PUBLIC SYNONYM MGMT_METRICS_1DAY; 

DROP PUBLIC SYNONYM MGMT_METRIC_ERRORS; 

DROP PUBLIC SYNONYM MGMT_CURRENT_METRIC_ERRORS; 

DROP PUBLIC SYNONYM EMD_MNTR; 

DROP PUBLIC SYNONYM MGMT_METRIC_COLLECTIONS; 

DROP PUBLIC SYNONYM MGMT_COLLECTION_PROPERTIES ; 

DROP PUBLIC SYNONYM MGMT_METRIC_THRESHOLDS; 

DROP PUBLIC SYNONYM SMP_EMD_NVPAIR; 

DROP PUBLIC SYNONYM SMP_EMD_NVPAIR_ARRAY; 

DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY;

DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY_ARRAY;

DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY;

DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY_ARRAY;

DROP PUBLIC SYNONYM MGMT_DELTA_IDS;

DROP PUBLIC SYNONYM MGMT_DELTA_ID_VALUES;

DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY;

DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY_VALUES;

DROP PUBLIC SYNONYM MGMT_DELTA_VALUE;

DROP PUBLIC SYNONYM MGMT_DELTA_VALUES;

DROP PUBLIC SYNONYM MGMT_NAME_VALUE;

DROP PUBLIC SYNONYM MGMT_NAME_VALUES;

DROP PUBLIC SYNONYM ECM_UTIL;
DROP PUBLIC SYNONYM MGMT_DELTA;

DROP PUBLIC SYNONYM MGMT_TARGET_MEMBERSHIPS;

DROP PUBLIC SYNONYM MGMT_JOB;

DROP PUBLIC SYNONYM MGMT_JOB_PARAMETER;

DROP PUBLIC SYNONYM MGMT_JOB_TARGET;

DROP PUBLIC SYNONYM MGMT_JOB_SCHEDULE;

DROP PUBLIC SYNONYM MGMT_JOB_EXECPLAN;

DROP PUBLIC SYNONYM MGMT_JOB_EXEC_SUMMARY;

DROP PUBLIC SYNONYM MGMT_JOB_OUTPUT;

DROP PUBLIC SYNONYM MGMT_JOB_EXECUTION;

DROP PUBLIC SYNONYM MGMT_LOG;

DROP PUBLIC SYNONYM MGMT_ADMIN;

DROP PUBLIC SYNONYM MGMT_GLOBAL;

DROP PUBLIC SYNONYM MGMT_TARGET;

DROP PUBLIC SYNONYM MGMT_CREDENTIAL;

DROP PUBLIC SYNONYM MGMT_JOBS;

DROP PUBLIC SYNONYM MGMT_PREFERENCES;

DROP PUBLIC SYNONYM MGMT_USER;

DROP PUBLIC SYNONYM MGMT_SEVERITY;

DROP PUBLIC SYNONYM MGMT_CURRENT_SEVERITY;

DROP PUBLIC SYNONYM MGMT_PAF_PROCS_LATEST;

DROP PUBLIC SYNONYM MGMT_PAF_JOBS;

DROP PUBLIC SYNONYM MGMT_PAF$PROCEDURES;

DROP PUBLIC SYNONYM MGMT_PAF$INSTANCES;

DROP PUBLIC SYNONYM MGMT_PAF$STATES;

DROP PUBLIC SYNONYM MGMT_PAF$APPLICATIONS;

DROP PUBLIC SYNONYM MGMT_VIEW_UTIL;

DROP PUBLIC SYNONYM MGMT_MESSAGES;
3)create:

Command: emca -config dbcontrol db -repos create
posted on 2009-10-20 22:10 jinfeng_wang 阅读(1826) 评论(0) 编辑收藏所属分类: oracle
新用户注册刷新评论列表

只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 Chat2DB C++博客博问管理
相关文章: sql_trace and tkprof 利用 SQL Access Advisor 改进模式设计 zz SQL Performance Analyzer in Oracle Database 11g Release 1 zz oracle11g install dbcontrol 启动Oracle
jinfeng_wang

公告

常用链接

留言簿(40)

随笔分类(592)

随笔档案(400)

Domestic

Foreign

搜索

积分与排名

最新评论

阅读排行榜

评论排行榜
