TNS-12547 Linux Error: 104: Connection reset by peer
refs:
http://blog.csdn.net/daimin1983/article/details/4291661
http://space.itpub.net/index.php?action/viewspace/itemid/629063
---------------
TNS-12547 Linux Error: 104: Connection reset by peer
解決過程參考:http://blog.chinaunix.net/u/7121/showart_403812.html
[oracle@MyMachine log]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-JUN-2009 09:53:26
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /opt/oracle/product/10.2.1/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.1/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.1/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MyMachine.localdomain)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyMachine.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
解決過程:
[oracle@MyMachine log]$ more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
10.10.5.24 MyMachine.localdomain
10.10.3.254 host54.localdomain
[root@MyMachine ~]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost #新增
10.10.5.24 MyMachine.localdomain
10.10.3.254 host54.localdomain
重新啟動監聽:
[oracle@MyMachine log]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-JUN-2009 09:55:47
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /opt/oracle/product/10.2.1/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.1/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.1/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MyMachine.localdomain)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 23-JUN-2009 09:55:48
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10.2.1/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.1/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MyMachine.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
在網上搜尋一下,另一種TNS-12547: TNS:lost contact的情況,具體錯誤如下:
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
原因:listener.log檔案超過2G
解決方法:清空日誌檔案
[oracle@chicago ~]$ cd $ORACLE_HOME/network/log
[oracle@chicago log]$ cat /dev/null > listener.log
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/350519/viewspace-1056123/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- TNS-12547,Linux Error: 104: Connection reset by peerLinuxError
- Connection reset by peer: socket write errorError
- TNS-12547TNS-12560 TNS-00517 Linux Error: 104: Connection reset by peerLinuxError
- java.io.IOException: Connection reset by peerJavaException
- 連線華為雲的Redis服務報錯“Error: Connection reset by peer”RedisError
- 【Azure Cache for Redis】Python Djange-Redis連線Azure Redis服務遇上(104, 'Connection reset by peer')RedisPython
- go grpc: connection reset by peer 的一種解決方案GoRPC
- 【Azure Redis 快取】 Python連線Azure Redis, 使用redis.ConnectionPool 出現 "ConnectionResetError: [Errno 104] Connection reset by peer"Redis快取PythonError
- Kubelet 錯誤日誌 broken pipe 和 connection reset by peer 的原因分析
- 免密scp解決ssh_exchange_identification:read connection reset by peer 原因IDE
- Sqoop從Oracle抽數錯:IO Error: Connection resetOOPOracleError
- /etc/resolv.conf 導致 oracle 11g TNS解析緩慢甚至 TNS-12547 Linux Error: 104OracleLinuxError
- oracle OGG-01232 Receive TCP params error:TCP/IP error 232(connection reset)OracleTCPError
- HttpClient遭遇Connection Reset異常,如何正確配置?HTTPclient
- oracle listener錯誤Linux Error: 111: Connection refusedOracleLinuxError
- Dr.Elephant mysql connection errorMySqlError
- ERROR: UTL_SMTP.OPEN_CONNECTIONError
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- JMETER java.net.SocketException: Connection reset 報錯解決方案JMeterJavaException
- SecureCRT連線CentOS不間斷出現“Connection was reset.”SecurecrtCentOS
- 從Connection Reset問題淺談DBCP的使用技巧薦
- Dr.Elephant mysql connection error薦MySqlError
- weblogic連線池重置(Connection reset)問題解決方案Web
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- Error: Connection activation failed: Device not managed by NetworkManagerErrorAIdev
- FTP Connection refused error 解決辦法FTPError
- 錯誤 101 (net::ERR_CONNECTION_RESET):連線已重置
- Connection to x as user y failed: ERROR: Wrong password for userAIError
- The connection to adb is down, and a severe error has occured.Error
- tomcat連線池不夠-java.sql.SQLException: Io 異常: Connection resetTomcatJavaSQLException
- AS編譯不通過,提示Error:Connection refused: connect編譯Error
- Unknown SSL protocol error in connection to xxx:443ProtocolError
- Software caused connection abort: socket write error/mysql/tomcatErrorMySqlTomcat
- tomcat 啟動應用報錯:java.sql.SQLException: Io 異常: Connection resetTomcatJavaSQLException
- 記錄redis佇列read error on connection to錯誤Redis佇列Error
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- Android-The connection to adb is down, and a severe error has occuredAndroidError
- [轉]Android Studio匯入工程報錯 Error:Cause: peer not authenticated 解決方案AndroidError