Fatal NI connect error 12170.

oracle 11g 配置透明网关 连接 sqlserver ,平时select  * from test@YLCW 没问题,但是执行时间太长后总报错如下:

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
        Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
        Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
  Time: 06-3月 -2014 15:42:04
  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: (ADDRESS=(PROTOCOL=tcp)(HOST=29.6.101.100)(PORT=1521))
Thu Mar 06 16:22:23 2014
Errors in file c:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_reco_7124.trc:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from YLCW

文件c:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_reco_7124.trc中的内容为:

Trace file c:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_reco_7124.trc
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1
CPU                 : 64 - type 8664, 32 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:43934M/131048M, Ph+PgF:41076M/131046M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 21
Windows thread id: 7124, image: ORACLE.EXE (RECO)


*** 2014-03-05 13:55:58.622
*** SESSION ID86.1) 2014-03-05 13:55:58.622
*** CLIENT ID) 2014-03-05 13:55:58.622
*** SERVICE NAMESYS$BACKGROUND) 2014-03-05 13:55:58.622
*** MODULE NAME) 2014-03-05 13:55:58.622
*** ACTION NAME) 2014-03-05 13:55:58.622

ERROR, tran=2.21.1769, session#=1, ose=0:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from YLCW

*** 2014-03-05 13:56:31.694
ERROR, tran=2.21.1769, session#=1, ose=0:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from YLCW

*** 2014-03-06 16:22:23.343
ERROR, tran=2.21.1769, session#=1, ose=0:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from YLCW

标签: 暂无标签
super712

写了  篇文章,拥有财富 ,被  人关注

转播转播 分享分享 分享淘帖
回复

使用道具

成为第一个吐槽的人

您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

意见
反馈