Oracle Connection Error - ORA-12514: TNSlistener does nto currently know of service requestedon connect description

Posted on 2014-08-24
Last Modified: 2014-09-03
Hoping someone can explain what this error means and how to resolve.  Have a windows C# application that is trying to connect to a Oracle database.  Can connect fine through SQL Developer.  

Oracle Connection Error - ORA-12514: TNSlistener does nto currently know of service requestedon connect description
Question by:hojohappy
    LVL 76

    Accepted Solution

    Check the tnsnames.ora file under the NETWORK/ADMIN folder where you installed the Oracle data providers for C#.

    SQL Developer doesn't have to use it and likely uses a different ORACLE_HOME if it does.

    If you aren't using ODP.Net, I strongly suggest you start.  The 12c Managed driver seems pretty decent in my initial testing and doesn't require an Oracle Client install.

    In a nutshell the error means the Oracle service/sid you are trying to connect to isn't known by the listener you are talking to.

    If the server/port is correct in your connect string then the database may be down or not registered with the listener.  Since you can connect through SQL Developer, it is likely a config issue in the C# Oracle client.
    LVL 25

    Expert Comment

    Check the listener service if it is running, try pinging the listener or check the listener status using lsnrctl,
    Also check for open ports 1521 by using "netstat" or "nmap" commands
    LVL 73

    Expert Comment

    It's also possible the database is down so it hasn't self-registered to the listener, or the database has the local listener parameter set to a listener other than the one you're connecting to.

    ask your dba to check the server

    This asssumes the database was up previously while using sql developer but has gone down since then while using the .net app

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now