TNS 超時

[复制链接]
查看11 | 回复5 | 2011-2-18 11:42:48 | 显示全部楼层 |阅读模式
oracle 11g
在alert.log中發現:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Time: 14-NOV-2011 22:10:41
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS

peration timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.57.21)(PORT=2629))
Mon Nov 14 22:10:42 2011

這是什麽原因造成的啊

回复

使用道具 举报

千问 | 2011-2-18 11:42:48 | 显示全部楼层
之前都沒有出現的,就最近才發現
回复

使用道具 举报

千问 | 2011-2-18 11:42:48 | 显示全部楼层
http://www.xifenfei.com/1812.html
怎么都是这个问题
回复

使用道具 举报

千问 | 2011-2-18 11:42:48 | 显示全部楼层
xifenfei 发表于 2011-11-15 09:15
http://www.xifenfei.com/1812.html
怎么都是这个问题

我看了你這篇文章,可是DIAG_ADR_ENABLED = OFF 是默認為OFF的吧
回复

使用道具 举报

千问 | 2011-2-18 11:42:48 | 显示全部楼层
xifenfei 发表于 2011-11-15 09:15
http://www.xifenfei.com/1812.html
怎么都是这个问题

而且目前有幾台client就是連不進來,總出現超時現象

回复

使用道具 举报

千问 | 2011-2-18 11:42:48 | 显示全部楼层
g644516804 发表于 2011-11-15 09:19
我看了你這篇文章,可是DIAG_ADR_ENABLED = OFF 是默認為OFF的吧

Beginning with Oracle Database 11g, Oracle Database includes an advanced fault diagnosability infrastructure for preventing, detecting, diagnosing, and resolving problems. The problems that are targeted in particular are critical errors such as those caused by database code bugs, metadata corruption, and customer data corruption.
When a critical error occurs, it is assigned an incident number, and diagnostic data for the error (traces, dumps, and more) are immediately captured and tagged with this number. The data is then stored in the automatic diagnostic repository (ADR)—a file based repository outside the database—where it can later be retrieved by incident number and analyzed.
ADR is enabled by default. The use of the following parameters depends on whether ADR is enabled.
This section is divided into those parameters used when ADR is enabled (when DIAG_ADR_ENABLED is set to on) and those used when ADR is disabled (when DIAG_ADR_ENABLED is set to off). Non-ADR parameters listed in the sqlnet.ora file are ignored when ADR is enabled.
http://download.oracle.com/docs/ ... 1/b28317/sqlnet.htm
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行