侦听器当前不知道连接描述符中给定的SID [英] listener does not currently know of SID given in connect descriptor

问题描述

朋友，我遇到了
的错误 侦听器拒绝连接并出现以下错误:
ORA-12505，TNS:侦听器当前不知道连接描述符中给出的SID
客户端使用的连接描述符为:
alpdfdb.alc.aff.com:1521:comwhen
我尝试连接到数据库.实际上我可以在sql developer中连接到数据库，但是当我从Java代码尝试时，它给了我这个错误.
我的代码是

hi friends i am getting this error of
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
alpdfdb.alc.aff.com:1521:comwhen
i try to connect to data base.actually i can connect to database in sql developer but when i try it from java code it give me this error.
my code is

Connection con;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@alpdfdb.alc.aff.com:1521:com","abc","xyz");
System.out.println("con successed");

我正在使用oracle sql developer v 2.1

请帮助我.

I am using oracle sql developer v 2.1

please help me.

推荐答案

^ ]

而且我假设您正在使用Netbeans进行Java开发-
这个很好地描述了该怎么做:

从NetBeans IDE连接到Oracle数据库 [

Learn more about Oracle SQl Developer[^]

And as I assume you are using Netbeans for Java development -
this one desribes pretty well what to do:

Connecting to Oracle Database from NetBeans IDE[^]

您是否尝试使用servicename而不是sid http://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#BEIDHCBA [ ^ ]?根据这一说法( http://www.herongyang.com/JDBC/Oracle-JDBC -Driver-Connection-URL.html [您正在使用不赞成使用的驱动程序，请尝试使用oracle.jdbc.OracleDriver代替oracle.jdbc.driver.OracleDriver.

Have you tried with servicename instead of sid http://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#BEIDHCBA[^]? According to this one (http://www.herongyang.com/JDBC/Oracle-JDBC-Driver-Connection-URL.html[^]) your url is correct, but it looks, like you are using a deprecated driver, try oracle.jdbc.OracleDriver instead of oracle.jdbc.driver.OracleDriver.

感谢朋友，我得到了答案
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@ ffgt.com:1521/fgB.DB.DT.COM"，"ABC"，"xyz");

通过在/没有的端口号和服务名称之间插入/

Thanks friends I got the answer
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@ffgt.com:1521/fgB.DB.DT.COM","ABC","xyz");

BY PUTING / BETWEEN PORT NO & SERVICE NAME INSTED OF :

这篇关于侦听器当前不知道连接描述符中给定的SID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！