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/，如需轉載，請註明出處，否則將追究法律責任。