Java.sql.sqlexception Listener Refused The Connection With The Following Error Ora-12514
Contents |
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 this site About Us Learn more about Stack Overflow the company Business java.sql.sqlexception listener refused the connection with the following error ora-12505 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation ora-12514 oracle 11g Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just
Listener Refused The Connection With The Following Error Ora-12519
like you, helping each other. Join them; it only takes a minute: Sign up Listener refused the connection with the following error: ORA-12514 up vote 3 down vote favorite I am trying to connect to an Oracle Database
Ora-12514, Tns:listener Does Not Currently Know Of Service Requested In Connect Descriptor
using java and JDBC code. I can't do that because I get the error below: 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 What is the reason for the error and how to fix it ? PS- Out of all the DBMS, Oracle express 11g seems to be the most complicated and difficult to use. Is that really the case ? java oracle.net.ns.netexception: listener refused the connection jdbc oracle11g share|improve this question edited Aug 6 '12 at 23:27 Alfabravo 5,40632762 asked Aug 6 '12 at 23:26 sweet dreams 68692039 do you have same error when you try tnsping from console or commandprompt? –HRgiger Aug 6 '12 at 23:30 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote accepted Listener does not currently know of service requested in connect descriptor Self explainatory. You're requesting connection to a service or instance in a DB that the DB's listener does not know, so it says "I have no clue". Check the way you installed your Oracle 11g express. Remember that the service name there is often "xe". share|improve this answer answered Aug 6 '12 at 23:31 Alfabravo 5,40632762 Yes. I changed the URL to "jdbc:oracle:thin:@//localhost:1521/xe" instead of jdbc:oracle:thin:@//localhost:1521/orcl and something happened and then I got a new exception in my code. Will put it in a separate post. –sweet dreams Aug 6 '12 at 23:37 Another issue is that when I create a new connection (say MyXe) and use the same in my URL, then my code generates errors. –sweet dreams Aug 7 '12 at 1:13 Sorry but I don't understand our issue. Please edit your question if it relates to the same error or open a new one. And
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
The Listener Supports No Services
could not be opened with the DataSource java.sql.SQLException: Listener ora-12519, tns:no appropriate service handler found refused the connection with the following error: ORA-12514, TNS:listener does not currently know of ora-12516, tns:listener could not find available handler with matching protocol stack 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 http://stackoverflow.com/questions/11837345/listener-refused-the-connection-with-the-following-error-ora-12514 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 https://confluence.atlassian.com/stashkb/ora-12514-tns-listener-does-not-currently-know-of-service-requested-in-connect-descriptor-307038528.html 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.
and to help other users in the Splunk community with their own questions. This quick tutorial will help you get started https://answers.splunk.com/answers/177957/db-connect-how-to-fix-oracle-sid-setup-error-ora-1.html with key features to help you find the answers you need. http://dba.stackexchange.com/questions/64848/oracle-xe-11g-ora-12514-tnslistener-does-not-currently-know-of-service-reques You will receive 10 karma points upon successful completion! Get Started Skip Tutorial Splunk.com Documentation Splunkbase Answers Wiki Blogs Developers Sign Up Sign in FAQ Refine your search: Questions Apps Users Tags Search Home Answers ask a question Badges Tags Users Welcome to Splunk Answers! Not listener refused what you were looking for? Refine your search. Search DB Connect: How to fix Oracle SID setup error "ORA-12514, TNS: listener does not currently know of service requested in connect descriptor"? 1 I am getting the following problems while adding a new Oracle connection with SID: Encountered the following error while trying to save: In handler 'databases': Error listener refused the connecting to database: 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 However, I don't have any problems if an Oracle database with service_name defined. I followed this post:http://answers.splunk.com/answers/73979/dbx-problems-after-upgrading-to-1-0-8.html and I added a stanza at the beginning of database.conf as the following: [default]database.sid = true After restart, I still get the same problem. Does anyone have any clues how to fix this? Thanks,Joe error oracle Question by splunkrocks2014 Oct 29, 2014 at 08:43 AM 49 ● 2 ● 4 ● 6 Most Recent Activity: Answered by pmdba 1.2k ● 6 ● 6 ● 8 People who like this Close 1 Add comment Comment 10 |10000 characters needed characters left 1 Answer · Add your answer oldest newest most voted 0 Either the database is not configured to register its SID with the listener, or you are not using the actual SID in your connect string. Do you have access to the database server itself, or the assistance of an Ora
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 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 _ 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 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 Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ) up vote 2 down vote favorite I have already seen the questioned in the stack overflow that might relate to my problem but let me emphasize that none of them could resolve my issue. issue is: when I wanted to integrate OWASP WebGoat application with oracle XE 11g , I receive the above mentioned error. connection URL in web.xml is: jdbc:oracle:thin:@//localhost:1521/XE/${USER} ================================================================= listener.ora: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = Amir-PC)(PORT = 1521)) ) ) DEFAULT_SERVICE_LISTENER = (XE) ============================================================= tnsnames.ora: XE = (DESCRIPTION =