Listener refused the connection with the following error:ORA-12514, TNS:listener
當我們更換ip地址時,會遇到這樣的報錯,這是由於 ip地址改變引起的“ORA-12541:TNS:無監聽程式”錯誤。
我們在WINDOWS.X64_193000_db_home\network\admin\tnsnames.ora中修改其中你改變了的IP地址
完了之後重啟Oracle監聽服務。
或者你把你的IP地址改成檔案中的固定IP地址,這樣也可以連線上資料庫。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70023352/viewspace-2929136/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 狀態: 失敗 -測試失敗: Listener refused the connection with the following error: ORA-12505, TNS:listener doesError
- oracle listener錯誤Linux Error: 111: Connection refusedOracleLinuxError
- TNS Listener Hang, New Child Listener Process Forked
- TNS-12518: TNS:listener could not hand off client connectionclient
- TNS-12518 TNS listener could not hand off client connectionclient
- ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) (轉)ErrorServer
- An error from listenerError
- ORA-12518: TNS:listener could not hand off client connectionclient
- ORA-12518, TNS:listener could not hand off client connectionclient
- Intermittent TNS Listener Hang, New Child Listener Process Forked [ID 340091.1]MIT
- ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- TNS問題排查 The listener supports no services
- 記一次解決:TNS-12518: TNS:listener could not hand off client connectionclient
- TNS-12541: TNS:no listener錯誤處理
- TNS-12518: TNS:listener could not hand off client connection For ORACLE 10G (AIX6.1)clientOracle 10gAI
- TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When Starting the ListenerLinuxError
- FTP Connection refused error 解決辦法FTPError
- 關於local_listener、remote_listener、current_listenerREM
- remote_listener和listener passwordREM
- Oracle Database Server 'TNS Listener'遠端資料投毒漏洞OracleDatabaseServer
- Connecting to ASM through the TNS Listener from a Client DesktopASMclient
- Listener
- remote_listener和local_listenerREM
- java.net.ConnectException: Connection refused (Connection refused)JavaException
- ORA-12500: TNS:listener failed to start a dedicated server processAIServer
- ORA-12500 TNS : listener failed to start a dedicated server processAIServer
- AS編譯不通過,提示Error:Connection refused: connect編譯Error
- local_listener ,remote_listener 的配置REM
- Listener & FilterFilter
- Oracle ListenerOracle
- mysql connection refusedMySql
- listener start fail TNS-12555 利用trace找到問題AI
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- local_listener與remote_listener詳述REM
- ORA - 12502 TNS:listener received no CONNECT_DATA from clientclient
- JavaWeb-ListenerJavaWeb
- Filter&ListenerFilter