数据库可以连接，但是对表的查询连接不上

最新推荐文章于 2024-09-26 20:06:24 发布

原创最新推荐文章于 2024-09-26 20:06:24 发布 · 947 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #authentication #file #database #network #oracle

database 专栏收录该内容

41 篇文章

订阅专栏

本文介绍了解决Oracle数据库连接超时错误ORA-3136的方法，通过修改sqlnet.ora文件中的SQLNET.AUTHENTICATION_SERVICES参数为(NONE)，可以有效解决连接超时的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

WARNING: inbound connection timed out (ORA-3136)
Mon Mar 23 11:11:23 2009
WARNING: inbound connection timed out (ORA-3136)
Mon Mar 23 11:13:55 2009
WARNING: inbound connection timed out (ORA-3136)

对sqlnet.ora 修改：

# sqlnet.ora Network Configuration File: C:/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

就是这一句：

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE