ITPub博客

首页 > 数据库 > Oracle > Oracle TNS-12514: TNS:listener does not currently know of service requested in c

Oracle TNS-12514: TNS:listener does not currently know of service requested in c

原创 Oracle 作者:lovehewenyu 时间:2013-10-11 11:47:28 0 删除 编辑

(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.

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
10年金融行业老鸟。Oracle,Mysql,PostgreSQL,EMC 存储,NBU备份。微信/电话 18211103995

注册时间:2012-02-03

  • 博文量
    283
  • 访问量
    1369917