在线等待!!连接数据库 Connection refused。 将Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 改为Class.forName("oracle.jdbc.driver.OracleDriver"); 试试。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我数据库是 ORAL 但是在我自己上用Net8 Assistant配制服务名时 名字是ORAL_192.168.2.22。我用 SQLPlus Worksheet 连时Connect LMY/LMY@ORCL 不行 ORA-12154: TNS: 无法处理服务名然后我换成Connect LMY/LMY@ORCL_192.168.2.22 就可以了。从程序的反应看,那我的jdbc配制对了吗。Class.forName("oracle.jdbc.driver.OracleDriver"); 不行 Connect lmy/lmy@ORCL 不行 ORA-12154: TNS: 无法处理服务名然后我换成Connect lmy/lmy@ORCL_192.168.2.22 就可以了。 DriverManager.getConnection中的地址 端口和用户名 密码是对的 我现在有两台服务器 192.168.2.22 (windows 2000 server)192.168.2.25 (RedHat9.0)现在 Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.22:1521:ORCL","lmy","lmy"); 没有报错但是Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.25:1521:o817db","LMY","LMY");报aq.executeQuery:Io 异常: The Network Adapter could not establish the connection两个用 SQLPlus Worksheet 我都可以登录。 ("jdbc:oracle:thin:@192.168.2.22:1521:ORCL","lmy","lmy"); 中ORCL是SID,没错,这里应该是用SID在SQLPlus里连接是用你建立连接时的连接名,不一定是ORCL在JDBC的url连接字符串应该 是("jdbc:oracle:thin:@192.168.2.22:1521:ORCL","lmy","lmy"); SQLPlus里连接是用你建立连接时的连接名,不一定是ORCL --现在知道了。谢谢。那我那个192.168.2.25 又是怎么回事呢 好了ISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 2481)) )改为ISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.25)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 2481)) )我不知道为什么 test=> 192.168.2.25就好了。但是我那个RedHat9.0的服务器是叫test. 看了乱七八糟,我问你,你的服务名是什么,实例名是什么,两台是不是都有ORACLE,版本是不是一样~~ 服务器一 server 192.168.2.22 (windows 2000 server) oracle 8.0.5 实例名 ORCL 服务器二 test 192.168.2.25 (RedHat9.0) oracle 8.1.5 实例名 o817db我的机子 192.168.2.29 (windows 2000 server) oracle 8.1.5 服务名 1、 orcl_192.168.2.22 2、 o817db 测试 ("jdbc:oracle:thin:@192.168.2.22:1521:orcl_192.168.2.22","lmy","lmy"); 不行 ("jdbc:oracle:thin:@192.168.2.25:1521:0817db","LMY","LMY"); 不行报 aq.executeQuery:Io 异常: The Network Adapter could not establish the connection1 我把 ("jdbc:oracle:thin:@192.168.2.22:1521:orcl_192.168.2.22","lmy","lmy"); 改为 ("jdbc:oracle:thin:@192.168.2.22:1521:OCRL","lmy","lmy"); 可以了2 现在我把192.168.2.25机上的ISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521)) ) )ISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521)) ) )HOST = test改为HOST = localhost 可以连几次后又不行了HOST = test改为HOST = 127.0.0.1 不行HOST = test改为HOST = 192.168.2.25 行 现在可以,但不知道连几次后会不行。 那是当然咯,你们两个数据库的版本不同,不同的版本NET8配置不同,一般都是用ORC1来表示的~ test=> 192.168.2.25 这个是怎么回事呢? 我也遇到这个问题,本机的oracle可以访问,远程的通过odbc可以,但是直接象楼主那样却不行,也不知道怎么解决。 log4j的使用 谁有jdk-6u4-windows-i586-p ,给我具体的下载地址或者传给我 请教前辈,用户权限如何设计? 读取excel时出现异常 为什么得不到正确的结果 求助iReport问题 如何用Java写一个文档抽取工具?(大送分) 关于 CharBuffer的position() 和 Formatter的问题 jdk1.4以上 JDK1.5没有System.dirSep了吗? 怎么把java的源程序转化为.exe文件啊?? ◆菜鸟提问了!关于Servlet的一个很简单的问题。◆ 一题不明!
然后我换成
Connect LMY/LMY@ORCL_192.168.2.22 就可以了。从程序的反应看,那我的jdbc配制对了吗。
Class.forName("oracle.jdbc.driver.OracleDriver"); 不行
然后我换成
Connect lmy/lmy@ORCL_192.168.2.22 就可以了。
现在
Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.22:1521:ORCL","lmy","lmy"); 没有报错
但是Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.25:1521:o817db","LMY","LMY");报
aq.executeQuery:Io 异常: The Network Adapter could not establish the connection两个用 SQLPlus Worksheet 我都可以登录。
中ORCL是SID,没错,这里应该是用SID在SQLPlus里连接是用你建立连接时的连接名,不一定是ORCL在JDBC的url连接字符串应该 是
("jdbc:oracle:thin:@192.168.2.22:1521:ORCL","lmy","lmy");
那我那个192.168.2.25 又是怎么回事呢
ISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
) ) (DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 2481))
)
改为
ISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.25)(PORT = 1521))
) ) (DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 2481))
)我不知道为什么 test=> 192.168.2.25
就好了。但是我那个RedHat9.0的服务器是叫test.
192.168.2.22 (windows 2000 server) oracle 8.0.5
实例名 ORCL 服务器二 test
192.168.2.25 (RedHat9.0) oracle 8.1.5
实例名 o817db我的机子
192.168.2.29 (windows 2000 server) oracle 8.1.5
服务名
1、 orcl_192.168.2.22
2、 o817db 测试
("jdbc:oracle:thin:@192.168.2.22:1521:orcl_192.168.2.22","lmy","lmy"); 不行
("jdbc:oracle:thin:@192.168.2.25:1521:0817db","LMY","LMY"); 不行报
aq.executeQuery:Io 异常: The Network Adapter could not establish the connection1 我把 ("jdbc:oracle:thin:@192.168.2.22:1521:orcl_192.168.2.22","lmy","lmy"); 改为
("jdbc:oracle:thin:@192.168.2.22:1521:OCRL","lmy","lmy"); 可以了
2 现在我把192.168.2.25机上的
ISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
) )
ISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
) )
HOST = test改为HOST = localhost 可以连几次后又不行了
HOST = test改为HOST = 127.0.0.1 不行
HOST = test改为HOST = 192.168.2.25 行 现在可以,但不知道连几次后会不行。