Jdbc Error 12505
Contents |
here for a quick overview of the site
Ora 12505 Error In Sql Developer
Help Center Detailed answers to any questions you might ora 12505 solution have Meta Discuss the workings and policies of this site About Us Learn more ora-12505 tns listener does not currently know of sid about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users
Ora 12505 Error In Oracle 11g
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 ORA-12505, TNS:listener does not currently know of SID given in connect descriptor up
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
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 site Help Center Detailed answers to any questions you might have Meta Discuss listener refused the connection with the following error ora-12514 the workings and policies of this site About Us Learn more about
Ora 12505 Error In Oracle 12c
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow ora-12505 jdbc thin client 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 http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript other. Join them; it only takes a minute: Sign up ORA-12505, TNS:listener does not currently know of SID given in connect descriptor. Eclipse and Fedora 20 via JDBC up vote 1 down vote favorite I've installed Oracle 11g XE on a Fedora 20 Virtual Machine, configured it and set the enviroment variables (running the oracle_env.sh). I've got this http://stackoverflow.com/questions/22768870/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript error when trying to connect Eclipse with the database via jdbc, using this string "jdbc.databaseurl=jdbc:oracle:thin:@192.168.88.134:1521:XE" I can connect to the database in the Virtual Machine via SQL*Plus (sqlplus / as sysdba). The $ORACLE_SID variable is ok (XE). I've already tried to stop and start the listener, then startup the database, and use the alter system register; command. Also statically registering the database without success (I cannot asure I did not mistake doing this, so if somebody thinks this could solve my problem I would try again). Here is the listener.ora file: # listener.ora Network Configuration File: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.134)(PORT = 1521)) ) ) DEFAULT_SERVICE_LISTENER = (XE) And the tnsnames.ora file: # tnsnames.ora Network Configuration File: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.134)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CO
Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums Forum: JDBC and Relational Databases Listener https://coderanch.com/t/585051/JDBC/databases/Listener-refused-connection-error-ORA refused the connection with the following error: ORA-12505 lalit khera Ranch Hand Posts: 39 posted 4 years ago hi i am getting the error as-"Status: Failure - https://thejavablog.wordpress.com/2010/12/09/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descriptor/ Test Failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" when instead of xe as sid, ora 12505 i write SIVA it works successfully. please reply. its urgent listener-error.PNG listener error lsnrctl.PNG attach Sumit Patil Ranch Hand Posts: 296 I like... posted 4 years ago lalit khera wrote: please reply. its urgent Please EaseUp Thanks & Regards, Sumeet SCJP 1.4, SCWCD 5, LinkedIn Profile Sumit Patil Ranch Hand Posts: 296 I like... ora 12505 error posted 4 years ago Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe" Thanks & Regards, Sumeet SCJP 1.4, SCWCD 5, LinkedIn Profile lalit khera Ranch Hand Posts: 39 posted 4 years ago Sumit Patil wrote:Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe" hi i am new bee in oracle. please tell me where to find that file and if find what next thing i need to do. lalit khera Ranch Hand Posts: 39 posted 4 years ago Sumit Patil wrote:Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe" hey thanks sumit i found the file tnsnames.ora and the content of that file is as follows # tnsnames.ora Network Configuration File: G:\app\windows7\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_SIVU = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KE
of SID given in connectdescriptor 9 December 2010 Panos Leave a comment Go to comments I am not sure why I get this error since I can connect to the current SID by using sqlplus but I cannot connect to it by using jdbc with the following url: jdbc:oracle:thin:@aHost:1521:theSID After searching for about an hour I found out that you can also use the full blown jdbc url protocol to connect to oracle jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aHost) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=theSID))) This does not explain why the issue happens but at least for now it solves the problem. I will post an update if I find anything else. Like this:Like Loading... Related Categories: JDBC, Oracle Comments (24) Trackbacks (1) Leave a comment Trackback Vishal 20 October 2011 at 5:00 am Reply Thanx. It is really helpful. test 1 November 2011 at 7:44 pm Reply Iam trying to connect iReropt to Oracle db using Database JDBC Connection wizard. I tried the same way as you mentioned and it works the same way it worked for you. i.e. when i mention the full blown jdbc url, it is connecting successfully, but not for jdbc:oracle:thin:@myHost:1521:mySID. Dont know why ?? Panos 1 November 2011 at 8:09 pm Reply Not sure why it's doing it. Maybe the application server does not like something in the URL. Not sure. tomim 24 November 2011 at 11:28 am Reply Hi, As I understand, you are using service name instead of SID. URL for conenctions based on service names should be in this format… jdbc:oracle:thin:@//aHost:1521/theSID Liju John 21 December 2011 at 11:05 pm Reply This was really helpful for me !! Thanks tester 24 December 2011 at 4:35 am Reply thabkyou .It works🙂 Uzay Ordu 7 February 2012 at 12:21 pm Reply Panos and tomim! Thank you very much Labrini 19 February 2012 at 3:45 am Reply Dear Panos, Thank you for the information. I have the same message in my PC while I try to connect