TNS-12547TNS-12560 TNS-00517 Linux Error: 104: Connection reset by peer
今天在Linux系統下的oracle上建立資料庫,開始時監聽起來了,資料庫無法監聽服務,開啟listener.ora發現,確實監聽例項的部分,即:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
加上後,監聽可以啟動,資料庫也可以註冊了。
後來發現例項啟動不起來,錯誤資訊有TNS-12547:TNS-12560 TNS-00517 Linux Error: 104: Connection reset by peer
具體錯誤提示如下:
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
上網查閱後,發現時hosts檔案修改錯誤。
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
127.0.0.1 redhat
紅色的這一行,一定要有。
改完,儲存後,重啟監聽即可。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
加上後,監聽可以啟動,資料庫也可以註冊了。
後來發現例項啟動不起來,錯誤資訊有TNS-12547:TNS-12560 TNS-00517 Linux Error: 104: Connection reset by peer
具體錯誤提示如下:
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
上網查閱後,發現時hosts檔案修改錯誤。
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
127.0.0.1 redhat
紅色的這一行,一定要有。
改完,儲存後,重啟監聽即可。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22275400/viewspace-751344/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- TNS-12547,Linux Error: 104: Connection reset by peerLinuxError
- TNS-12547 Linux Error: 104: Connection reset by peerLinuxError
- Connection reset by peer: socket write errorError
- 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
- oracle OGG-01232 Receive TCP params error:TCP/IP error 232(connection reset)OracleTCPError
- 【故障|監聽】TNS-12518、TNS-00517和 Linux Error:32:Broken pipeLinuxError
- 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