Oracle Xe Listener Refused The Connection With The Following Error
Contents |
here for a quick overview of the site Help Center Detailed answers to listener refused the connection with the following error ora-12505 tns listener does not any questions you might have Meta Discuss the workings and listener refused the connection with the following error ora-12505 in oracle sql developer policies of this site About Us Learn more about Stack Overflow the company Business Learn more ora 12505 error in sql developer about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community
Listener Refused The Connection With The Following Error Ora-12514
Stack Overflow is a community of 6.2 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 vote 81 down vote favorite 22 I have installed Oracle 11g Express Edition Release ora 12505 error in oracle 11g 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.
This Site Careers Other all forums Forum: JDBC and Relational Databases Listener 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 java sql sqlexception listener refused the connection with the following error ora 12505 - Test Failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does
Listener Refused The Connection With The Following Error Ora-12519
not currently know of SID given in connect descriptor" when instead of xe as sid, i write SIVA it works successfully.
Ora 12505 Error In Oracle 12c
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, http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript Sumeet SCJP 1.4, SCWCD 5, LinkedIn Profile Sumit Patil Ranch Hand Posts: 296 I like... 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 https://coderanch.com/t/585051/JDBC/databases/Listener-refused-connection-error-ORA 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)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) LISTENER_SIVA = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) SIVU = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sivu) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) SIVA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = siva) ) ) now please t
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of http://dba.stackexchange.com/questions/24857/listener-refused-the-connection-with-following-error-ora-12505-tns-listener-d this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ https://confluence.atlassian.com/stashkb/ora-12514-tns-listener-does-not-currently-know-of-service-requested-in-connect-descriptor-307038528.html Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes listener refused a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor up vote 2 down vote favorite I am a newbie to oracle database. I am trying to listener refused the make a connection but I receive the following error: Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor. I have done my research online and after executing the lsnrctl status and lsnrctl service I get the following. Does anyone what I need to do? All kind of help is highly appreciated. Thanks. C:\Users\myComputer>lsnrctl start LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-SEP-2012 23:33 :29 Copyright (c) 1991, 2010, Oracle. All rights reserved. TNS-01106: Listener using listener name LISTENER has already been started C:\Users\myComputer>lsnrctl service LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-SEP-2012 23:33 :46 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Service "oracle.220.8.191" has 1 instance(s). Instance "oracle", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:166 refused:0 state:ready LOCAL SERVER Service "oracleXDB.220.8.191" has 1 instance(s). Instance "oracle", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:0 refused:0 current:0 max:1022 state:ready DISPATCHER anOracleDB: 2012-10-17 15:59:55,818 WARN [http-7990-17] stash 959x29x1 1m1q59y 10.11.44.156 "POST /admin/db/edit HTTP/1.1" c.a.s.i.m.DefaultMigrationService A connection could not be opened with the DataSource java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor ... Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor Cause Stash does not support connecting toOracle servers using a TNS Aliasor SID for identification - BSERV-4148 - Support connecting to Oracle with SID or TNS name Open . Resolution As currently Stash supportsconnecting to an Oracle DBonly using a Service Name (refer to the "Database Name" parameter on the table you'll see on this link) you'll need toconfigure a Service Name for your database and specify that as a connection parameter on the "Database Name" field. For more information what Service Name is, please refer to Defining Database Services. Was this helpful? Yes No Thanks for your feedback! Why was this unhelpful? It wasn't accurate It wasn't clear It wasn't relevant Submit feedback Cancel Have a question about this article? See questions about this article Powered by Confluence and Scroll Viewport Atlassian Support Ask the community Provide product feedback Contact technical support Atlassian Privacy Policy Terms of use Security Copyright © 2016 Atlassian Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.