大神門，菜鳥有禮了，請幫忙看看怎么解決：
問題描述：
偶發性的所有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熱心網友回復：
沒遇見過，可以嘗試下PING一段時間看看是否網路有問題uj5u.com熱心網友回復：
測驗一下網路，看看網路的穩定性如何轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/90743.html
標籤：基礎和管理
下一篇：Oracle分頁查詢，用游標