【oracle】手动安装EM

nawawa001

创建数据库时时没有配置EM，当需要时可以使用下面的方法创建EM。　　
第一种：
　　

　　
database configuration assistant的配置数据库选件。
　　

　　
第二种：
　　

　　
一、删除一些用户、视图、同义词
　　

　　
若是没有完全删除，那么创建em时会不断提示出错，然后又需要重新配置：
　　

　　
同义词已创建。
　　

　　

　　
同义词已创建。
　　

　　
CREATE PUBLIC SYNONYM SMP_EMD_TARGET_OBJ_ARRAY FOR SMP_EMD_TARGET_OBJ_ARRAY
　　
                      *
　　
第 1 行出现错误:
　　
ORA-00955: 名称已由现有对象使用
　　

　　

　　
引自：http://www.cnblogs.com/terrorpig/archive/2012/05/29/2524330.html
　　

　　
dropuser sysman cascade;
　　
droprole MGMT_USER;
　　
dropuser MGMT_VIEW cascade;
　　
dropuser MGMT_AVAILABILITY cascade;
　　
droppublic synonym MGMT_TARGET_BLACKOUTS;
　　
droppublic synonym SETEMVIEWUSERCONTEXT;
　　
droppublic synonym MGMT_CURRENT_AVAILABILITY;
　　
droppublic synonym MGMT_AVAILABILITY;
　　
droppublic synonym MGMT_SEVERITY_OBJ;
　　
droppublic synonym MGMT_SEVERITY_ARRAY;
　　
droppublic synonym MGMT_GUID_OBJ;
　　
droppublic synonym MGMT_BSLN;
　　
droppublic synonym MGMT$ALERT_ANNOTATIONS;
　　
droppublic synonym MGMT$ALERT_CURRENT;
　　
droppublic synonym MGMT$ALERT_HISTORY;
　　
droppublic synonym MGMT$ALERT_NOTIF_LOG;
　　
droppublic synonym MGMT$APPLIED_PATCHES;
　　
droppublic synonym MGMT$APPLIED_PATCHSETS;
　　
droppublic synonym MGMT$APPL_PATCH_AND_PATCHSET;
　　
droppublic synonym MGMT$AUDIT_LOG;
　　
droppublic synonym MGMT$AVAILABILITY_CURRENT;
　　
droppublic synonym MGMT$AVAILABILITY_HISTORY;
　　
droppublic synonym MGMT$BLACKOUTS;
　　
droppublic synonym MGMT$BLACKOUT_HISTORY;
　　
droppublic synonym MGMT$CLUSTER_INTERCONNECTS;
　　
droppublic synonym MGMT$CPF_ADVISORY_INFO;
　　
droppublic synonym MGMT$CPF_HOMES_INFO;
　　
droppublic synonym MGMT$CPF_PATCH_DATA;
　　
droppublic synonym MGMT$CPF_PATCH_INFO;
　　
droppublic synonym MGMT$CSA_CLIENTS;
　　
droppublic synonym MGMT$CSA_CLIENT_RULE_VIOLS;
　　
droppublic synonym MGMT$CSA_COLLECTIONS;
　　
droppublic synonym MGMT$CSA_FAILED;
　　
droppublic synonym MGMT$CSA_HOST_COOKIES;
　　
droppublic synonym MGMT$CSA_HOST_CPUS;
　　
droppublic synonym MGMT$CSA_HOST_CUSTOM;
　　
droppublic synonym MGMT$CSA_HOST_IOCARDS;
　　
droppublic synonym MGMT$CSA_HOST_NICS;
　　
droppublic synonym MGMT$CSA_HOST_OS_COMPONENTS;
　　
droppublic synonym MGMT$CSA_HOST_OS_FILESYSTEMS;
　　
droppublic synonym MGMT$CSA_HOST_OS_PROPERTIES;
　　
droppublic synonym MGMT$CSA_HOST_RULES;
　　
droppublic synonym MGMT$CSA_HOST_SW;
　　
droppublic synonym MGMT$CSM_DOMAIN_DAILY;
　　
droppublic synonym MGMT$CSM_DOMAIN_DIST_DAILY;
　　
droppublic synonym MGMT$CSM_DOMAIN_DIST_HOURLY;
　　
droppublic synonym MGMT$CSM_DOMAIN_HOURLY;
　　
droppublic synonym MGMT$CSM_IP_DAILY;
　　
droppublic synonym MGMT$CSM_IP_DIST_DAILY;
　　
droppublic synonym MGMT$CSM_IP_DIST_HOURLY;
　　
droppublic synonym MGMT$CSM_IP_HOURLY;
　　
droppublic synonym MGMT$CSM_METRIC_DETAILS;
　　
droppublic synonym MGMT$CSM_MT_DSR_DAILY;
　　
droppublic synonym MGMT$CSM_MT_DSR_DIST_DAILY;
　　
droppublic synonym MGMT$CSM_MT_DSR_DIST_HOURLY;
　　
droppublic synonym MGMT$CSM_MT_DSR_HOURLY;
　　
droppublic synonym MGMT$CSM_MT_IP_DAILY;
　　
droppublic synonym MGMT$CSM_MT_IP_DIST_DAILY;
　　
droppublic synonym MGMT$CSM_MT_IP_DIST_HOURLY;
　　
droppublic synonym MGMT$CSM_MT_IP_HOURLY;
　　
droppublic synonym MGMT$CSM_MT_METRIC_DETAILS;
　　
droppublic synonym MGMT$CSM_MT_URL_DAILY;
　　
droppublic synonym MGMT$CSM_MT_URL_DIST_DAILY;
　　
droppublic synonym MGMT$CSM_MT_URL_DIST_HOURLY;
　　
droppublic synonym MGMT$CSM_MT_URL_HOURLY;
　　
droppublic synonym MGMT$CSM_REGION;
　　
droppublic synonym MGMT$CSM_REGION_DAILY;
　　
droppublic synonym MGMT$CSM_REGION_DIST_DAILY;
　　
droppublic synonym MGMT$CSM_REGION_DIST_HOURLY;
　　
droppublic synonym MGMT$CSM_REGION_HOURLY;
　　
droppublic synonym MGMT$CSM_SUBNET_DAILY;
　　
droppublic synonym MGMT$CSM_SUBNET_DIST_DAILY;
　　
droppublic synonym MGMT$CSM_SUBNET_DIST_HOURLY;
　　
droppublic synonym MGMT$CSM_SUBNET_HOURLY;
　　
droppublic synonym MGMT$CSM_URL_DAILY;
　　
droppublic synonym MGMT$CSM_URL_DIST_DAILY;
　　
droppublic synonym MGMT$CSM_URL_DIST_HOURLY;
　　
droppublic synonym MGMT$CSM_URL_HOURLY;
　　
droppublic synonym MGMT$CSM_WATCHLIST;
　　
droppublic synonym MGMT$CS_CONFIG_STANDARDS;
　　
droppublic synonym MGMT$CS_EVAL_SUMMARY_RULE;
　　
droppublic synonym MGMT$CS_EVAL_SUMMARY_STANDARD;
　　
droppublic synonym MGMT$DB_CONTROLFILES;
　　
droppublic synonym MGMT$DB_CONTROLFILES_ALL;
　　
droppublic synonym MGMT$DB_DATAFILES;
　　
droppublic synonym MGMT$DB_DATAFILES_ALL;
　　
droppublic synonym MGMT$DB_DBNINSTANCEINFO;
　　
droppublic synonym MGMT$DB_DBNINSTANCEINFO_ALL;
　　
droppublic synonym MGMT$DB_FEATUREUSAGE;
　　
droppublic synonym MGMT$DB_INIT_PARAMS;
　　
droppublic synonym MGMT$DB_INIT_PARAMS_ALL;
　　
droppublic synonym MGMT$DB_LICENSE;
　　
droppublic synonym MGMT$DB_LICENSE_ALL;
　　
droppublic synonym MGMT$DB_OPTIONS;
　　
droppublic synonym MGMT$DB_OPTIONS_ALL;
　　
droppublic synonym MGMT$DB_REDOLOGS;
　　
droppublic synonym MGMT$DB_REDOLOGS_ALL;
　　
droppublic synonym MGMT$DB_ROLLBACK_SEGS;
　　
droppublic synonym MGMT$DB_ROLLBACK_SEGS_ALL;
　　
droppublic synonym MGMT$DB_SGA;
　　
droppublic synonym MGMT$DB_SGA_ALL;
　　
droppublic synonym MGMT$DB_TABLESPACES;
　　
droppublic synonym MGMT$DB_TABLESPACES_ALL;
　　
droppublic synonym MGMT$DELTA_COMPONENTS;
　　
droppublic synonym MGMT$DELTA_COMPONENT_DETAILS;
　　
droppublic synonym MGMT$DELTA_FS_MOUNT;
　　
droppublic synonym MGMT$DELTA_HARDWARE;
　　
droppublic synonym MGMT$DELTA_HOST_CONFIG;
　　
droppublic synonym MGMT$DELTA_INIT;
　　
droppublic synonym MGMT$DELTA_ONEOFF_PATCHES;
　　
droppublic synonym MGMT$DELTA_ORACLE_HOME;
　　
droppublic synonym MGMT$DELTA_OS_COMPONENTS;
　　
droppublic synonym MGMT$DELTA_OS_COMP_DETAILS;
　　
droppublic synonym MGMT$DELTA_OS_KERNEL_PARAMS;
　　
droppublic synonym MGMT$DELTA_PATCHSETS;
　　
droppublic synonym MGMT$DELTA_PATCHSET_DETAILS;
　　
droppublic synonym MGMT$DELTA_VENDOR_SW;
　　
droppublic synonym MGMT$DELTA_VIEW;
　　
droppublic synonym MGMT$DELTA_VIEW_DETAILS;
　　
droppublic synonym MGMT$E2E_1DAY;
　　
droppublic synonym MGMT$E2E_HOURLY;
　　
droppublic synonym MGMT$E2E_RAW;
　　
droppublic synonym MGMT$ECM_CONFIG_HISTORY;
　　
droppublic synonym MGMT$ECM_CONFIG_HISTORY_KEY1;
　　
droppublic synonym MGMT$ECM_CONFIG_HISTORY_KEY2;
　　
droppublic synonym MGMT$ECM_CONFIG_HISTORY_KEY3;
　　
droppublic synonym MGMT$ECM_CONFIG_HISTORY_KEY4;
　　
droppublic synonym MGMT$ECM_CONFIG_HISTORY_KEY5;
　　
droppublic synonym MGMT$ECM_CONFIG_HISTORY_KEY6;
　　
droppublic synonym MGMT$ECM_CURRENT_SNAPSHOTS;
　　
droppublic synonym MGMT$ECM_VISIBLE_SNAPSHOTS;
　　
droppublic synonym MGMT$EM_HOMES_PLATFORM;
　　
droppublic synonym MGMT$ESA_ALL_PRIVS_REPORT;
　　
droppublic synonym MGMT$ESA_ANY_DICT_REPORT;
　　
droppublic synonym MGMT$ESA_ANY_PRIV_REPORT;
　　
droppublic synonym MGMT$ESA_AUDIT_SYSTEM_REPORT;
　　
droppublic synonym MGMT$ESA_BECOME_USER_REPORT;
　　
droppublic synonym MGMT$ESA_CATALOG_REPORT;
　　
droppublic synonym MGMT$ESA_CONN_PRIV_REPORT;
　　
droppublic synonym MGMT$ESA_CREATE_PRIV_REPORT;
　　
droppublic synonym MGMT$ESA_DBA_GROUP_REPORT;
　　
droppublic synonym MGMT$ESA_DBA_ROLE_REPORT;
　　
droppublic synonym MGMT$ESA_DIRECT_PRIV_REPORT;
　　
droppublic synonym MGMT$ESA_EXMPT_ACCESS_REPORT;
　　
droppublic synonym MGMT$ESA_KEY_OBJECTS_REPORT;
　　
droppublic synonym MGMT$ESA_OH_OWNERSHIP_REPORT;
　　
droppublic synonym MGMT$ESA_OH_PERMISSION_REPORT;
　　
droppublic synonym MGMT$ESA_POWER_PRIV_REPORT;
　　
droppublic synonym MGMT$ESA_PUB_PRIV_REPORT;
　　
droppublic synonym MGMT$ESA_SYS_PUB_PKG_REPORT;
　　
droppublic synonym MGMT$ESA_TABSP_OWNERS_REPORT;
　　
droppublic synonym MGMT$ESA_TRC_AUD_PERM_REPORT;
　　
droppublic synonym MGMT$ESA_TRC_AUD_PERM_REP_NT;
　　
droppublic synonym MGMT$ESA_WITH_ADMIN_REPORT;
　　
droppublic synonym MGMT$ESA_WITH_GRANT_REPORT;
　　
droppublic synonym MGMT$GROUP_DERIVED_MEMBERSHIPS;
　　
droppublic synonym MGMT$GROUP_FLAT_MEMBERSHIPS;
　　
droppublic synonym MGMT$GROUP_MEMBERS;
　　
droppublic synonym MGMT$GRP_METRICS_DAILY;
　　
droppublic synonym MGMT$GRP_METRICS_HOURLY;
　　
droppublic synonym MGMT$GRP_METRICS_RAW;
　　
droppublic synonym MGMT$HA_BACKUP;
　　
droppublic synonym MGMT$HA_FILES;
　　
droppublic synonym MGMT$HA_FILES_ALL;
　　
droppublic synonym MGMT$HA_INFO;
　　
droppublic synonym MGMT$HA_INFO_ALL;
　　
droppublic synonym MGMT$HA_INIT_PARAMS;
　　
droppublic synonym MGMT$HA_INIT_PARAMS_ALL;
　　
droppublic synonym MGMT$HA_MTTR;
　　
droppublic synonym MGMT$HA_RMAN_CONFIG;
　　
droppublic synonym MGMT$HA_RMAN_CONFIG_ALL;
　　
droppublic synonym MGMT$HOMES_AFFECTED;
　　
droppublic synonym MGMT$HOSTPATCH_GROUPS;
　　
droppublic synonym MGMT$HOSTPATCH_GRP_COMPL_HIST;
　　
droppublic synonym MGMT$HOSTPATCH_HOSTS;
　　
droppublic synonym MGMT$HOSTPATCH_HOST_COMPL;
　　
droppublic synonym MGMT$HW_NIC;
　　
droppublic synonym MGMT$INTERFACE_STATS;
　　
droppublic synonym MGMT$JOBS;
　　
droppublic synonym MGMT$JOB_ANNOTATIONS;
　　
droppublic synonym MGMT$JOB_EXECUTION_HISTORY;
　　
droppublic synonym MGMT$JOB_NOTIFICATION_LOG;
　　
droppublic synonym MGMT$JOB_STEP_HISTORY;
　　
droppublic synonym MGMT$JOB_TARGETS;
　　
droppublic synonym MGMT$MESSAGES;
　　
droppublic synonym MGMT$METRIC_CATEGORIES;
　　
droppublic synonym MGMT$METRIC_COLLECTION;
　　
droppublic synonym MGMT$METRIC_CURRENT;
　　
droppublic synonym MGMT$METRIC_DAILY;
　　
droppublic synonym MGMT$METRIC_DETAILS;
　　
droppublic synonym MGMT$METRIC_ERROR_CURRENT;
　　
droppublic synonym MGMT$METRIC_ERROR_HISTORY;
　　
droppublic synonym MGMT$METRIC_HOURLY;
　　
droppublic synonym MGMT$MISSING_TARGETS;
　　
droppublic synonym MGMT$MISSING_TARGETS_IN_GROUPS;
　　
droppublic synonym MGMT$ORACLE_SW_ENT_INSTALL;
　　
droppublic synonym MGMT$ORACLE_SW_ENT_TARGETS;
　　
droppublic synonym MGMT$ORACLE_SW_GRP_INSTALL;
　　
droppublic synonym MGMT$ORACLE_SW_GRP_TARGETS;
　　
droppublic synonym MGMT$OS_COMPONENTS;
　　
droppublic synonym MGMT$OS_FS_MOUNT;
　　
droppublic synonym MGMT$OS_HW_SUMMARY;
　　
droppublic synonym MGMT$OS_KERNEL_PARAMS;
　　
droppublic synonym MGMT$OS_PATCHES;
　　
droppublic synonym MGMT$OS_PROPERTIES;
　　
droppublic synonym MGMT$OS_SUMMARY;
　　
droppublic synonym MGMT$PATCH_ADVISORIES;
　　
droppublic synonym MGMT$POLICIES;
　　
droppublic synonym MGMT$POLICY_PARAMETERS;
　　
droppublic synonym MGMT$POLICY_VIOLATION_CONTEXT;
　　
droppublic synonym MGMT$POLICY_VIOLATION_CTXT;
　　
droppublic synonym MGMT$POLICY_VIOLATION_CURRENT;
　　
droppublic synonym MGMT$POLICY_VIOLATION_HISTORY;
　　
droppublic synonym MGMT$POLICY_VIOL_ANNOTATIONS;
　　
droppublic synonym MGMT$POLICY_VIOL_NOTIF_LOG;
　　
droppublic synonym MGMT$RACDB_INTERCONNECTS;
　　
droppublic synonym MGMT$SOFTWARE_COMPONENTS;
　　
droppublic synonym MGMT$SOFTWARE_COMPONENT_ONEOFF;
　　
droppublic synonym MGMT$SOFTWARE_COMP_PATCHSET;
　　
droppublic synonym MGMT$SOFTWARE_DEPENDENCIES;
　　
droppublic synonym MGMT$SOFTWARE_HOMES;
　　
droppublic synonym MGMT$SOFTWARE_HOME_PROPERTIES;
　　
droppublic synonym MGMT$SOFTWARE_ONEOFF_PATCHES;
　　
droppublic synonym MGMT$SOFTWARE_OTHERS;
　　
droppublic synonym MGMT$SOFTWARE_PATCHES_IN_HOMES;
　　
droppublic synonym MGMT$SOFTWARE_PATCHSETS;
　　
droppublic synonym MGMT$STEPS;
　　
droppublic synonym MGMT$STEP_GROUPS;
　　
droppublic synonym MGMT$STEP_METRICS_DAILY;
　　
droppublic synonym MGMT$STEP_METRICS_HOURLY;
　　
droppublic synonym MGMT$STEP_METRICS_RAW;
　　
droppublic synonym MGMT$STORAGE_REPORT_DATA;
　　
droppublic synonym MGMT$STORAGE_REPORT_DISK;
　　
droppublic synonym MGMT$STORAGE_REPORT_ISSUES;
　　
droppublic synonym MGMT$STORAGE_REPORT_KEYS;
　　
droppublic synonym MGMT$STORAGE_REPORT_LOCALFS;
　　
droppublic synonym MGMT$STORAGE_REPORT_NFS;
　　
droppublic synonym MGMT$STORAGE_REPORT_PATHS;
　　
droppublic synonym MGMT$STORAGE_REPORT_VOLUME;
　　
droppublic synonym MGMT$TARGET;
　　
droppublic synonym MGMT$TARGET_ASSOCIATIONS;
　　
droppublic synonym MGMT$TARGET_COMPONENTS;
　　
droppublic synonym MGMT$TARGET_COMPOSITE;
　　
droppublic synonym MGMT$TARGET_FLAT_MEMBERS;
　　
droppublic synonym MGMT$TARGET_MEMBERS;
　　
droppublic synonym MGMT$TARGET_METRIC_COLLECTIONS;
　　
droppublic synonym MGMT$TARGET_METRIC_SETTINGS;
　　
droppublic synonym MGMT$TARGET_POLICIES;
　　
droppublic synonym MGMT$TARGET_POLICY_EVAL_SUMM;
　　
droppublic synonym MGMT$TARGET_POLICY_SETTINGS;
　　
droppublic synonym MGMT$TARGET_PROPERTIES;
　　
droppublic synonym MGMT$TARGET_TYPE;
　　
droppublic synonym MGMT$TARGET_TYPE_DEF;
　　
droppublic synonym MGMT$TARGET_TYPE_PROPERTIES;
　　
droppublic synonym MGMT$TEMPLATES;
　　
droppublic synonym MGMT$TEMPLATE_METRICCOLLECTION;
　　
droppublic synonym MGMT$TEMPLATE_METRIC_SETTINGS;
　　
droppublic synonym MGMT$TEMPLATE_POLICY_SETTINGS;
　　
droppublic synonym MGMT$TXN_PERF_DAY;
　　
droppublic synonym MGMT$TXN_PERF_HOUR;
　　
droppublic synonym MGMT$TXN_PERF_RAW;
　　
droppublic synonym MGMT_ADMIN;
　　
droppublic synonym MGMT_AVAILABILITY;
　　
droppublic synonym MGMT_COLLECTION_PROPERTIES;
　　
droppublic synonym MGMT_CREDENTIAL;
　　
droppublic synonym MGMT_CURRENT_AVAILABILITY;
　　
droppublic synonym MGMT_CURRENT_METRICS;
　　
droppublic synonym MGMT_CURRENT_METRIC_ERRORS;
　　
droppublic synonym MGMT_CURRENT_SEVERITY;
　　
droppublic synonym MGMT_DELTA;
　　
droppublic synonym MGMT_DELTA_ENTRY;
　　
droppublic synonym MGMT_DELTA_ENTRY_VALUES;
　　
droppublic synonym MGMT_DELTA_IDS;
　　
droppublic synonym MGMT_DELTA_ID_VALUES;
　　
droppublic synonym MGMT_DELTA_VALUE;
　　
droppublic synonym MGMT_DELTA_VALUES;
　　
droppublic synonym MGMT_GLOBAL;
　　
droppublic synonym MGMT_GUID_ARRAY;
　　
droppublic synonym MGMT_GUID_OBJ;
　　
droppublic synonym MGMT_IP_TGT_GUID_ARRAY;
　　
droppublic synonym MGMT_JOB;
　　
droppublic synonym MGMT_JOBS;
　　
droppublic synonym MGMT_JOB_EXECPLAN;
　　
droppublic synonym MGMT_JOB_EXECUTION;
　　
droppublic synonym MGMT_JOB_EXEC_SUMMARY;
　　
droppublic synonym MGMT_JOB_OUTPUT;
　　
droppublic synonym MGMT_JOB_PARAMETER;
　　
droppublic synonym MGMT_JOB_SCHEDULE;
　　
droppublic synonym MGMT_JOB_TARGET;
　　
droppublic synonym MGMT_LOG;
　　
droppublic synonym MGMT_LONG_TEXT;
　　
droppublic synonym MGMT_MESSAGES;
　　
droppublic synonym MGMT_METRICS;
　　
droppublic synonym MGMT_METRICS_1DAY;
　　
droppublic synonym MGMT_METRICS_1HOUR;
　　
droppublic synonym MGMT_METRICS_COMPOSITE_KEYS;
　　
droppublic synonym MGMT_METRICS_RAW;
　　
droppublic synonym MGMT_METRIC_COLLECTIONS;
　　
droppublic synonym MGMT_METRIC_ERRORS;
　　
droppublic synonym MGMT_METRIC_THRESHOLDS;
　　
droppublic synonym MGMT_NAME_VALUE;
　　
droppublic synonym MGMT_NAME_VALUES;
　　
droppublic synonym MGMT_PAF$APPLICATIONS;
　　
droppublic synonym MGMT_PAF$INSTANCES;
　　
droppublic synonym MGMT_PAF$PROCEDURES;
　　
droppublic synonym MGMT_PAF$STATES;
　　
droppublic synonym MGMT_PAF_JOBS;
　　
droppublic synonym MGMT_PAF_PROCS_LATEST;
　　
droppublic synonym MGMT_PREFERENCES;
　　
droppublic synonym MGMT_SEVERITY;
　　
droppublic synonym MGMT_SEVERITY_ARRAY;
　　
droppublic synonym MGMT_SEVERITY_OBJ;
　　
droppublic synonym MGMT_STRING_METRIC_HISTORY;
　　
droppublic synonym MGMT_TARGET;
　　
droppublic synonym MGMT_TARGETS;
　　
droppublic synonym MGMT_TARGET_BLACKOUTS;
　　
droppublic synonym MGMT_TARGET_MEMBERSHIPS;
　　
droppublic synonym MGMT_TARGET_PROPERTIES;
　　
droppublic synonym MGMT_TYPE_PROPERTIES;
　　
droppublic synonym MGMT_USER;
　　
droppublic synonym MGMT_VIEW_UTIL;
　　

　　
droppublic synonym SMP_EMD_AVAIL_OBJ;
　　
droppublic synonym SMP_EMD_DELETE_REC_ARRAY;
　　
droppublic synonym SMP_EMD_TARGET_OBJ;
　　
droppublic synonym SMP_EMD_TARGET_OBJ_ARRAY;
　　

　　
droppublic synonym SMP_EMD_INTEGER_ARRAY;
　　
droppublic synonym SMP_EMD_INTEGER_ARRAY_ARRAY;
　　
droppublic synonym SMP_EMD_NVPAIR;
　　
droppublic synonym SMP_EMD_NVPAIR_ARRAY;
　　
droppublic synonym SMP_EMD_STRING_ARRAY;
　　
droppublic synonym SMP_EMD_STRING_ARRAY_ARRAY;
　　

　　
droppublic synonym EMD_MNTR;
　　
droppublic synonym ECM_UTIL;
　　

　　

　　

　　
二、创建em
　　

　　
C:\Users\Administrator>emca -configdbcontrol db -repos create
　　

　　
EMCA 开始于 2014-9-1014:08:48
　　
EM Configuration Assistant, 11.2.0.0.2 正式版
　　
版权所有 (c) 2003, 2005, Oracle。保留所有权利。
　　

　　
输入以下信息:
　　
数据库 SID: hxw168
　　
监听程序端口号: 1521
　　
监听程序 ORACLE_HOME [ D:\oracle\product\11.2.0\dbhome_1 ]:
　　
SYS 用户的口令:
　　
DBSNMP 用户的口令:
　　
SYSMAN 用户的口令:
　　
SYSMAN 用户的口令: 通知的电子邮件地址 (可选):
　　
通知的发件 (SMTP) 服务器 (可选):
　　
-----------------------------------------------------------------
　　

　　
已指定以下设置
　　

　　
数据库 ORACLE_HOME ................ D:\oracle\product\11.2.0\dbhome_1
　　

　　
本地主机名 ................ huangwen
　　
监听程序 ORACLE_HOME ................ D:\oracle\product\11.2.0\dbhome_1
　　
监听程序端口号 ................ 1521
　　
数据库 SID ................ hxw168
　　
通知的电子邮件地址 ...............
　　
通知的发件 (SMTP) 服务器 ...............
　　

　　
-----------------------------------------------------------------
　　
是否继续? [是(Y)/否(N)]: y
　　
2014-9-10 14:09:05oracle.sysman.emcp.EMConfig perform
　　
信息: 正在将此操作记录到 D:\oracle\cfgtoollogs\emca\hxw168\emca_2014_09_10_14_08
　　
_48.log。
　　
2014-9-10 14:09:06 oracle.sysman.emcp.EMReposConfigcreateRepository
　　
信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...
　　
2014-9-10 14:15:13oracle.sysman.emcp.EMReposConfig invoke
　　
信息: 已成功创建资料档案库
　　
2014-9-10 14:15:19oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
　　

　　
信息: 正在将配置数据上载到 EM 资料档案库 (此操作可能需要一段时间)...
　　
2014-9-10 14:16:10oracle.sysman.emcp.EMReposConfig invoke
　　
信息: 已成功上载配置数据
　　
2014-9-10 14:16:17oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
　　
信息: 软件库已配置成功。
　　
2014-9-10 14:16:17oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
　　
信息: 正在部署预配档案...
　　
2014-9-10 14:16:57oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
　　
信息: 预配档案部署成功。
　　
2014-9-10 14:16:57oracle.sysman.emcp.util.DBControlUtil secureDBConsole
　　
信息: 正在保护 Database Control (此操作可能需要一段时间)...
　　
2014-9-10 14:17:06 oracle.sysman.emcp.util.DBControlUtilsecureDBConsole
　　
信息: 已成功保护 Database Control。
　　
2014-9-10 14:17:06oracle.sysman.emcp.util.DBControlUtil startOMS
　　
信息: 正在启动 Database Control (此操作可能需要一段时间)...
　　
2014-9-10 14:19:12oracle.sysman.emcp.EMDBPostConfig performConfiguration
　　
信息: 已成功启动 Database Control
　　
2014-9-10 14:19:12oracle.sysman.emcp.EMDBPostConfig performConfiguration
　　
信息: >>>>>>>>>>> Database Control URL 为https://huangwen:1158/em