(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/，如需轉載，請註明出處，否則將追究法律責任。