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
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.1.101)(PORT = 1521))) (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED)))
TNS-12535: TNS:operation timed out

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

Calling address:
(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解决办法:

To implement the solution, please execute the following steps:

Add the Oracle Client side applications to the Windows Firewall Exception List.

Click Start, Control Panel, and double click 'Windows Firewall'
Next, 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服务器的客户端更新

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/175005/viewspace-366139/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/175005/viewspace-366139/