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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Listener refused the connection with the following error:ORA-12514, TNS:listenerError
- ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
- Unknown initial character set index ‘255‘ received from server. Initial client character set can beIndexServerclient
- Oracle的TNS-12502 錯誤原因及解決Oracle
- TNS問題排查 The listener supports no services
- ORACLE TNS Io異常End of TNS data channel&ORA-12518Oracle
- 【ORA】ORA-12547 TNS: Lost Contact錯誤診斷
- Oracle Database Server 'TNS Listener'遠端資料投毒漏洞OracleDatabaseServer
- Oracle OCP(43):listener.oraOracle
- ORA-00130: invalid listener address
- oracle 11g 【listener.ora tnsnames.ora】Oracle
- ORA-12519 TNS:no appropriate service handler foundAPP
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- The last packet successfully received from the server was 2,625 milliseconds ago.ASTServerGo
- 【ORA-】ORA-12547: TNS:lost contact錯誤的跟蹤分析
- ABP Framework Consuming HTTP APIs from a .NET ClientFrameworkHTTPAPIclient
- [20190622]收集SQLNet Message From Client資訊.txtSQLclient
- Oracle案例09——ORA-12154: TNS:could not resolve the connect identifier specifiedOracleIDE
- Oracle案例05——ORA-12162: TNS:net service name is incorrectly specifiedOracle
- 使用PLSQL客戶端登入ORACLE時報ORA-12502和ORA-12545錯誤的解決方案SQL客戶端Oracle
- ORA-00923: FROM keyword not found where expected
- ORA-20001 selecting from DBA_TAB_STATISTICS
- [20180918]等待事件SQL/Net more data from client.txt事件SQLclient
- [20180925]等待事件SQLNet more data from client 6.txt事件SQLclient
- [20180922]等待事件SQLNet more data from client 4.txt事件SQLclient
- [20180920]等待事件SQLNet more data from client 3.txt事件SQLclient
- [20180926]等待事件SQLNet more data from client 7.txt事件SQLclient
- Connect SQL Server from Linux Client using Windows Authentication and troubleshoot stepsSQLServerLinuxclientWindows
- oracle之 ORA-12557: TNS: 協議介面卡不可載入Oracle協議
- sqlplus登入資料庫報錯ORA-12547: TNS:lost contactSQL資料庫
- 主庫到standby報錯解決:Error 12154 received logging on to the standby ORA-12154Error
- oracle監聽檔案listener.ora for 10g/11gOracle
- ORA-16649: possible failover to another database prevents this database from beiAIDatabase
- 12cRAC打季度補丁時遇到ORA-12547: TNS:lost contact錯誤
- Oracle案例04——TNS-12547: TNS:lost contactOracle
- Broker reports ORA-16858: last communication time from redo source could not beAST
- ImportError: cannot import name 'get_ora_doc' from partially initialized moduleImportErrorZed
- 【故障解決】ORA-17630: Mismatch in the remote file protocol version client 2REMProtocolclient
- Listener