TNS-12535 Unable To Connect To Remote Database using certain Applications

今天到sqlnet.log看有一些这样的错误信息:

ORA/TNS-12535: TNS:operation timed out

Symptoms:

      TNSPING command fails with the TNS-12535 error:

C:\oracle\ora92\network\admin\sqlnet.ora
/]r@+s!I/[c0Used TNSNAMES adapter to resolve the aliasITPUB个人空间$R4P4W]q1]`[0T6W
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
*xu9V'Xa!FV3io0192.168.1.101)(PORT = 1521))) (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED)))ITPUB个人空间 [[H6k6AvtmU:v9pG
TNS-12535: TNS:operation timed out

Verified the issue by the trace file Oracle Net Client trace file, 'cli_3672_1.trc' which
0qT{]l4MgO0displays the following error stack while trying to connect to the the address descriptor:

Calling address:
cl^0| \I0(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521)))

(CONNECT_DATA=(SID=ORCL)(SERVER=DEDICATED)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplusw.exe)(HOST=USERPC100)(USER=john.smith))))

metalink解决办法:

B"F9tp
@:_&W2BVS2G0To implement the solution, please execute the following steps:

T~G*L
X IZ r*}"a9t6@0Add the Oracle Client side applications to the Windows Firewall Exception List.

ITPUB个人空间#yN(|!`#m-hZ
Click Start, Control Panel, and double click 'Windows Firewall'
!R9yX]n|.L
j]*b0Next, select the 'Exceptions Tab'

Use the 'Add Program...' dialog to add the programs to the Exception List.

If unable to navigate to the 'Windows Firewall' configurations window, you may be able to manually access the Window Firewall in Windows XP SP2 window by:

Clicking Start, click Run, type Firewall.cpl, and then click OK

Then from there you can edit the programs from the Exceptions Tab.

不过,今天检查发现,ERP客户端是10.1.0.2的版本,而服务器是10.2.0.1的版本,准备晚上把ERP服务器的客户端更新