JDBC连接Oracle问题：The network Adapter could not establish the connetion.

2004-04-08 05:09:00 1.1k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

20掌握JavaScript事件绑定：从入门到跨浏览器兼容的实战秘籍想让网页交互更灵动？JavaScript 事件绑定是关键！本文从常见鼠标、键盘、表单事件入手，详细讲解三种绑定方式，结合示例代码展示on事件、addEventListener和attachEvent用法，并提供跨浏览器兼容方案，助你轻松打造流畅交互体验。阅读详情

JDBC连接Oracle问题：The network Adapter could not establish the connetion.

我查了资料，据说是因为Oracle是提供了MTS服务，导致此问题发生。
我看了Oracle中关于MTS的说明，可能必须提供MTS服务才行。是否有什么方法在不停止Oracle MTS 服务的情况下，用JDBC访问Oracle?

...全文

Unity WebGL中文输入法兼容性解决方案：TMP_InputField配置与调试指南在WebGL应用开发中，输入法支持是影响用户体验的关键技术环节。其核心原理在于浏览器原生输入法与Canvas渲染内容之间的桥接机制，通过JavaScript事件监听与WebAssembly模块通信实现数据同步。这项技术的价值在于解决了Web环境下非拉丁语系输入的兼容性问题，对于教育、社交、工具类等需要中文输入的应用场景至关重要。本文聚焦于Unity WebGL平台，针对输入法候选词不上屏、拼音显示异常等常见问题，详细介绍了如何利用TextMeshPro的TMP_InputField组件，通过启用ImeCom 阅读详情

fancuixia

Web 开发 81,108 成员 341,721 内容

+ 关注 + 加入社区

切换为时间正序

fancuixia 2004-04-13

打赏
举报

已经通过OCI连接方式连通数据库。

fancuixia 2004-04-09

打赏
举报

试一下先

fancuixia 2004-04-09

打赏
举报

From: Jon Haugsand <Jon-H.Haugsand@norges-bank.no>
Date: 19 Nov 2001 10:47:25 +0100
Message-ID: <m3u1vrhz2q.fsf_-_@norges-bank.no>
Subject: [suse-oracle] Jdbc thin driver problem solved (was: jdbc thin driver: connection refused

Short summary: If you have problems with connecting your NT client to
your Linux server using jdbc thin client, be sure that the server
machine name as known at the server exists at the client (and is the
same name).

Long story:

* Jon Haugsand
> To all who have tried to help me, thanks. I have now gotten some help
> from Oracle and though they could not find the cause of my problem,
> they found a way to live with it. (They suspect some bad
> configuration.) Here is a summary of the problem and the suggested
> cure, just in case others should struggle with the same problem.
>
> I have two Oracle servers, one Linux and one NT. I have two Oracle
> clients, one Linux and one NT. All in all, four machines
> interconnected through tcp/ip. Each client attempts to connect to
> each server using both standard protocol (?), e.g. using sqlplus and
> the jdbc thin driver, all in all I have 8 connection scenarios.
>
> Oracle on Linux is 8.1.7 (both server and client).
> Oracle on NT is 8.1.6 (both server and client).
> Several jdbc thin drivers are tested, including the latest downloaded
> from Oracle.
>
> Linux server NT server
> ------------------------------------------------------------
> Linux sqlplus OK OK
> Linux jdbc thin OK OK
> NT sqlplus OK OK
> NT jdbc thin fails OK
>
> Driver is oracle.jdbc.driver.OracleDriver
>
> The connection string used: jdbc:oracle:thin:@192.168.22.35:1521:ora8
>
> The NT jdbc thin client failed with:
> java.sql.SQLException: Io exception: The Network Adapter could
> not establish the connection
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
> at
> oracle.jdbc.driver.OracleConnection.<init>
> (OracleConnection.java:361) at
> oracle.jdbc.driver.OracleDriver.getConnectionInstance
> (OracleDriver.java:442)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> at Nytest.main(Nytest.java:54)
> java.lang.RuntimeException: SQL Exception Io exception:
> The Network Adapter could not establish the connection
> at Nytest.main(Nytest.java:70)
>
>
> Failed connection enters the listener which does not complain, but no
> activity is found on the server. (That is, I do not know how to
> measure such things. The trace and log files were almost, but not
> completely, empty and obscure.)
>
> A curious observation is that if I restart the listener at the Linux
> server, the NT jdbc thin client works for a few minutes, and then
> fails again.
>
> --------------------------------
> OK, then the CURE:
>
> The Oracle support suggested I use the following (white space free)
> connection string (structured here for readability):
>
> jdbc:oracle:thin:@(DESCRIPTION=
> (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
> (HOST=192.168.22.35)
> (PORT=1521)))
> (CONNECT_DATA=(INSTANCE_NAME=ora8)
> (SERVICE_NAME=sil2002.norges.bank.no)))
>
> Lo and behold, this works. Thanks again for all helpfullness on this
> email list.

(Just after I sent this information, I discovered something. The
following is a copy of what I sent to the Oracle team.)

I have now discovered what might be the cause of the problem, and
I suggest that you test this out, and eventually report this to the
network development folks in your company.

What have been the situation up to now is that the Linux server has
not been a part of the local DNS i our company. That is, the server
name (banklab3) was not known as such at the NT client. Therefore, I
had to use the IP address. However, the server itself, and the Linux
client, uses the /etc/hosts file to be able to map from number to name
and vica versa.

Today, we inserted the Linux server banklab3 into the local DNS server such
that the NT client now knows that banklab3 has the matching IP address.

Today we have no problems with using the jdbc thin client as we had before.

Can it be so that the Oracle server at the Linux machine does not
"feel comfortable" with numbers and maps the IP address to its name
and returns this to the client, which does not accept this because it
does not know anything about this name?

If so, this is ceratinly not a preferred behaviour of the server, who
should respect the clients view of the world. (I humbly still admit
that there may also be some configuration problems with our Linux
server that makes this really a complex multi cause problem.)

moroser 2004-04-08

打赏
举报

可能是你的监听器没启动
步骤：oracle安装目录-----》BIN----》TNSLSNR 双击启动
试一下

hellion1234 2004-04-08

打赏
举报

最好在hosts文件加上域名解析，例如：

database 192.168.2.2

然后你的url就可以这样：jdbc:oracle:thin:@database:1521:check_db

Arias 2004-04-08

打赏
举报

我也遇到这个问题了我在本机上(win)系统上调连接就出现了
但是把文件放到数据库server上就没有问题了

fancuixia 2004-04-08

打赏
举报

Oracle的SID为check_db。

如果URL为
jdbc:oracle:thin:@192.168.2.2:1521:dddddd

会报错：connection refused(......)。

如果 ID 地址错误，或端口错误，或SID为 check_db，也就是真正的SID，就报错：The network Adapter could not establish the connetion.

也就是我的连接是正常的。

同样的语句，连接Windows 2000上的Oracle没有问题，有问题的是安装在Linux服务器上的Oracle。

望不吝指教。

JDBC连接Oracle问题：The network Adapter could not establish the connetion.

相关推荐