Oracle Xe Error 12514
Contents |
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 ora-12514 error in oracle 12c this site About Us Learn more about Stack Overflow the company Business Learn ora 12514 tns listener could not resolve service_name more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database ora-12514 error in oracle 10g 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 ora-12514 solution 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
Ora-12505 Tns Listener Does Not Currently Know Of Sid
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 = (ADDRESS = (PROTOCOL = TCP)(HOST = Amir-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) =================================================================== java version: java version "1.7.0_55" Java(TM) SE Runtime Environment (build 1.7.0_55-b13) Java HotSpot(TM) Client VM (build 24.55-b03, mixed mode, sharing) =================================================
here for a quick overview of the site Help Center Detailed answers to any questions you
Ora-12514 Tns Listener Does Not
might have Meta Discuss the workings and policies of this site ora 12505 error in oracle sql developer About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or ora-12514 error in oracle 11g posting ads 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 http://dba.stackexchange.com/questions/64848/oracle-xe-11g-ora-12514-tnslistener-does-not-currently-know-of-service-reques 6.2 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 in connect descriptor up vote 34 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 http://stackoverflow.com/questions/5661610/tns-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript 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))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58458)) * establish * XE * 12505 TNS-12505: TNS:listener does not currently know of SID given in connect descriptor 14-APR-2011 13:49:00 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Brodyaga))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58481)) * establish * XE * 12505 TNS-12505: TNS:listener does not currently know of SID given in connect descriptor 14-APR-2011 13:49:02 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Brodyaga))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58487)) * establish *
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 http://stackoverflow.com/questions/10786782/ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-d site About Us Learn more about Stack Overflow the company Business Learn more http://www.codeproject.com/Questions/680942/how-to-resolve-error-ORA-TNS-listener-does-n 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 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-12514 TNS:listener error in does not currently know of service requested in connect descriptor up vote 78 down vote favorite 18 We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try connecting, which failed with the same error as error in oracle above. I used this syntax for SQLPlus: sqlplus username/password@addressname[or host name] We have verified that: the TNS Listener on the server is running. Oracle itself on the server is running. We don't know of any changes that were made to this environment. Anything else we can test? oracle oracle11g sqlplus tnsping share|improve this question edited Apr 6 at 9:18 zb226 4,23111844 asked May 28 '12 at 15:07 Jacques 1,81742566 what is TNSPing command (with params) that you used? –Grzegorz W May 28 '12 at 15:14 when you say "running locally" you mean that the application is connecting to a database on the same host? Also, what are the contents of your sqlnet.ora file? what versions are reported for sqlplus and tnsping, and are you sure that they're in the same ORACLE_HOME? –David Aldridge May 28 '12 at 16:08 try restarting the database. Since they supposed to inform the Listener about their existence on startup this might fix your problem. –Jens Schauder May 28 '12 at 18:03 ALTER SYSTEM REGISTER is less drastic than restarting the database. –DCookie May 29 '12 at 0:42
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question View Unanswered Questions View All Questions... Linux questions C# questions ASP.NET questions SQL questions fabric questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ how to resolve error :ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Rate this: Please Sign up or sign in to vote. See more: ASP.NET Oracle DPB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dps) ) ) I have used above in tnsnames but still gives me the above error. How to resolve this error? IS SERVICE_NAME & SID Similar in tnsnames? Posted 11-Nov-13 0:36am Member 9410081880 Updated 10-Jun-16 6:19am v2 Add a Solution 4 solutions Top Rated Most Recent Rate this: Please Sign up or sign in to vote. Solution 3 Accept Solution Reject Solution In order to solve the problem follow the following steps; >close the sql developer or sql plus window. >Open Run by pressing (WIndowsButton + R ). >type in the text field 'services.msc' and run it. >A new window appears >In that Services window scroll down and find 'OracleOraDb