ORACLE10G修改主机名后的EM(Enterprise Manager)启动问题
ORACLE10G修改主机名 EM Enterprise Manager 无法启动
修改主机名从info到info-0073后,ORACLE EM (Enterprise Manager)无法启动,尝试手工解决.C:/Documents and Settings/Administrator>emctl start dbconsoleEnvironment variable ORACLE_SID not defined. Please define it. 按提示设置ORACLE_SIDC:/Documents and Settings/Administrator>set ORACLE_SID=WWMDB 再测试C:/Documents and Settings/Administrator>emctl start dbconsoleEM Configuration issue. D:/oracle/product/10.1.0/Db_1/info-0073_WWMDB not found 按提示将上面info_WWMDB目录改成info-0073_WWMDB,再测试.C:/Documents and Settings/Administrator>emctl start dbconsoleOracle Enterprise Manager 10g Database Control Release 10.1.0.2.0Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.http://info:5500/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsolewThe OracleDBConsolewwmdb service could not be started.A service specific error occurred: 2.More help is available by typing NET HELPMSG 3547. 仍有错误,手工修改配置文件. 修改D:/oracle/product/10.1.0/Db_1/info-0073_wwmdb/sysman/config/emd.propertiesagentStateDir=D:/oracle/product/10.1.0/Db_1/info-0073_wwmdbchronosRoot=D:/oracle/product/10.1.0/Db_1/info-0073_wwmdb/sysman/emd/chronosREPOSITORY_URL=http://info-0073:5500/em/upload/emdRootCertLoc=D:/oracle/product/10.1.0/Db_1/info-0073_wwmdb/sysman/config/b64LocalCertificate.txtinternetCertLoc=D:/oracle/product/10.1.0/Db_1/info-0073_wwmdb/sysman/config/b64InternetCertificate.txtemdWalletSrcUrl=http://info-0073:5500/em/wallets/emdemdWalletDest=D:/oracle/product/10.1.0/Db_1/info-0073_wwmdb/sysman/config/serverEMD_URL=http://info-0073:1830/emd/main 修改D:/oracle/product/10.1.0/Db_1/info-0073_wwmdb/sysman/config/emoms.propertiesoracle.sysman.db.isqlplusUrl=http/://info-0073/:5560/isqlplus/dynamicoracle.sysman.db.isqlplusWebDBAUrl=http/://info-0073/:5560/isqlplus/dba/dynamicoracle.sysman.emSDK.svlt.ConsoleServerHost=info-0073oracle.sysman.eml.mntr.emdRepServer=info-0073oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION/=(ADDRESS_LIST/=(ADDRESS/=(PROTOCOL/=TCP)(HOST/=info-0073)(PORT/=1521)))(CONNECT_DATA/=(SERVICE_NAME/=wwmdb)))D:/oracle/product/10.1.0/Db_1/info-0073_wwmdb/sysman/emd/targets.xmlemctl start dbconsole仍是报错,再修改$ORACLE_HOME/sysman/config/emd.properties 问题依旧,看来修改配置文件需要修改的地方比较多,而且容易遗漏,还是重新配置服务吧.C:/Documents and Settings/Administrator>emca -rEMCA 开始于 Mon Apr 16 17:02:29 CST 2007输入以下有关要配置的数据库的信息监听程序端口号: 1521数据库 SID: WWMDB服务名: WWMDB通知的电子邮件地址:通知的电子邮件网关:dbsnmp 口令:sysman 口令:sys 口令:-----------------------------------------------------------------已指定以下设置 数据库 ORACLE_HOME ................ D:/oracle/product/10.1.0/Db_1Enterprise Manager ORACLE_HOME ................ D:/oracle/product/10.1.0/Db_1数据库主机名 ................ info-0073监听程序端口号 ................ 1521数据库 SID ................ WWMDB服务名 ................ WWMDB通知的电子邮件地址 ...............通知的电子邮件网关 ...............-----------------------------------------------------------------是否继续? [是/否]: 是已为数据库 WWMDB 配置了 DBConsole是否要为指定的数据库重新配置 DBConsole? [是/否]: 是请确保 DBConsole 已关闭如果准备好继续, 请按 2007-4-16 17:03:00 oracle.sysman.emcp.EMConfig checkConfiguration警告: 'shared_pool_size' 必须大于等于 80 MB。2007-4-16 17:03:06 oracle.sysman.emcp.EMConfig checkConfiguration严重: 'job_queue_processes' 必须大于等于 1。 改正错误, 然后以独立模式运行 EM Co无法完成配置。有关详细信息, 请参阅日志文件 解决问题SQL> alter system set shared_pool_size=80M scope=both;System altered. 再重新建立C:/Documents and Settings/Administrator>emca –r…………………………2007-4-16 17:07:37 oracle.sysman.emcp.EMConfig updateReposVars信息: 正在更新文件 D:/oracle/product/10.1.0/Db_1/sysman/emdrep/config/repository.variables.2007-4-16 17:07:59 oracle.sysman.emcp.EMConfig stopOMS信息: 正在停止 DBConsole...2007-4-16 17:08:30 oracle.sysman.emcp.EMConfig addPortEntries信息: 正在更新文件 D:/oracle/product/10.1.0/Db_1/install/portlist.ini...2007-4-16 17:08:30 oracle.sysman.emcp.EMConfig updateEmdProps信息: 正在更新文件 D:/oracle/product/10.1.0/Db_1/sysman/config/emd.properties...2007-4-16 17:08:30 oracle.sysman.emcp.EMConfig updateConfigFiles信息: targets.xml 文件已成功更新2007-4-16 17:08:30 oracle.sysman.emcp.EMConfig updateEmomsProps信息: 正在更新文件 D:/oracle/product/10.1.0/Db_1/sysman/config/emoms.properties...2007-4-16 17:08:30 oracle.sysman.emcp.EMConfig updateConfigFiles信息: emoms.properties 文件已成功更新2007-4-16 17:08:36 oracle.sysman.emcp.EMConfig startOMS信息: 正在启动 DBConsole...2007-4-16 17:11:39 oracle.sysman.emcp.EMConfig perform信息: DBConsole 已成功启动2007-4-16 17:11:39 oracle.sysman.emcp.EMConfig perform信息: >>>>>>>>>>> Enterprise Manager URL 为 http://info-0073:5500/em <<<<<<<<<<<Enterprise Manager 配置已成功完成EMCA 结束于 Mon Apr 16 17:11:39 CST 2007 到此问题解决,可以访问EM.