各位大俠：
小弟最近遇到一個讓我抓狂的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)
)
)
)