{"id":142,"date":"2015-09-01T17:03:29","date_gmt":"2015-09-01T17:03:29","guid":{"rendered":"https:\/\/dbadave.co.uk\/?p=142"},"modified":"2016-02-09T22:31:31","modified_gmt":"2016-02-09T22:31:31","slug":"ora-12154-tns-could-not-resolve-service-name","status":"publish","type":"post","link":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/","title":{"rendered":"ORA-12154: TNS Could Not Resolve Service Name"},"content":{"rendered":"<p>When you, or more accurately an application program, attempts to establish a connection to an Oracle database, it must\u00a0look up the connection data for the database service that you are trying to connect to. Where it looks for this connection data depends on how your client is configured; there are several ways you can configure this:<\/p>\n<ul>\n<li>Local naming through a tnsnames.ora file.<\/li>\n<li>Oracle Names service.<\/li>\n<li>LDAP.<\/li>\n<\/ul>\n<p>The application will pass a connect identifier which the Oracle client will then try and resolve into a connect descriptor (a complete database connection string including the destination Oracle database service and network route information) using one of the above naming methods.<\/p>\n<p>If the connect descriptor lookup fails for some reason, for example if you are using tnsnames.ora and it doesn&#8217;t find a matching service configured in that file, then the Oracle client will raise an &#8220;ORA-12154: TNS Could Not Resolve Service Name&#8221; error.<\/p>\n<p>The most common occurrence of the ORA-12154 error is when an application is attempting to connect to an Oracle database service, but it is not the only way this error can occur. Itcan also happen when one database instance tries to connect to another database service through a database link.<\/p>\n<p>It is important to understand that the ORA-12154 error is raised by the Oracle client code where the application is running and indicates a misconfiguration on the client side. It is not raised on the remote server where the database service you are trying to connect to is running.<\/p>\n<p>If you get an ORA-12154 error it basically means that your application program has found an installed Oracle client, but the Oracle service it is looking up is not listed in the tnsnames.ora file (or is not found in Oracle Names or LDAP, depending on your naming configuration).<\/p>\n<h2><em><strong>Common Causes Of The &#8220;ORA-12154: TNS Could Not Resolve Service&#8221; Error<\/strong><\/em><\/h2>\n<p>Most sites use the tnsnames.ora file for their naming resolution and the most usual causes of the ORA-12154 error are:<\/p>\n<ol>\n<li>The corresponding entry is missing from the tnsnames.ora file.<\/li>\n<li>The corresponding entry in the tnsnames.ora file has a typo in it or has some other error in it.<\/li>\n<li>The application is using the tnsnames.ora file from a different ORACLE_HOME.<\/li>\n<li>The application\u00a0is not using a fully-qualified service name, but no default domain is enabled in sqlnet.ora<\/li>\n<\/ol>\n<h2><em><strong>How To Resolve The ORA-12154 Error<\/strong><\/em><\/h2>\n<p>The first step you should take to resolve the ORA-12154 error is to check which naming method you are using.<\/p>\n<p>The Oracle client decides which method to use based on the data in the sqlnet.ora file. Both this file and the tnsnames.ora file are by default located in ORACLE_HOME\/network\/admin.<\/p>\n<p>However, the location can also be set via the TNS_ADMIN environment variable so you should check to see if you have a TNS_ADMIN set in order to be sure\u00a0which location your configuration files are stored in. If you don&#8217;t have a sqlnet.ora file, or if it does not have a naming resolution method configured in it, then Oracle defaults to using the tnsnames.ora file.<\/p>\n<p>Assuming that you are using a tnsnames.ora file then once you have found the correct configuration file, check that you have an entry in it that matches the database service your application is configured to connect to. If it doesn&#8217;t have one, you should add one, making sure the syntax you use is correct.<\/p>\n<p>If your\u00a0tnsnames.ora file does have an entry in it, then check it for syntax errors and typos. Check for\u00a0any\u00a0unmatched parentheses or stray characters.<\/p>\n<p>Finally, you should also check the security privileges of the tnsnames.ora file to make sure it is accessible.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you, or more accurately an application program, attempts to establish a connection to an Oracle database, it must\u00a0look up the connection data for the database service that you are trying to connect to. Where it looks for this connection data depends on how your client is configured; there are several ways you can configure &#8230; <a title=\"ORA-12154: TNS Could Not Resolve Service Name\" class=\"read-more\" href=\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/\" aria-label=\"Read more about ORA-12154: TNS Could Not Resolve Service Name\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":366,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ORA-12154: TNS Could Not Resolve Service Name<\/title>\n<meta name=\"description\" content=\"The &quot;ORA-12154: TNS Could Not Resolve Service Name&quot; error is a common one. Learn what causes it, and how to diagnose and fix it. READ MORE NOW.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-12154: TNS Could Not Resolve Service Name\" \/>\n<meta property=\"og:description\" content=\"The &quot;ORA-12154: TNS Could Not Resolve Service Name&quot; error is a common one. Learn what causes it, and how to diagnose and fix it. READ MORE NOW.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/\" \/>\n<meta property=\"og:site_name\" content=\"DBA Dave - Oracle Training\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-01T17:03:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-02-09T22:31:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"770\" \/>\n\t<meta property=\"og:image:height\" content=\"340\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40\"},\"headline\":\"ORA-12154: TNS Could Not Resolve Service Name\",\"datePublished\":\"2015-09-01T17:03:29+00:00\",\"dateModified\":\"2016-02-09T22:31:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/\"},\"wordCount\":634,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbadave.co.uk\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg\",\"articleSection\":[\"Oracle Errors\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/\",\"url\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/\",\"name\":\"ORA-12154: TNS Could Not Resolve Service Name\",\"isPartOf\":{\"@id\":\"https:\/\/dbadave.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg\",\"datePublished\":\"2015-09-01T17:03:29+00:00\",\"dateModified\":\"2016-02-09T22:31:31+00:00\",\"description\":\"The \\\"ORA-12154: TNS Could Not Resolve Service Name\\\" error is a common one. Learn what causes it, and how to diagnose and fix it. READ MORE NOW.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#primaryimage\",\"url\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg\",\"contentUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg\",\"width\":770,\"height\":340,\"caption\":\"Oracle Error - ORA-12154: TNS Could Not Resolve Service\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbadave.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-12154: TNS Could Not Resolve Service Name\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbadave.co.uk\/#website\",\"url\":\"https:\/\/dbadave.co.uk\/\",\"name\":\"DBA Dave - Oracle Training\",\"description\":\"Expert DBA Tips &amp; Advice\",\"publisher\":{\"@id\":\"https:\/\/dbadave.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbadave.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbadave.co.uk\/#organization\",\"name\":\"DBA Dave\",\"url\":\"https:\/\/dbadave.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png\",\"contentUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png\",\"width\":170,\"height\":50,\"caption\":\"DBA Dave\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/dbadave.co.uk\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-12154: TNS Could Not Resolve Service Name","description":"The \"ORA-12154: TNS Could Not Resolve Service Name\" error is a common one. Learn what causes it, and how to diagnose and fix it. READ MORE NOW.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/","og_locale":"en_US","og_type":"article","og_title":"ORA-12154: TNS Could Not Resolve Service Name","og_description":"The \"ORA-12154: TNS Could Not Resolve Service Name\" error is a common one. Learn what causes it, and how to diagnose and fix it. READ MORE NOW.","og_url":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/","og_site_name":"DBA Dave - Oracle Training","article_published_time":"2015-09-01T17:03:29+00:00","article_modified_time":"2016-02-09T22:31:31+00:00","og_image":[{"width":770,"height":340,"url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg","type":"image\/jpeg"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#article","isPartOf":{"@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/"},"author":{"name":"admin","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40"},"headline":"ORA-12154: TNS Could Not Resolve Service Name","datePublished":"2015-09-01T17:03:29+00:00","dateModified":"2016-02-09T22:31:31+00:00","mainEntityOfPage":{"@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/"},"wordCount":634,"commentCount":0,"publisher":{"@id":"https:\/\/dbadave.co.uk\/#organization"},"image":{"@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#primaryimage"},"thumbnailUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg","articleSection":["Oracle Errors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/","url":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/","name":"ORA-12154: TNS Could Not Resolve Service Name","isPartOf":{"@id":"https:\/\/dbadave.co.uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#primaryimage"},"image":{"@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#primaryimage"},"thumbnailUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg","datePublished":"2015-09-01T17:03:29+00:00","dateModified":"2016-02-09T22:31:31+00:00","description":"The \"ORA-12154: TNS Could Not Resolve Service Name\" error is a common one. Learn what causes it, and how to diagnose and fix it. READ MORE NOW.","breadcrumb":{"@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#primaryimage","url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg","contentUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/09\/ora-12154-error-1.jpg","width":770,"height":340,"caption":"Oracle Error - ORA-12154: TNS Could Not Resolve Service"},{"@type":"BreadcrumbList","@id":"https:\/\/dbadave.co.uk\/ora-12154-tns-could-not-resolve-service-name\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbadave.co.uk\/"},{"@type":"ListItem","position":2,"name":"ORA-12154: TNS Could Not Resolve Service Name"}]},{"@type":"WebSite","@id":"https:\/\/dbadave.co.uk\/#website","url":"https:\/\/dbadave.co.uk\/","name":"DBA Dave - Oracle Training","description":"Expert DBA Tips &amp; Advice","publisher":{"@id":"https:\/\/dbadave.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbadave.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbadave.co.uk\/#organization","name":"DBA Dave","url":"https:\/\/dbadave.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png","contentUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png","width":170,"height":50,"caption":"DBA Dave"},"image":{"@id":"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/dbadave.co.uk\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/142"}],"collection":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/comments?post=142"}],"version-history":[{"count":15,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/142\/revisions"}],"predecessor-version":[{"id":367,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/142\/revisions\/367"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/media\/366"}],"wp:attachment":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/media?parent=142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/categories?post=142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/tags?post=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}