具体信息如下：java.sql.SQLException:Listener refused the connection with the following error:ORA—12505,TNS：Listener dose not currentlly kown of SID given in connect descriptor the connection description used by client was 127.0.0.1:1521:yx

来源：学生作业帮助网 编辑：作业帮 时间：2024/11/19 03:17:38
具体信息如下：java.sql.SQLException:Listener refused the connection with the following error:ORA—12505,TNS：Listener dose not currentlly kown of SID given in connect descriptor the connection description used by client was 127.0.0.1:1521:yx
xVmOV+WڗDBAb[.dKuĀS2ѴaPː j$q>/N@hUo%{ss| zqjG+Th=XIMn艌EEDMdAE08 Y (Ȳh\ԇ٠"Iʸ(!AU5İbspl*heTUuIDq)RhH+H[8(+hUz׎{(#`5O0 &'j}@Psȉ֜\|M$g5sa|U6~߲֧pQ۰BbW@7WT:Z'@4jVU}«p@˥&ma\# 󍗋8| 3b9'ȒUY/g%8d ?ӗl_LYi<] 4{`͐'PԴ:+mQAqhLM;\%!%# ɜd2z2Ij Ld:;*M>;cieqіB1]; ?#QFHX [Gxٛ _8y*ao$zxM08hQA}4F/CFbY"h.F6 B L3$~a-)4hߗ`X[b~&=)Im|,hMϪ!)hؤDZw<I5d{O|X >h"}C߂eޥw woJ8zBOJT z$]7\ԼU}*ԋr:ngʛ[fg"8hgMu8#LSVO̝|}1*KQW.qoy<%}\{R?*NO۟jg=Viw4ЂuG;=5W5hR@k{ZZC"sZ:..Z6K{xlEt n呴 Ȁ8 ,(.{ Fa]υ;0 Ș6, {&"$e(/W<Y

具体信息如下：java.sql.SQLException:Listener refused the connection with the following error:ORA—12505,TNS：Listener dose not currentlly kown of SID given in connect descriptor the connection description used by client was 127.0.0.1:1521:yx
具体信息如下：
java.sql.SQLException:Listener refused the connection with the following error:ORA—12505,TNS：Listener dose not currentlly kown of SID given in connect descriptor the connection description used by client was 127.0.0.1:1521:yxerp
我是JAVA连接数据库的 请问要导入哪个JAVA包,怎么导?

具体信息如下：java.sql.SQLException:Listener refused the connection with the following error:ORA—12505,TNS：Listener dose not currentlly kown of SID given in connect descriptor the connection description used by client was 127.0.0.1:1521:yx
看这个
SID不正确,跟包没关系

可能不是包的问题 你先用pl/sql链接试试 如果不行的话 吧下面的代码考到相应的文件中:
sqlnet.ora:
# sqlnet.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuratio...

全部展开

可能不是包的问题 你先用pl/sql链接试试 如果不行的话 吧下面的代码考到相应的文件中:
sqlnet.ora:
# sqlnet.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsnames.ora:
# tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora:
# listener.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = F:\oracle\product\10.1.0\db_1)
(SID_NAME = orcl)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
里面的路径自己改下.

收起

这个和包没有关系，检查你需要调用的数据库名是否在制定机器上存在

oracle的驱动jar包，你的sid写错了~看：http://qingfengjushi1.javaeye.com/blog/698519

打不开nc,提示信息是java.sql.SQLException:Listener refused the connection wit我安装的是oracle数据库。具体的提示信息如下：java.sql.SQLException:Listener refused the connection with the following error:ORA—12505，TNS：List 具体信息如下：java.sql.SQLException:Listener refused the connection with the following error:ORA—12505,TNS：Listener dose not currentlly kown of SID given in connect descriptor the connection description used by client was 127.0.0.1:1521:yx java.sql.time java.sql.date 二者如何组合成一个java.util.date java.sql.Date与java.util.Date的区别 Java 如何根据现在的时间毫秒来计算时间的公式(不想用原有的类)java.sql.Timestamp time ;long tt = -1 ;time = new java.sql.Timestamp(new java.util.Date().getTime());tt = time.getTime()来获得信息.我希望可以根据一些 import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*; public class a java.sql.date的时分秒去哪里了? java.sql.date的时分秒去哪里了? java.sql.SQLException: Illegal operation on empty result set.import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;public class shujuku { public static void main(String args[]) { Connection conn; conn = Conn java如何获取当前时间 年月日 时分秒并且转成java.sql.Date格式.谢谢你们 import=java.sql.*和import=java.util.* 有什么区别? java 中import java.sql.Connection 报错：The import java.sql.Connection conflicts with a type defined in the same file create or replace package testpackage as type test_cursor is ref cursor; end testpackage; create or运行时出现如下问题 是怎么回事?java.sql.SQLException: ORA-06550: 第 1 行, 第 20 列: PLS-00103: 出现符号 ;在需要下列之一 java.sql.SQLException:Operation not allowed after ResultSet closed我就用了一次执行语句,为什么会出现这种异常?程序如下：……………… import java.io.IOException;import java.io.OutputStream;import java.net.Socket;import java.net.UnknownHostException;import java.sql.ResultSet;import org.sql.IntoDB;public class BaiduReferer {public static void main(String[] args) throws UnknownHostExc SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=? java.sql.SQLException:SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=?java.sql.SQLException: Can not issue executeUpdate() for SELECTsat com.mysql. java.sql.SQLException:Io 异常:The Network Adapter could not establish the connection 刚刚安装的oracle 10g ,oracle 实例和 监听器都正确启动,但是用DB连接的时候就出现了这个错误.我的java 源代码如下package demo1;imp 请问sql=select * from 招聘信息 order by id