Jdbc Error Code 12505
Contents |
here for a quick ora 12505 error in sql developer overview of the site Help Center Detailed answers
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
to any questions you might have Meta Discuss the workings and policies of
Ora-12505 Tns Listener Does Not Currently Know Of Sid
this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads
Ora 12505 Error In Oracle 11g
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign listener refused the connection with the following error ora-12514 up ORA-12505, TNS:listener does not currently know of SID given in connect descriptor up vote 81 down vote favorite 22 I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then I got the following error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.
here for a quick overview of the java.sql.sqlexception: listener refused the connection with the following error: site Help Center Detailed answers to any questions you ora 12505 error in oracle 12c might have Meta Discuss the workings and policies of this site About Us listener refused the connection with the following error ora-12519 Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up TNS-12505: TNS:listener does not currently know of SID given http://stackoverflow.com/questions/5661610/tns-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript in connect descriptor up vote 33 down vote favorite 11 I'm trying to connect to Oracle 10.2.0 from NetBeans, using the following connection string: jdbc:oracle:thin:@localhost:1521:XE The weirdest part is that everything worked fine, until the one of the reboots. I started getting this TNS-12505 errors all the time; look at the final entries in my listener.log: TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-APR-2011 13:46:48 Copyright (c) 1991, 2005, Oracle. All rights reserved. System parameter file is D:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora Log messages written to D:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log Trace information written to D:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc Trace level is currently 0 Started with pid=3460 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Brodyaga-PC)(PORT=1521))) Listener completed notification to CRS on start TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 14-APR-2011 13:48:54 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Brodyaga))) * (ADD
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. https://community.oracle.com/thread/2600172 Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 13 Replies Latest reply on Nov 5, 2013 listener refused 9:39 PM by sandeep.c ORA-12505, TNS:listener does not currently know of SID given in connect descriptor sandeep.c Nov 5, 2013 3:31 PM Hello Everybody,.I would like to know,what am I missing here...I have the following Java code/** * Connect to Oracle Database. */ private static void oracleConnect() { Connection conn listener refused the = null; try { //Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:orcl", "scott", "Scott123"); System.out.println("Connected to the Oracle database..."); } /*catch (ClassNotFoundException e) { e.printStackTrace(); } */catch (SQLException e) { e.printStackTrace(); } finally { try { conn.close(); System.out.println("Connection closed..."); } catch (SQLException e) { e.printStackTrace(); } } }Exception: java.sql.SQLException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.