12514 Error In Oracle
Contents |
incorrectly. Action: Turn on tracing at the ADMIN level and reexecute the operation. Verify that the ORACLE Server executable is present and has execute permissions enabled. Ensure that the ORACLE environment is specified correctly in oracle error 12514 encountered LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be installed on the 12154 oracle error local hard drive. Please check that the correct Protocol Adapter are successfully linked. If error persists, contact Oracle Customer Support. ORA-12502:
Oracle Error 12564
TNS:listener received no CONNECT_DATA from client Cause: No CONNECT_DATA was passed to the listener. Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor. ORA-12504: TNS:listener was not given
Oracle Error 12560
the SID in CONNECT_DATA Cause: The SID was missing from the CONNECT_DATA. Action: Check that the connect descriptor corresponding to the service name in TNSNAMES.ORA has an SID component in the CONNECT_DATA. ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID for an instance oracle error 12541 (usually a database instance) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener. Action: - Wait a moment and try to connect a second time. - Check which instances are currently known by the listener by executing: lsnrctl services
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
Oracle Ora 12514
View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions oracle 10g ora 12514 SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / oracle ora 12505 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 & https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12500.htm 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 http://www.codeproject.com/Questions/680942/how-to-resolve-error-ORA-TNS-listener-does-n & 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 pl
of service In previous articles I have explored various reasons why a client process might not be able to connect to an Oracle database. In Help! http://edstevensdba.com/oracle-tns/ora-12514-tnslistener-does-not-currently-know-of-service/ I can’t connect to my database … I presented an overview https://confluence.atlassian.com/stashkb/ora-12514-tns-listener-does-not-currently-know-of-service-requested-in-connect-descriptor-307038528.html of the process. I followed that with articles going into more depth on the types of problems that can prevent the request from reaching the host server. Now I would like to look at problems that can arise once the request actually arrives at the listener, in oracle error particular “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor”. For this demonstration I will generate the error then go through the standard analysis and solution. After that, I will explore some of the interesting factors that flow from this. The Error - ORA-12514 Before we get into specifics of debugging ORA-12514, let's create a test 12514 error in case and mention some general principles. C:\>sqlplus scott/tiger@tulsa SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 18 15:28:47 2016 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Enter user-name: Fig. 1 Of course the very first thing anyone should do when confronted with an Oracle error is to check the official description. There are many sources on the web, but I like to start with ‘oerr’ utility on the server .. [oracle@vmlnx01 admin]$ oerr ora 12514 12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor" // *Cause: The listener received a request to establish a connection to a // database or other service. The connect descriptor received by the listener // specified a service name for a service (usually a database service) // that either has not yet dynamically registered with the listener or has // not been statically configured for the listener. This may be a temporary // condition such as after the listener has started, but before
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.