大神门,菜鸟有礼了,请帮忙看看怎么解决:问题描述:偶发性的所有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)
)
)~
***********************************************************************
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)
)
)~
多数时候是正常,只发现过一次,这样: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)