Fatal NI connect error 12170 TNS-12535 TNS-00505 解決辦法
Fatal NI connect error 12170 TNS-12535 TNS-00505 解決辦法
1. alert.log報警日誌
Wed Sep 10 08:06:45 2014
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 -
Production
Oracle Bequeath NT Protocol Adapter for Linux: Version
11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version
11.2.0.3.0 - Production
Time: 10-SEP-2014 08:06:45 <=instance drop
session time
Tracing not turned on.
Tns error struct:
ns main
err code: 12535
TNS-12535: TNS:operation timed out
ns
secondary err code: 12560
nt main err code: 505
TNS-00505:
Operation timed out
nt secondary err code: 110
nt OS err code:
0
Client address:
(ADDRESS=(PROTOCOL=tcp)(HOST=10.124.88.125)(PORT=11901))
TNS for Linux: Version 11.2.0.3.0 -
Production
Oracle Bequeath NT Protocol Adapter for Linux: Version
11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version
11.2.0.3.0 - Production
Time: 10-SEP-2014 08:06:45 <=instance drop
session time
Tracing not turned on.
Tns error struct:
ns main
err code: 12535
TNS-12535: TNS:operation timed out
ns
secondary err code: 12560
nt main err code: 505
TNS-00505:
Operation timed out
nt secondary err code: 110
nt OS err code:
0
Client address:
(ADDRESS=(PROTOCOL=tcp)(HOST=10.124.88.125)(PORT=11901))
--(HOST=10.124.88.125)(PORT=11901)這個session被instance drop時間是10-SEP-2014
08:06:45
08:06:45
2.
listener.log日誌
--listener.log位於$ORACLE_BASE/diag/tnslsnr///trace/.log
listener.log日誌
--listener.log位於$ORACLE_BASE/diag/tnslsnr/
10-SEP-2014 07:36:15 *
(CONNECT_DATA=(SERVICE_NAME=DOUDOU)(CID=(PROGRAM=c:\app\administrator\product\11.2.0\dbhome_1\bin\ORACLE.EXE)(HOST=FYUJHRF)(USER=SYSTEM)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=10.124.88.125)(PORT=11901)) * establish * DOUDOU
* 0
--10-SEP-2014 07:36:15=> into database time
(CONNECT_DATA=(SERVICE_NAME=DOUDOU)(CID=(PROGRAM=c:\app\administrator\product\11.2.0\dbhome_1\bin\ORACLE.EXE)(HOST=FYUJHRF)(USER=SYSTEM)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=10.124.88.125)(PORT=11901)) * establish * DOUDOU
* 0
--10-SEP-2014 07:36:15=> into database time
綜上所述:(HOST=10.124.88.125)(PORT=11901)這個session從10-SEP-2014
07:36:15連結資料庫上,10-SEP-2014 08:06:45被instance drop掉,在資料庫中活動了近30分鐘。
07:36:15連結資料庫上,10-SEP-2014 08:06:45被instance drop掉,在資料庫中活動了近30分鐘。
總結:
--(HOST=10.124.88.125) =》確定連結的客戶端IP地址
--establish
=》已經連結
--SERVICE_NAME=DOUDOU
=》連結的資料庫名DOUDOU
##注意:alert.log有些(HOST=10.124.88.125)(PORT=11901),在listener.log中找不到。這很正常,因為只有establish狀態的session才會被listener.log記錄。##
--(HOST=10.124.88.125) =》確定連結的客戶端IP地址
--establish
=》已經連結
--SERVICE_NAME=DOUDOU
=》連結的資料庫名DOUDOU
##注意:alert.log有些(HOST=10.124.88.125)(PORT=11901),在listener.log中找不到。這很正常,因為只有establish狀態的session才會被listener.log記錄。##
解決辦法:
1.確定網路防火牆設定是否適合現有的業務需求(應用監控、流量監控、系統監控)
2.確定網路防火牆是符合業務需求後,可以嘗試在sqlnet.ora中新增SQLNET.EXPIRE_TIME引數
舉例:SQLNET.EXPIRE_TIME=n
Where is a non-zero value set in minutes. 此引數會自動解決DCD問題(殭屍程式問題)。
1.確定網路防火牆設定是否適合現有的業務需求(應用監控、流量監控、系統監控)
2.確定網路防火牆是符合業務需求後,可以嘗試在sqlnet.ora中新增SQLNET.EXPIRE_TIME引數
舉例:SQLNET.EXPIRE_TIME=n
Where
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-1268869/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Fatal NI connect error 12170 TNS-12535 TNS-00505Error
- Fatal NI connect error 12170Error
- Fatal NI connect error 12170 TNS-12535/TNS-00505 TNS:operation timed outError
- Fatal NI connect error 12170.Error
- Fatal NI connect error 12170 錯誤Error
- Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed outError
- Fatal NI connect error 12170.報錯處理Error
- Alert Log中“Fatal NI connect error 12170”錯誤問題Error
- [重慶思莊每日技術分享]-alert頻繁出現12170. Fatal NI connect errorError
- VS 2017 Git failed with a fatal error的解決辦法GitAIError
- ORA-12170錯誤的解決辦法
- composer 安裝擴充套件出現 "PHP Fatal error: Allowed memory ..."的解決辦法套件PHPError
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- FTP Connection refused error 解決辦法FTPError
- Vue 下 ESLint 的 error 解決辦法VueEsLintError
- CentOS 6.x connect: Network is unreachable 解決辦法CentOS
- ERROR 1290 (HY000) 解決辦法Error
- ld.so.1: oracle: fatal: relocation error解決方法OracleError
- TNS-12535 TNS-00505的處理方法
- 11gr2 alert日誌中報TNS-12535 TNS-00505原因及解決方法
- Openstack的error殭屍例項的解決辦法Error
- Myeclipse 錯誤An internal error has occurred 解決辦法EclipseError
- FATAL ERROR: Could not find ./bin/my_print_defaults 解決方法Error
- mysqldump error1066 錯誤的解決辦法MySqlError
- RuntimeError: cuDNN error: CUDNN_STATUS_EXECUTION_FAILED解決辦法ErrorDNNAI
- iOS Error Domain=NSURLErrorDomain Code=-999 “cancelled” 解決辦法iOSErrorAI
- Ubuntu下 fatal error: Python.h: No such file or directory 解決方法UbuntuErrorPython
- php在iis上配置時報mysql_connect錯誤解決辦法PHPMySql
- SSL錯誤ssl connect error 35的解決方案Error
- Navicat tnt版本提示“failed to save password error code”的解決辦法AIError
- 安裝VMware出現“Error 1406”的解決辦法Error
- Composer 記憶體不足解決方案 PHP Fatal error: Out of memory記憶體PHPError
- FATAL - Fatal error: Target Interaction Manager failed at StartupErrorAI
- pecl PHP Parse error: syntax error, unexpected 'new' (T_NEW) 以及 XML缺失解決辦法PHPErrorXML
- Cargo invocation has failed: Error: exit code: 101.解決辦法CargoAIError
- 使用 Sublime 工具時報Decode error - output not utf-8解決辦法Error
- 安裝MySql出現Error Nr.1045的解決辦法MySqlError
- Proguard returned with error code 1. See console解決辦法”Error