一次ora-12535/ora-12170問題解決

在windows XP上裝了oracle10g並建了庫，可是區域網內的其他及其卻連不上該資料庫，出現如下錯誤：

[@more@]

C:Documents and Settingszhonghua.yu>sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Aug 5 14:34:13 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred

C:Documents and Settingszhonghua.yu>tnsping bo
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 05-AUG-2005 14:35:03
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
c:oracleproduct10.1.0db_1networkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = tcsch176hp.tcschina.com)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle)))
TNS-12535: TNS:operation timed out

查詢原因，發現文件http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=544105.994 上說“XP with SP2 installs a firewall by default.”
於是點選 control panel --&gt security center --&gt windows firewall,選擇 off， 再重啟lisnter，連線成功。

經測試，發現只和資料庫伺服器端的防火牆設定有關，而和客戶端的防火牆設定無關。