job error

xteitxu

数据库alter  log中出现大量的以下报错。这是怎么回事啊？这个job会定时向其它国家分发数据。

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:
    TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production
  Time: 12-3月 -2012 21:08:26
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
   
TNS-12535: TNS: 操作超时
    ns secondary err code: 12560
    nt main err code: 505
   
TNS-00505: 操作超时
    nt secondary err code: 60
    nt OS err code: 0
  Client address: <unknown>
Errors in file c:\app\administrator\diag\rdbms\cnpro\mdlcnpro\trace\cnpro_j000_6032.trc:
ORA-12012: error on auto execute of job 204
ORA-12170: TNS:Connect timeout occurred
ORA-06512: at "365MASTER.SYGETDATASYN", line 46
ORA-06512: at line 1
Mon Mar 12 21:18:21 2012

Maclean Liu(刘相兵

ORA-12012: error on auto execute of job 204
ORA-12170: TNS:Connect timeout occurred
ORA-06512: at "365MASTER.SYGETDATASYN", line 46
ORA-06512: at line 1


可能的话做一个 CLIENT SQL NET TRACE， 如何做trace 详见：

http://www.oracledatabase12g.com ... t_trace_logging.htm

cshiqin

应该是连不到其他国家的网络

gtlions

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).