oracle8i客户端 12535,让人抓狂的TNS-12535异常

各位大侠：

小弟最近遇到一个让我抓狂的TNS-12535问题，尝试了METALINK上面介绍的所有处理方法，都没有改善，请求各位指点!

数据库运行环境：IBM RAC 双机

数据库版本：10.2.0.4

异常情况介绍：

客户反馈,3月30日迁移数据库存储，3月31切换归档后，发现原来的TAF服务名不能用(客户没有启动TAF)，逐让设置了TAF服务名的客户修改服务名为具体的实例名，客户端链接不时出现TNS-12535链接超时的问题，在4月6日启动TAF服务以后，让客户使用TAF方式链接数据库，但故障依旧，客户端仍然会不时出现超时。该应用系统为C/S结构。

查看ALTERT.LOG无任何错误，查看LISTENER.LOG亦无任何错误，使用一台测试机TNSPING TAF服务名 2000无异常，服务端SQLNET.LOG有错误日志。

相关设置；

1、数据库设置

NUM NAME                                     VALUE

-------- ---------------------------------------- ----------

25 processes                                700

26 sessions                                 775

860 local_listener                           LISTENERS_DLGIS1

861 remote_listener                          LISTENERS_DLGIS

2、LISTENER.ORA

INBOUND_CONNECT_TIMEOUT_LISTENER_YPYTHA=0

LISTENER_YPY=

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.81.59)(PORT = 1521)(IP = FIRST))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.81.57)(PORT = 1521)(IP = FIRST))

)

)

SID_LIST_LISTENER_YPY =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

)

3、TNSNAMES.ORA

LISTENERS_DLGIS1 =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.81.59)(PORT = 1521))

)

LISTENERS_DLGIS =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.81.59)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.81.60)(PORT = 1521))

)

4、SQLNET.ORA

SQLNET.INBOUND_CONNECT_TIMEOUT=0

5、SQLNET.LOG

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production

TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production

Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production

Time: 13-APR-2010 21:56:38

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.130.11.50)(PORT=1676))

6、客户端设置

客户端已经在HOSTS文件中添加了VIP对应的HOSTNAME，TAF配置如下：

DLGIS =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.81.59)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.81.60)(PORT = 1521))

(LOAD_BALANCE = yes)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = dlgisdb)

(FAILOVER_MODE =

(TYPE = SELECT)

(METHOD = BASIC)

(RETRIES = 180)

(DELAY = 20)

)

)

)