今天遇到个奇怪的问题，oracle10.2.0.1登录oem的时候报错ora-12514，在报错的下面提示采用了连接字符串(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=fivip-tech-lsq.fivip.com.cdlocal)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=sqlee)))，而在几天前都可以登录的，怎么现在就不行了呢？

         通常，ora-12514错误是因为连接字符串中的service_name不对引起的，于是查看参数service_name

SQL> show parameter service_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      sqlee.cd.com

         显然两个service_name不一样，我想起了，我前两天更改了db_domain，导致数据库服务名变了，找到了问题的原因就好解决了。现在是要先找到oem的连接字符串是从哪个文件读取的，在网上交流发现，oem连接字符串是从$ORACLE_HOME/hostname/sysman/config/emoms.properties文件读取的，找出该文件，修改连接字符串的service_name,在重启下console服务，一切ok！

附录：emoms.properties

#Mon Mar 17 18:07:24 CST 2008
oracle.sysman.emSDK.svlt.ConsoleServerName=fivip-tech-lsq.fivip.com.cdlocal_Management_Service
oracle.sysman.eml.mntr.emdRepPwd=a0bc9accdbf7317d
emdrep.ping.pingCommand=ping
oracle.sysman.eml.mntr.emdRepPort=1521
oracle.sysman.eml.mntr.emdRepDBName=sqlee
oracle.sysman.eml.mntr.emdRepPwdSeed=2928731563730921134
oracle.sysman.emSDK.svlt.ConsoleMode=standalone
oracle.sysman.emRep.dbConn.statementCacheSize=30
oracle.sysman.db.isqlplusUrl=http\://fivip-tech-lsq.fivip.com.cdlocal\:5560/isqlplus/dynamic
oracle.sysman.emSDK.svlt.ConsoleServerPort=1158
oracle.sysman.eml.mntr.emdRepRAC=FALSE
oracle.sysman.emSDK.emd.rt.useMonitoringCred=true
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
oracle.sysman.db.isqlplusWebDBAUrl=http\://fivip-tech-lsq.fivip.com.cdlocal\:5560/isqlplus/dba/dynamic
oracle.sysman.emSDK.svlt.ConsoleServerHost=fivip-tech-lsq.fivip.com.cdlocal
oracle.sysman.eml.mntr.emdRepDBID=1884182641
oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1158
oracle.sysman.eml.mntr.emdRepServer=fivip-tech-lsq.fivip.com.cdlocal
oracle.sysman.eml.mntr.emdRepSID=sqlee
oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=fivip-tech-lsq.fivip.com.cdlocal)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=sqlee.cd.com)))
oracle.sysman.emSDK.sec.ReuseLogonPassword=true
oracle.sysman.eml.mntr.emdRepUser=SYSMAN
oracle.sysman.db.adm.conn.statementCacheSize=2
oracle.sysman.db.perf.conn.statementCacheSize=30

相关链接：

在Oracle10g中启动和关闭OEM--->http://www.eygle.com/archives/2005/10/howto_control_10goem.html