Java.Sql.Sqlexception: Io Exception: The Network Adapter Could Not Establish The Connection

最新推荐文章于 2020-08-20 10:42:51 发布
原创 最新推荐文章于 2020-08-20 10:42:51 发布 · 4.3k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#数据库 #测试 #jdbc #database #oracle rac

博客内容涉及解决Java在尝试连接Oracle RAC时遇到的'Sqlexception: Io Exception'问题，通过ALTER SYSTEM设置本地监听器地址和注册，旨在确保数据库连接的建立。
今天测试的时候发现数据库连接时连接成功时连接失败：
环境有：
Oracle 10.2.5.0 rac 和11.1.0.7,在测试连接的时候抛出："Java.Sql.Sqlexception: Io Exception: The Network Adapter Could Not Establish The Connection" 

查看MOS Doc ID 947653.1
--------------------------------------
 JDBC Thin Driver 11g Causes "Java.Sql.Sqlexception: Io Exception: The Network Adapter Could Not Establish The Connection" While Connecting to Oracle Database 11g (Doc ID 947653.1)To Bottom

In this Document

Symptoms
Cause
Solution
References
APPLIES TO:JDBC - Version 11.1.0.6 and later
Information in this document applies to any platfor
最低0.47元/天 解锁文章
sqoop import 从Oracle往Hadoop导数据报 Io exception: The Network Adapter could not establish the connection
EVISWANG的博客
01-03 4892
一.问题描述       在Hadoop集群的一个节点上用sqoop  import 从Oracle 取数据总报如下错误： 17/12/28 19:16:48 INFO mapreduce.Job: Task Id : attempt_1512535288105_6822_m_000000_0, Status : FAILED Error: java.lang.RuntimeExceptio
工作中自己遇到的一些错误和异常....以备不测
09-02 1053
Io 异常: The Network Adapter could not establish the connection 这个异常的出现一般与数据库和你的PC的设置有关 这种异常的出现大致上有下面几种： 1。IP错误。 在设置URL时错误，例如：jdbc:oracle:thin:@192.168.0.36:1521:sharp 数据库服务器不正确：ping 服务器IP是否正确。不正确，将URL更
关于java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
IntasectYlc的专栏
05-09 798
  在自己装Oracle10g之后运行时候报的错误，耗费了一下午的时间在网上查资料。可惜没有一个办法可以解决问题，虽然经过种种排除我确定错误时出在代码上，而且就在下面这段代码上：  但是依据网上很多资料我看着都是这么写的，最后偶然的尝试发现时IP地址的问题，在url这个字符串中IP是不可以写成127.0.0.1的，只有实实在在的本地IP写上去才可以，但是127.0.0.
异常java.sql.SQLException: Io exception:The Network Adapter could not establish connection
winterld的专栏
10-11 4581
    Oracle Database Connection (from oracle.com)        PROBLEM    You are attempting to connect to an Oracle instance using JDBC and you are receiving the following error.    java.sql.SQLException: I
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection解决方案
热门推荐
群峰之巅的专栏
11-08 2万+
 java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection是我今天刚遇到的问题，有很多原因导致这个，网上也有答案，我的主要毛病是在hibernate.properties文件中没有把hibernate.properties中的行：hibernate.connection.url
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
leizi929的专栏
06-05 1072
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.filterChains': Cannot resolve reference to bean 'org.springframework.security.web.D
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
12-15
import java.sql.*; public class ConnectToMySQL { public static void main(String[] args) { Connection conn = null; try { String url = "jdbc:mysql://localhost/mydatabase"; String user = "root"; ...
java.sql.SQLException: Io �쳣: The Network Adapter could not establish the connection
最新发布
09-27
出现 `java.sql.SQLException: The Network Adapter could not establish the connection` 错误，一般与数据库和PC的设置有关，解决方法如下： 1. **检查IP和端口设置**： - **IP错误**：确保在设置URL时IP地址正确...
25/09/04 22:42:23 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:494) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:327) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:736) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759) at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1833) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:143) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) at org.apache.sqoop.Sqoop.main(Sqoop.java:236) 25/09/04 22:42:23 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No columns to generate for ClassWriter at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1651) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:143) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
09-06
而关于 `java.sql.SQLException: Io exception: The Network Adapter could not establish the connection` 错误，所给引用中未提及相关解决方法。一般来说，此错误通常表示应用程序无法通过网络适配器建立与目标...
(java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection)
MyPointOne的专栏
03-05 1802
异常：(java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection) 问题是连接不到数据库 方法一： 1.拼一下你数据的连接ip（本地的就算了），看看是否通了 2.看看连接库的配置文件名称是否与spring配置文件的连接名称相同 3.查看一下是否已经导入对应的数据库包，如
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection解决方法
weixin_42280351的博客
08-20 6784
一。异常报错 java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.j...
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connec
美好的天空
10-06 1258
  java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection 出现的原因可能   1.你的端口(一般为:1521)和数据的实例名称不对.   2：ip地址链接信息3：查看防火墙4：数据库监听器除了在网上找到的那几种查看方式以外。提醒各位不要和我范同样的错误。我的t...
java.sql.SQLException: The Network Adapter could not establish the connection
husheng8891的专栏
03-30 964
java.sql.SQLException: The Network Adapter could not establish the connection 原因：服务没有开启. 我的电脑--右击管理--服务--找到相应oracle 相应三个服务。即可
java.sql.SQLException: IO 错误: The Network Adapter could not establish the connection
weixin_34326179的博客
04-14 1293
java.sql.SQLException: IO 错误: The Network Adapter could not establish the connectionat oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)at oracle.jdbc.driver.PhysicalConnection...
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection异常
qq_41549632的博客
02-19 310
是因为 你的ipv4 改变了，所以配置的Oracle文件失效了 需要重新配置
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值