{"id":385,"date":"2018-06-21T16:25:57","date_gmt":"2018-06-21T16:25:57","guid":{"rendered":"http:\/\/dbtut.com\/?p=385"},"modified":"2020-07-21T12:02:53","modified_gmt":"2020-07-21T12:02:53","slug":"how-to-find-oracle-service-name-service_name-parameter-on-tns","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/","title":{"rendered":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)"},"content":{"rendered":"<p><span style=\"font-size: inherit;\">We can find oracle service name with two method. TNS information is required to connect to Oracle.<\/span><\/p>\n<p>In the service_name parameter in the TNS information, we need to specify the service name of ORACLE.<\/p>\n<p lang=\"en-US\">You can learn Oracle service_name with the following two methods.<\/p>\n<h3>Method 1:<\/h3>\n<h3>Find Oracle Database Service Name From sqlplus<\/h3>\n<p lang=\"en-US\">After connecting to the oracle database with Toad or SQLplus, you can learn by running the following query.<\/p>\n<pre class=\"lang:default decode:true\">select value from v$parameter where name like '%service_name%';<\/pre>\n<h3>Method 2:<\/h3>\n<h3>Find Oracle Database Service Name From TOAD<\/h3>\n<p lang=\"en-US\">After connecting to Toad, we access Oracle Parameters with the tabs you see below.<\/p>\n<p lang=\"en-US\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/912.png\" width=\"710\" height=\"289\" \/><\/p>\n<p>Then, as you see below, we write service in the filter section. You can see the oracle service_name information in Value.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/220.png\" width=\"701\" height=\"246\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_385\" class=\"pvc_stats all  \" data-element-id=\"385\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We can find oracle service name with two method. TNS information is required to connect to Oracle. In the service_name parameter in the TNS information, we need to specify the service name of ORACLE. You can learn Oracle service_name with the following two methods. Method 1: Find Oracle Database Service Name From sqlplus After connecting &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_385\" class=\"pvc_stats all  \" data-element-id=\"385\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":16073,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[9812,9814,7569,9815,7570,9813,9807,9806,9804,9809,9805,9808,424,423,421,9810,9811,422,425],"class_list":["post-385","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-check-oracle-service-name","tag-find-oracle-database-service_name","tag-find-oracle-service-name","tag-find-oracle-service-name-command-line","tag-find-oracle-service-name-from-sqlplus","tag-find-oracle-service_name","tag-how-to-check-oracle-service-name","tag-how-to-find-oracle-database-service-name","tag-how-to-find-oracle-service-name","tag-how-to-find-oracle-tns-service-name","tag-how-to-find-out-oracle-database-service-name","tag-how-to-know-the-oracle-service-name","tag-oracle-parameters","tag-oracle-service_name","tag-service_name","tag-service_name-parameter-on-tns","tag-service_name-parameter-tnsnames-ora","tag-service_names","tag-vparameter"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":8815,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-21T16:25:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-21T12:02:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"507\" \/>\n\t<meta property=\"og:image:height\" content=\"307\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)\",\"datePublished\":\"2018-06-21T16:25:57+00:00\",\"dateModified\":\"2020-07-21T12:02:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/\"},\"wordCount\":131,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg\",\"keywords\":[\"check oracle service name\",\"find oracle database service_name\",\"Find Oracle Service Name\",\"find oracle service name command line\",\"Find Oracle Service Name from sqlplus\",\"find oracle service_name\",\"how to check oracle service name\",\"how to find oracle database service name\",\"How To Find Oracle Service Name\",\"how to find oracle tns service name\",\"how to find out oracle database service name\",\"how to know the oracle service name\",\"Oracle Parameters\",\"oracle service_name\",\"service_name\",\"SERVICE_NAME parameter on TNS\",\"service_name parameter tnsnames.ora\",\"service_names\",\"v$parameter\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/\",\"name\":\"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg\",\"datePublished\":\"2018-06-21T16:25:57+00:00\",\"dateModified\":\"2020-07-21T12:02:53+00:00\",\"description\":\"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg\",\"width\":507,\"height\":307},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS) - Database Tutorials","description":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)","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:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/","og_locale":"en_US","og_type":"article","og_title":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS) - Database Tutorials","og_description":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-21T16:25:57+00:00","article_modified_time":"2020-07-21T12:02:53+00:00","og_image":[{"width":507,"height":307,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg","type":"image\/jpeg"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)","datePublished":"2018-06-21T16:25:57+00:00","dateModified":"2020-07-21T12:02:53+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/"},"wordCount":131,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg","keywords":["check oracle service name","find oracle database service_name","Find Oracle Service Name","find oracle service name command line","Find Oracle Service Name from sqlplus","find oracle service_name","how to check oracle service name","how to find oracle database service name","How To Find Oracle Service Name","how to find oracle tns service name","how to find out oracle database service name","how to know the oracle service name","Oracle Parameters","oracle service_name","service_name","SERVICE_NAME parameter on TNS","service_name parameter tnsnames.ora","service_names","v$parameter"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/","name":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg","datePublished":"2018-06-21T16:25:57+00:00","dateModified":"2020-07-21T12:02:53+00:00","description":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-2.jpg","width":507,"height":307},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/21\/how-to-find-oracle-service-name-service_name-parameter-on-tns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=385"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/385\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/16073"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}