ITPub博客

首页 > 数据库 > Oracle > 一次ora-12535/ora-12170问题解决

一次ora-12535/ora-12170问题解决

原创 Oracle 作者:zhyuh 时间:2005-08-05 14:41:21 0 删除 编辑

在windows XP上装了oracle10g并建了库,可是局域网内的其他及其却连不上该数据库,出现如下错误:

[@more@]

C:Documents and Settingszhonghua.yu>sqlplus scott/tiger@bo

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 --> security center --> windows firewall,选择 off, 再重启lisnter,连接成功。

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

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

下一篇: 借用土地
请登录后发表评论 登录
全部评论
  • 博文量
    233
  • 访问量
    2008664