1.重启监听服务和console(oem服务)，无效。
2.数据库本身运行正常，可以使用pl/sql访问，确定问题主要是oem服务的提供者console的问题，
3.console是启动的且运行是正常的，猜测应该是配置文件设置的问题，
4.首先找到D:\app\franco\product\11.2.0\dbhome_2\NETWORK\ADMIN目录下的listener.ora和tnsnames.ora这两个配置文件，检查发现listener中和tnsnames中的HOST路径写法不一致，一个用了ip，一个用了主机名，尝试都改为ip或都改为主机名并重启服务，无效。
修改了监听为静态注册
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\franco\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\franco\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = dsdl)
(ORACLE_HOME = D:\app\franco\product\11.2.0\dbhome_2)
(SID_NAME = DSDL)
)
)
5.emctl start dbconsole 启动服务进程时,提示未设置sid和oracle_unqname，根据错误提示，重设了sid和ORACLE_UNQNAME 为 “dsdl”
在cmd中执行：set ORACLE_SID=dsdl set ORACLE_UNQNAME=dsdl
6.提示无法找到路径，修改了D:\app\franco\product\11.2.0\dbhome_2\oc4j\j2ee\OC4J_DBConsole_localhost_dsdl为：
D:\app\franco\product\11.2.0\dbhome_2\oc4j\j2ee\OC4J_DBConsole_OC4J_DBConsole_WIN-ALFOF2OETTZ_dsdl（主机名）
7.可以打开oem了，但oem提示连接监听失败，
一下午过去了。。。。第二天上午--------
准备重建em 参考(http://www.cnblogs.com/skey_chen/archive/2011/12/20/2294751.html)
1.停掉oem进程，emca -repos drop
2.进sql命令提示符（ 在cmd下，输入sqlplus /nolog 再输入conn / as sysdba ）删除已有的配置信息:
执行下面的语句：
drop user sysman cascade; drop role MGMT_USER; drop user MGMT_VIEW cascade; drop user MGMT_AVAILABILITY cascade; drop public synonym MGMT_TARGET_BLACKOUTS; drop public synonym SETEMVIEWUSERCONTEXT; drop public synonym MGMT_CURRENT_AVAILABILITY; drop public synonym MGMT_AVAILABILITY; drop public synonym MGMT_SEVERITY_OBJ; drop public synonym MGMT_SEVERITY_ARRAY; drop public synonym MGMT_GUID_OBJ; drop public synonym MGMT_BSLN; drop public synonym MGMT$ALERT_ANNOTATIONS; drop public synonym MGMT$ALERT_CURRENT; drop public synonym MGMT$ALERT_HISTORY; drop public synonym MGMT$ALERT_NOTIF_LOG; drop public synonym MGMT$APPLIED_PATCHES; drop public synonym MGMT$APPLIED_PATCHSETS; drop public synonym MGMT$APPL_PATCH_AND_PATCHSET; drop public synonym MGMT$AUDIT_LOG; drop public synonym MGMT$AVAILABILITY_CURRENT; drop public synonym MGMT$AVAILABILITY_HISTORY; drop public synonym MGMT$BLACKOUTS; drop public synonym MGMT$BLACKOUT_HISTORY; drop public synonym MGMT$CLUSTER_INTERCONNECTS; drop public synonym MGMT$CPF_ADVISORY_INFO; drop public synonym MGMT$CPF_HOMES_INFO; drop public synonym MGMT$CPF_PATCH_DATA; drop public synonym MGMT$CPF_PATCH_INFO; drop public synonym MGMT$CSA_CLIENTS; drop public synonym MGMT$CSA_CLIENT_RULE_VIOLS; drop public synonym MGMT$CSA_COLLECTIONS; drop public synonym MGMT$CSA_FAILED; drop public synonym MGMT$CSA_HOST_COOKIES; drop public synonym MGMT$CSA_HOST_CPUS; drop public synonym MGMT$CSA_HOST_CUSTOM; drop public synonym MGMT$CSA_HOST_IOCARDS; drop public synonym MGMT$CSA_HOST_NICS; drop public synonym MGMT$CSA_HOST_OS_COMPONENTS; drop public synonym MGMT$CSA_HOST_OS_FILESYSTEMS; drop public synonym MGMT$CSA_HOST_OS_PROPERTIES; drop public synonym MGMT$CSA_HOST_RULES; drop public synonym MGMT$CSA_HOST_SW; drop public synonym MGMT$CSM_DOMAIN_DAILY; drop public synonym MGMT$CSM_DOMAIN_DIST_DAILY; drop public synonym MGMT$CSM_DOMAIN_DIST_HOURLY; drop public synonym MGMT$CSM_DOMAIN_HOURLY; drop public synonym MGMT$CSM_IP_DAILY; drop public synonym MGMT$CSM_IP_DIST_DAILY; drop public synonym MGMT$CSM_IP_DIST_HOURLY; drop public synonym MGMT$CSM_IP_HOURLY; drop public synonym MGMT$CSM_METRIC_DETAILS; drop public synonym MGMT$CSM_MT_DSR_DAILY; drop public synonym MGMT$CSM_MT_DSR_DIST_DAILY; drop public synonym MGMT$CSM_MT_DSR_DIST_HOURLY; drop public synonym MGMT$CSM_MT_DSR_HOURLY; drop public synonym MGMT$CSM_MT_IP_DAILY; drop public synonym MGMT$CSM_MT_IP_DIST_DAILY; drop public synonym MGMT$CSM_MT_IP_DIST_HOURLY; drop public synonym MGMT$CSM_MT_IP_HOURLY; drop public synonym MGMT$CSM_MT_METRIC_DETAILS; drop public synonym MGMT$CSM_MT_URL_DAILY; drop public synonym MGMT$CSM_MT_URL_DIST_DAILY; drop public synonym MGMT$CSM_MT_URL_DIST_HOURLY; drop public synonym MGMT$CSM_MT_URL_HOURLY; drop public synonym MGMT$CSM_REGION; drop public synonym MGMT$CSM_REGION_DAILY; drop public synonym MGMT$CSM_REGION_DIST_DAILY; drop public synonym MGMT$CSM_REGION_DIST_HOURLY; drop public synonym MGMT$CSM_REGION_HOURLY; drop public synonym MGMT$CSM_SUBNET_DAILY; drop public synonym MGMT$CSM_SUBNET_DIST_DAILY; drop public synonym MGMT$CSM_SUBNET_DIST_HOURLY; drop public synonym MGMT$CSM_SUBNET_HOURLY; drop public synonym MGMT$CSM_URL_DAILY; drop public synonym MGMT$CSM_URL_DIST_DAILY; drop public synonym MGMT$CSM_URL_DIST_HOURLY; drop public synonym MGMT$CSM_URL_HOURLY; drop public synonym MGMT$CSM_WATCHLIST; drop public synonym MGMT$CS_CONFIG_STANDARDS; drop public synonym MGMT$CS_EVAL_SUMMARY_RULE; drop public synonym MGMT$CS_EVAL_SUMMARY_STANDARD; drop public synonym MGMT$DB_CONTROLFILES; drop public synonym MGMT$DB_CONTROLFILES_ALL; drop public synonym MGMT$DB_DATAFILES; drop public synonym MGMT$DB_DATAFILES_ALL; drop public synonym MGMT$DB_DBNINSTANCEINFO; drop public synonym MGMT$DB_DBNINSTANCEINFO_ALL; drop public synonym MGMT$DB_FEATUREUSAGE; drop public synonym MGMT$DB_INIT_PARAMS; drop public synonym MGMT$DB_INIT_PARAMS_ALL; drop public synonym MGMT$DB_LICENSE; drop public synonym MGMT$DB_LICENSE_ALL; drop public synonym MGMT$DB_OPTIONS; drop public synonym MGMT$DB_OPTIONS_ALL; drop public synonym MGMT$DB_REDOLOGS; drop public synonym MGMT$DB_REDOLOGS_ALL; drop public synonym MGMT$DB_ROLLBACK_SEGS; drop public synonym MGMT$DB_ROLLBACK_SEGS_ALL; drop public synonym MGMT$DB_SGA; drop public synonym MGMT$DB_SGA_ALL; drop public synonym MGMT$DB_TABLESPACES; drop public synonym MGMT$DB_TABLESPACES_ALL; drop public synonym MGMT$DELTA_COMPONENTS; drop public synonym MGMT$DELTA_COMPONENT_DETAILS; drop public synonym MGMT$DELTA_FS_MOUNT; drop public synonym MGMT$DELTA_HARDWARE; drop public synonym MGMT$DELTA_HOST_CONFIG; drop public synonym MGMT$DELTA_INIT; drop public synonym MGMT$DELTA_ONEOFF_PATCHES; 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_VENDOR_SW; drop public synonym MGMT$DELTA_VIEW; drop public synonym MGMT$DELTA_VIEW_DETAILS; drop public synonym MGMT$E2E_1DAY; drop public synonym MGMT$E2E_HOURLY; drop public synonym MGMT$E2E_RAW; drop public synonym MGMT$ECM_CONFIG_HISTORY; drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY1; drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY2; drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY3; drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY4; drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY5; drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY6; drop public synonym MGMT$ECM_CURRENT_SNAPSHOTS; drop public synonym MGMT$ECM_VISIBLE_SNAPSHOTS; drop public synonym MGMT$EM_HOMES_PLATFORM; drop public synonym MGMT$ESA_ALL_PRIVS_REPORT; drop public synonym MGMT$ESA_ANY_DICT_REPORT; drop public synonym MGMT$ESA_ANY_PRIV_REPORT; drop public synonym MGMT$ESA_AUDIT_SYSTEM_REPORT; drop public synonym MGMT$ESA_BECOME_USER_REPORT; drop public synonym MGMT$ESA_CATALOG_REPORT; drop public synonym MGMT$ESA_CONN_PRIV_REPORT; drop public synonym MGMT$ESA_CREATE_PRIV_REPORT; drop public synonym MGMT$ESA_DBA_GROUP_REPORT; drop public synonym MGMT$ESA_DBA_ROLE_REPORT; drop public synonym MGMT$ESA_DIRECT_PRIV_REPORT; drop public synonym MGMT$ESA_EXMPT_ACCESS_REPORT; drop public synonym MGMT$ESA_KEY_OBJECTS_REPORT; drop public synonym MGMT$ESA_OH_OWNERSHIP_REPORT; drop public synonym MGMT$ESA_OH_PERMISSION_REPORT; drop public synonym MGMT$ESA_POWER_PRIV_REPORT; drop public synonym MGMT$ESA_PUB_PRIV_REPORT; drop public synonym MGMT$ESA_SYS_PUB_PKG_REPORT; drop public synonym MGMT$ESA_TABSP_OWNERS_REPORT; drop public synonym MGMT$ESA_TRC_AUD_PERM_REPORT; drop public synonym MGMT$ESA_TRC_AUD_PERM_REP_NT; drop public synonym MGMT$ESA_WITH_ADMIN_REPORT; drop public synonym MGMT$ESA_WITH_GRANT_REPORT; drop public synonym MGMT$GROUP_DERIVED_MEMBERSHIPS; drop public synonym MGMT$GROUP_FLAT_MEMBERSHIPS; drop public synonym MGMT$GROUP_MEMBERS; drop public synonym MGMT$GRP_METRICS_DAILY; drop public synonym MGMT$GRP_METRICS_HOURLY; drop public synonym MGMT$GRP_METRICS_RAW; drop public synonym MGMT$HA_BACKUP; drop public synonym MGMT$HA_FILES; drop public synonym MGMT$HA_FILES_ALL; drop public synonym MGMT$HA_INFO; drop public synonym MGMT$HA_INFO_ALL; drop public synonym MGMT$HA_INIT_PARAMS; drop public synonym MGMT$HA_INIT_PARAMS_ALL; drop public synonym MGMT$HA_MTTR; drop public synonym MGMT$HA_RMAN_CONFIG; drop public synonym MGMT$HA_RMAN_CONFIG_ALL; drop public synonym MGMT$HOMES_AFFECTED; drop public synonym MGMT$HOSTPATCH_GROUPS; drop public synonym MGMT$HOSTPATCH_GRP_COMPL_HIST; drop public synonym MGMT$HOSTPATCH_HOSTS; drop public synonym MGMT$HOSTPATCH_HOST_COMPL; drop public synonym MGMT$HW_NIC; drop public synonym MGMT$INTERFACE_STATS; drop public synonym MGMT$JOBS; drop public synonym MGMT$JOB_ANNOTATIONS; drop public synonym MGMT$JOB_EXECUTION_HISTORY; drop public synonym MGMT$JOB_NOTIFICATION_LOG; drop public synonym MGMT$JOB_STEP_HISTORY; drop public synonym MGMT$JOB_TARGETS; drop public synonym MGMT$MESSAGES; drop public synonym MGMT$METRIC_CATEGORIES; 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_ERROR_CURRENT; drop public synonym MGMT$METRIC_ERROR_HISTORY; drop public synonym MGMT$METRIC_HOURLY; drop public synonym MGMT$MISSING_TARGETS; drop public synonym MGMT$MISSING_TARGETS_IN_GROUPS; drop public synonym MGMT$ORACLE_SW_ENT_INSTALL; drop public synonym MGMT$ORACLE_SW_ENT_TARGETS; drop public synonym MGMT$ORACLE_SW_GRP_INSTALL; drop public synonym MGMT$ORACLE_SW_GRP_TARGETS; 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_PROPERTIES; drop public synonym MGMT$OS_SUMMARY; drop public synonym MGMT$PATCH_ADVISORIES; drop public synonym MGMT$POLICIES; drop public synonym MGMT$POLICY_PARAMETERS; drop public synonym MGMT$POLICY_VIOLATION_CONTEXT; drop public synonym MGMT$POLICY_VIOLATION_CTXT; drop public synonym MGMT$POLICY_VIOLATION_CURRENT; drop public synonym MGMT$POLICY_VIOLATION_HISTORY; drop public synonym MGMT$POLICY_VIOL_ANNOTATIONS; drop public synonym MGMT$POLICY_VIOL_NOTIF_LOG; drop public synonym MGMT$RACDB_INTERCONNECTS; 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_HOME_PROPERTIES; 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$STEPS; drop public synonym MGMT$STEP_GROUPS; drop public synonym MGMT$STEP_METRICS_DAILY; drop public synonym MGMT$STEP_METRICS_HOURLY; drop public synonym MGMT$STEP_METRICS_RAW; drop public synonym MGMT$STORAGE_REPORT_DATA; drop public synonym MGMT$STORAGE_REPORT_DISK; drop public synonym MGMT$STORAGE_REPORT_ISSUES; drop public synonym MGMT$STORAGE_REPORT_KEYS; drop public synonym MGMT$STORAGE_REPORT_LOCALFS; drop public synonym MGMT$STORAGE_REPORT_NFS; drop public synonym MGMT$STORAGE_REPORT_PATHS; drop public synonym MGMT$STORAGE_REPORT_VOLUME; drop public synonym MGMT$TARGET; drop public synonym MGMT$TARGET_ASSOCIATIONS; drop public synonym MGMT$TARGET_COMPONENTS; drop public synonym MGMT$TARGET_COMPOSITE; drop public synonym MGMT$TARGET_FLAT_MEMBERS; drop public synonym MGMT$TARGET_MEMBERS; drop public synonym MGMT$TARGET_METRIC_COLLECTIONS; drop public synonym MGMT$TARGET_METRIC_SETTINGS; drop public synonym MGMT$TARGET_POLICIES; drop public synonym MGMT$TARGET_POLICY_EVAL_SUMM; drop public synonym MGMT$TARGET_POLICY_SETTINGS; drop public synonym MGMT$TARGET_PROPERTIES; drop public synonym MGMT$TARGET_TYPE; drop public synonym MGMT$TARGET_TYPE_DEF; drop public synonym MGMT$TARGET_TYPE_PROPERTIES; drop public synonym MGMT$TEMPLATES; drop public synonym MGMT$TEMPLATE_METRICCOLLECTION; drop public synonym MGMT$TEMPLATE_METRIC_SETTINGS; drop public synonym MGMT$TEMPLATE_POLICY_SETTINGS; drop public synonym MGMT$TXN_PERF_DAY; drop public synonym MGMT$TXN_PERF_HOUR; drop public synonym MGMT$TXN_PERF_RAW; drop public synonym MGMT_ADMIN; 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_PAF$APPLICATIONS; drop public synonym MGMT_PAF$INSTANCES; drop public synonym MGMT_PAF$PROCEDURES; drop public synonym MGMT_PAF$STATES; drop public synonym MGMT_PAF_JOBS; drop public synonym MGMT_PAF_PROCS_LATEST; 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 SMP_EMD_AVAIL_OBJ; drop public synonym SMP_EMD_DELETE_REC_ARRAY; drop public synonym SMP_EMD_TARGET_OBJ; drop public synonym SMP_EMD_TARGET_OBJ_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 EMD_MNTR; drop public synonym ECM_UTIL;
3.在doc命令提示符下重建em
emca -config dbcontrol db -repos create
根据提示，输入sid=dsdl 密码几个都设的一样的，路径就是给出那个直接回车，邮件不用填直接回车，
几分钟后提示更新完成，
访问https://localhost:1158/em 仍然显示无法访问，
奇怪！！
仔细看提示，发现有一句提示：（具体什么不记得了，是说需要访问这个https://localhost:5500/em 地址）,使用https://localhost:5500/em访问，果然ok了，原来重建后oem采用了第二个默认端口5500，问题总算解决了，
回头对比配置文件，
发现多了 D:\app\franco\product\11.2.0\dbhome_2\WIN-ALFOF2OETTZ_dsdl
这个文件夹，又是主机名对应的文件夹。。坑爹啊。。
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。