Oracle10g ora12170,一次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，连接成功。

经测试，发现只和数据库服务器端的防火墙设置有关，而和客户端的防火墙设置无关。