大神門，菜鳥有禮了，請幫忙看看怎么解決：
問題描述：
偶發性的所有oracle報錯連接超時，lsnrctl stop過幾秒后，再lsnrctl start就會好了。
一、sqlnet.log報如下錯誤：
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 25-JUN-2017 17:52:44
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.252.140.91)(PORT=36851))
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 25-JUN-2017 17:53:56
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.252.140.91)(PORT=55450))
二、alert/log.xml有大量的錯誤日志：
<msg time='2017-06-25T17:52:43.711+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
host_addr='10.46.64.251' pid='29789'>
<txt>WARNING: inbound connection timed out (ORA-3136)
</txt>
</msg>
<msg time='2017-06-25T17:52:44.092+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
host_addr='10.46.64.251' pid='29817'>
<txt>WARNING: inbound connection timed out (ORA-3136)
</txt>
</msg>
<msg time='2017-06-25T17:52:44.092+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
host_addr='10.46.64.251' pid='29821'>
<txt>WARNING: inbound connection timed out (ORA-3136)
</txt>
</msg>
<msg time='2017-06-25T17:52:44.129+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
host_addr='10.46.64.251' pid='29673'>
<txt>WARNING: inbound connection timed out (ORA-3136)
</txt>
</msg>
<msg time='2017-06-25T17:53:56.147+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
host_addr='10.46.64.251' pid='31964'>
<txt>WARNING: inbound connection timed out (ORA-3136)
</txt>
</msg>
三、相關配置：
sessions：20000
process：20000
# listener.ora Network Configuration File: /mnt/edus/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = iZbp1etmub1n1kbtp0sk8hZ)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /mnt/edus/oracle
INBOUND_CONNECT_TIMEOUT_LISTENER=90
# sqlnet.ora Network Configuration File: /mnt/edus/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
#SQLNET.INBOUND_CONNECT_TIMEOUT=100
SQLNET.EXPIRE_TIME = 5
DIAG_ADR_ENABLED = OFF
DIAG_ADR_ENABLED_LISTENER = OFF
SQLNET.INBOUND_CONNECT_TIMEOUT=100
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
sqlnet.authentication_services=(none)
ADR_BASE = /mnt/edus/oracle
~
# tnsnames.ora Network Configuration File: /mnt/edus/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = iZbp1etmub1n1kbtp0sk8hZ)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
~
uj5u.com熱心網友回復：
在連接不上的時候，tnsping ORCL 100，持續的看監聽及網路狀態uj5u.com熱心網友回復：
多數時候是正常，只發現過一次，這樣：
OK (10 msec)
OK (10 msec)
OK (0 msec)
OK (30 msec)
OK (80 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (10 msec)
OK (0 msec)
OK (60 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (50 msec)
OK (0 msec)
OK (10 msec)
OK (0 msec)
OK (0 msec)
OK (40 msec)
OK (210 msec)
OK (70 msec)
OK (50 msec)
OK (80 msec)
OK (1060 msec)
OK (880 msec)
OK (1220 msec)
OK (4920 msec)
uj5u.com熱心網友回復：
你的網路看上去是有問題， 最后幾次的PING開始跳PING了，幾千毫秒了uj5u.com熱心網友回復：
可能是網路不穩定吧轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/92150.html
標籤：高級技術