关于 Fatal NI connect error 12170

在 sqlnet.log 中错误如下:

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Linux: Version 10.2.0.1.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 29-NOV-2006 19:13:40
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=219.239.13.3)(PORT=19948))


# oerr tns 12170
12170, 00000, "TNS:Connect timeout occurred"
// *Cause: The server shut down because connection establishment or
// communication with a client failed to complete within the allotted time
// interval. This may be a result of network or system delays; or this may
// indicate that a malicious client is trying to cause a Denial of Service
// attack on the server.
// *Action: If the error occurred because of a slow network or system,
// reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT,
// SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values.
// If a malicious client is suspected, use the address in sqlnet.log to
// identify the source and restrict access. Note that logged addresses may
// not be reliable as they can be forged (e.g. in TCP/IP).

于是增大 sqlnet.ora 中的参数:
SQLNET.INBOUND_CONNECT_TIMEOUT = 30
SQLNET.RECV_TIMEOUT = 30
SQLNET.SEND_TIMEOUT = 30

在 listener.ora 增加:
INBOUND_CONNECT_TIMEOUT_LISTENER = 30

重启监听器:
lsnrctl reload
阅读更多

Oracle日志中alert_orcl.log出现Fatal NI connect error 12170,如何破?

08-08

Fatal NI connect error 12170.rnrn VERSION INFORMATION:rn TNS for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Time: 08-8月 -2017 08:36:50rn Tracing not turned on.rn Tns error struct:rn ns main err code: 12535rn rnTNS-12535: TNS: 操作超时rn ns secondary err code: 12560rn nt main err code: 505rn rnTNS-00505: 操作超时rn nt secondary err code: 60rn nt OS err code: 0rn Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=124.236.237.17)(PORT=49358))rnTue Aug 08 08:37:21 2017rnThread 1 cannot allocate new log, sequence 340646rnPrivate strand flush not completern Current log# 4 seq# 340645 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOGrnThread 1 advanced to log sequence 340646 (LGWR switch)rn Current log# 5 seq# 340646 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOGrnTue Aug 08 08:42:40 2017rnThread 1 cannot allocate new log, sequence 340647rnPrivate strand flush not completern Current log# 5 seq# 340646 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOGrnThread 1 advanced to log sequence 340647 (LGWR switch)rn Current log# 6 seq# 340647 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOGrnTue Aug 08 08:45:22 2017rnThread 1 cannot allocate new log, sequence 340648rnPrivate strand flush not completern Current log# 6 seq# 340647 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOGrnThread 1 advanced to log sequence 340648 (LGWR switch)rn Current log# 1 seq# 340648 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOGrnTue Aug 08 08:45:52 2017rnThread 1 advanced to log sequence 340649 (LGWR switch)rn Current log# 2 seq# 340649 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOGrnTue Aug 08 08:46:25 2017rnThread 1 cannot allocate new log, sequence 340650rnPrivate strand flush not completern Current log# 2 seq# 340649 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOGrnThread 1 advanced to log sequence 340650 (LGWR switch)rn Current log# 3 seq# 340650 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOGrn

数据库连接不稳定,出错Fatal NI connect error 12203

11-12

数据库服务器采用Oracle 10g,Windows 2003系统.rn应用程序运行在另外一台Oralce 8i 的数据库服务器上.应用程序通过insp连接字符串访问oracle 10g数据库服务器.rn应用程序用Pro*C写的程序以用户clengzha/clengzha@insp访问Oracle 10g数据库.但是程序启动并且运行OK,但是有时应用程序就莫名奇妙的退出.rn程序日志没有发现异常的地方.应用程序所在目录下有sqlnet.log如下:rn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\test_alm.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:51rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\test_alm.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:52rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn******************************************************************************************************************************************************************************rntnsname.ora配置如下:rn# D:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:\orant\net80\admin\tnsnames.orarn# Generated by Oracle Net8 AssistantrnrnINSP3.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=168.60.1.169)(PORT=1521))(CONNECT_DATA=(SID=insp)))rnrnCMEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=CM_SERVER)(PORT=1610))(ADDRESS=(PROTOCOL=TCP)(HOST=LSNR_SERVER)(PORT=1521)))(CONNECT_DATA=(SID=ORCL))(SOURCE_ROUTE=YES))rnrnTCPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Production1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))rnrnINSPT.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=online)(PORT=1521))(CONNECT_DATA=(SID=INSP)))rnrnNMPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=INSP)))rnrnEXTPROC_CONNECTION_DATA.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(Key=EXTPROC0))(CONNECT_DATA=(SID=extproc)))rnrnBEQ-LOCAL.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))(CONNECT_DATA=(SID=ORCL)))rnrnINSP.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.1.1.4)(PORT=1521))(CONNECT_DATA=(SID=JHY)))rnrnSPXEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=SPX)(Service=Server_lsnr))(CONNECT_DATA=(SID=ORCL)))rnrnTCP-LOOPBACK.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))rnrnrn请各位大侠帮帮忙.rnrn

没有更多推荐了,返回首页