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