ORA - 12502 TNS:listener received no CONNECT_DATA from client
今天在檢查listener.log的時候發現了一個錯誤：
23-MAR-2009 11:15:17 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
23-MAR-2009 11:17:34 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
23-MAR-2009 11:17:52 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
The error indicates that the Listener did not recieve the complete information of the connect string, it lacks the CONNECT_DATA section.
查了一下相關資料，認為有些內部連線或者一些工具的連線方式中沒有包含connect_data內容，就會出現這種錯誤，或者說是提示警告。由於客戶端沒有發生任何異常連線，此問題沒有頻繁的出現，再此記錄一下。
metalink_id:
| Subject: | TroubleShooting Guide For ORA - 12502 TNS:listener received no CONNECT_DATA from client | |||
| : | 453505.1 | Type: | TROUBLESHOOTING | |
| Modified Date : | 17-NOV-2008 | Status: | PUBLISHED | |
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9252210/viewspace-576447/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Connecting to ASM through the TNS Listener from a Client DesktopASMclient
- ORA-12518: TNS:listener could not hand off client connectionclient
- ORA-12518, TNS:listener could not hand off client connectionclient
- TNS-12518: TNS:listener could not hand off client connectionclient
- TNS-12518 TNS listener could not hand off client connectionclient
- ORA-16198: LGWR received timedout error from KSRError
- Listener refused the connection with the following error:ORA-12514, TNS:listenerError
- ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) (轉)ErrorServer
- Unknown initial character set index ‘255‘ received from server. Initial client character set can beIndexServerclient
- 記一次解決：TNS-12518: TNS:listener could not hand off client connectionclient
- ORA-12500: TNS:listener failed to start a dedicated server processAIServer
- ORA-12500 TNS : listener failed to start a dedicated server processAIServer
- An error from listenerError
- TNS Listener Hang, New Child Listener Process Forked
- TNS-12518: TNS:listener could not hand off client connection For ORACLE 10G （AIX6.1)clientOracle 10gAI
- TNS-12541: TNS:no listener錯誤處理
- Intermittent TNS Listener Hang, New Child Listener Process Forked [ID 340091.1]MIT
- Oracle的TNS-12502 錯誤原因及解決Oracle
- 狀態: 失敗 -測試失敗: Listener refused the connection with the following error: ORA-12505, TNS:listener doesError
- ORA-12528: TNS:listener: all appropriate instances are blocking new connectionsAPPBloC
- 手工配置listener.ora檔案及TNS-01201錯誤
- Oracle的TNS-12502錯誤原因及解決(轉)Oracle
- Slave: received 0 length packet from server, apparent master shutdownServerAPPAST
- linux log中大量 Received SNMP packet(s) from UDPLinuxUDP
- SQL*Net message from clientSQLclient
- SQL*Net more data from clientSQLclient
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- 消除linux log中的大量Received SNMP packet(s) from UDPLinuxUDP
- linux_ora10g_rac_listener.ora+tnsnames.oraLinux
- Oracle OCP(43)：listener.oraOracle
- Oracle Database Server 'TNS Listener'遠端資料投毒漏洞OracleDatabaseServer
- How to Setup SCAN Listener and Client for TAF and Load Balancingclient
- sqlnet.ora tnsname.ora listener.ora 的作用SQL
- ORA-24550 Signal Received Error的解決方法Error
- oracle 11g 【listener.ora tnsnames.ora】Oracle
- EF：Oracle.DataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specifiedOracleclientExceptionIDE
- ORA-19511: Error received from media manager layer, error text: ANS0322E (RC-72) no text available fErrorAI
- 完整的listener.ora，tnsname.ora和sqlnet.oraSQL