jinfeng_wang
          
				
          G-G-S,D-D-U!
          
			          		
		
          
	
          

          

          
	
          
		
          
		    
		        
		        BlogJava
首頁
新隨筆
聯系
聚合

管理

			
			
				

          
	
          
		
          
			
			
			
				 
				400 
				Posts ::
				0 Stories
				::
				296 Comments
				::
				0 Trackbacks
			
		
          
	
          

          

			          		
		
          
	
          

          


          


          
	
					

          
	
	
	
          
		
          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 閱讀(1841) 評論(0)  編輯  收藏  所屬分類: oracle 
	
          

          







          
	    
    




          








          

				

          



    







          
        
	




主站蜘蛛池模板：
安仁县|
沙河市|
广昌县|
无极县|
香格里拉县|
红桥区|
通许县|
西乌|
土默特右旗|
无极县|
和林格尔县|
左贡县|
朔州市|
溧阳市|
赣州市|
济阳县|
定南县|
海宁市|
南和县|
嘉定区|
霍城县|
舒兰市|
赞皇县|
文山县|
台江县|
宿州市|
和平区|
印江|
宜都市|
忻州市|
清流县|
黄大仙区|
远安县|
乃东县|
黑河市|
团风县|
民丰县|
赤城县|
磴口县|
宣城市|
济宁市|