具体信息如下：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/05/13 11:40:53

具体信息如下：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包,怎么导?

全部展开

可能不是包的问题你先用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