(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=download))

(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=download)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=33535))

 

1、发现问题

近期发现listener.log频繁出现错误

 

截取部分listener.log如下：

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

25-SEP-2012 10:33:41 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=download)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=33535)) * establish * download * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

25-SEP-2012 10:33:41 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=download)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=28544)) * establish * download * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

真实错误频率比这个要高，平均每4次，报错4次。

 

2、检测系统后台进程

根据错误日志，应该是JAVA程序导致。根据这个思路查看后台进程

Ps –ef | grep java

oracle   22290     1  0 Jan11 ?        00:07:47 /opt/oracle/product/10g/jdk/bin/java -Djava.awt.headless=true -Doracle.oc4j.localhome=/opt/oracle/product/10g/sqlplus -Djava.security.properties=/opt/oracle/product/10g/oc4j/j2ee/home/config/jazn.security.props -jar /opt/oracle/product/10g/oc4j/j2ee/home/oc4j.jar -config /opt/oracle/product/10g/oc4j/j2ee/isqlplus/config/server.xml

oracle   24832 28427  2 10:28 pts/1    00:00:10 /opt/oracle/product/10g/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/opt/oracle/product/10g -Doracle.home=/opt/oracle/product/10g/oc4j -Doracle.oc4j.localhome=/opt/oracle/product/10g/neworadb_download/sysman -DEMSTATE=/opt/oracle/product/10g/neworadb_download -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/opt/oracle/product/10g/oc4j/j2ee/OC4J_DBConsole_neworadb_download/config/jazn.xml -Djava.security.policy=/opt/oracle/product/10g/oc4j/j2ee/OC4J_DBConsole_neworadb_download/config/java2.policy -Djava.security.properties=/opt/oracle/product/10g/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/opt/oracle/product/10g/neworadb_download -Dsysman.md5password=true -Drepapi.oracle.home=/opt/oracle/product/10g -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /opt/oracle/product/10g/oc4j/j2ee/home/oc4j.jar -config /opt/oracle/product/10g/oc4j/j2ee/OC4J_DBConsole_neworadb_download/config/server.xml

 

根据MOS所解释

Master Note for Enterprise Manager Configuration Assistant (EMCA) in Single Instance Database Environment [ID 1099271.1]

启用EM，然后数据库停库导致listener.log错误

 

3、因为我们不需求使用EM，所以决定关闭EM。

EM服务命令

emctl stop dbconsole

emctl start dbconsole

emctl status dbconsole

 

尝试关闭em

[ora@dg-pp ~]$ emctl stop dbconsole

TZ set to PRC

Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 

Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.

https://dg-pp:5500/em/console/aboutApplication

Stopping Oracle Enterprise Manager 10g Database Control ...

 ...  Stopped.

 

进程也没有了java进程

[ora@dg-pp ~]$ ps -ef | grep java

ora      15708 12542  0 23:14 pts/1    00:00:00 grep java

 

4、查看listener.log

(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=download)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=33535)) * establish * download * 12514

这些报错没有了。问题解决！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26442936/viewspace-774142/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26442936/viewspace-774142/