{"id":14413,"date":"2020-07-15T13:38:06","date_gmt":"2020-07-15T11:38:06","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/"},"modified":"2020-07-15T13:38:06","modified_gmt":"2020-07-15T11:38:06","slug":"create-and-configure-an-oracle-linked-server-in-sql-server-instance","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/","title":{"rendered":"Create and configure an Oracle linked server in SQL Server Instance"},"content":{"rendered":"<h3>What is Linked server ?<\/h3>\n<p>Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit hard. For exemple moving some data from an Oracle database to a SQL Server database is not easy.<\/p>\n<p>A linked servers is configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle.<\/p>\n<p>&nbsp;<\/p>\n<p>In this Blog, we will see step by step guide to create and configure an Oracle linked server in SQL Server Instance.<\/p>\n<ul>\n<li>Download &#8216;oracle database client&#8217;\n<pre class=\"brush: html; gutter: true; first-line: 1\">https:\/\/edelivery.oracle.com\/osdc\/faces\/SoftwareDelivery<\/pre>\n<\/li>\n<\/ul>\n<ul>\n<li>Install &#8216;Oracle database client&#8217;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41712 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_1.png\" alt=\"Install oracle database client\" width=\"790\" height=\"602\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41716 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_2.png\" alt=\"install oracle database client\" width=\"790\" height=\"602\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41721 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_33.png\" alt=\"install oracle database\" width=\"790\" height=\"598\" \/><\/a><\/p>\n<ul>\n<li>Create a tnsnames.ora file in (C:\\app\\client\\Administrator\\product\\12.2\\client_1\\network\\admin)<\/li>\n<\/ul>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">WSDBA01 =\n  (DESCRIPTION =\n    (ADDRESS_LIST =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.106)(PORT = 1521))\n    )\n    (CONNECT_DATA =\n      (SERVICE_NAME = WSDBA01)\n    )\n  )<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Run powershell as administrator and then do a tnsping<br \/>\nCheck your firewall on each server and between them. <strong>In this exemple we do not have any firewall<\/strong>.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/tnsping-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41750 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/tnsping-1.png\" alt=\"\" width=\"947\" height=\"173\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Check your provider by creating a &#8216;test_connection.udl&#8217; file in your Desktop<br \/>\nThen double click on it (open it)<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/test_connection_udl.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-41752 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/test_connection_udl.png\" alt=\"\" width=\"113\" height=\"133\" \/><\/a><\/p>\n<ul>\n<li>Choose &#8216;Oracle Provider for OLE DB&#8217; and then click Next<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/test_connection.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41762 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/test_connection.png\" alt=\"test oracle OLE DB provider\" width=\"362\" height=\"470\" \/><\/a><\/p>\n<ul>\n<li>Enter your service name (defind in tnsnames.ora file) for &#8216;Data Source&#8217;<br \/>\nEnter a valide username and password and then click on &#8216;Test Connection&#8217;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/test_connection_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41763 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/test_connection_1.png\" alt=\"\" width=\"362\" height=\"470\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/test_connection_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41764 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/test_connection_2.png\" alt=\"\" width=\"362\" height=\"470\" \/><\/a><\/p>\n<ul>\n<li>Open your SSMS (SQL Server Management Studio) and connect to your SQL Server instance<br \/>\nUnder &#8216;Server Objects&#8217; then &#8216;Linked Servers&#8217; and then &#8216;Providers&#8217; you must see the &#8216;OraOLEDB.Oracle&#8217;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/OraOLEDBProvider.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41766 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/OraOLEDBProvider.png\" alt=\"\" width=\"252\" height=\"330\" \/><\/a><\/p>\n<ul>\n<li>Right Click on it and then &#8216;Properties&#8217;<br \/>\nCheck mark the &#8216;Allow inprocess&#8217; and then Click on &#8216;OK&#8217;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Propertiess.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41767 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Propertiess.png\" alt=\"\" width=\"698\" height=\"294\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Right click on &#8216;Linked server&#8217; and then choose &#8216;New linked server&#8217;<\/li>\n<li>In General section :<br \/>\n&#8216;Linked server&#8217; : Give a name to your Linked server<br \/>\n&#8216;Provider&#8217; : Choose &#8216;Oracle Provider for OLE DB&#8217;<br \/>\n&#8216;Data source&#8217; : Your service name (defined in tnsnames.ora file)<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/serverlinked_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41770 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/serverlinked_1.png\" alt=\"\" width=\"698\" height=\"658\" \/><\/a><\/p>\n<ul>\n<li>In Security Section<br \/>\nPut a valide username and password and then click on &#8216;OK&#8217;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/serverlinked_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41771 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/serverlinked_2.png\" alt=\"\" width=\"698\" height=\"658\" \/><\/a><\/p>\n<ul>\n<li>Now under your Linked server and then &#8216;Catalogs&#8217; and then &#8216;default&#8217; your must see every tables that your user have right to query.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/tables.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41773 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/tables.png\" alt=\"\" width=\"356\" height=\"418\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center\">enjoy \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit hard. For exemple moving some data from an Oracle database to a SQL Server database&hellip;&nbsp;<\/p>\n","protected":false},"author":27,"featured_media":14414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133,59,99],"tags":[635,2033],"class_list":["post-14413","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","category-oracle","category-sql-server","tag-dbdoracle","tag-linked-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Create and configure an Oracle linked server in SQL Server Instance - dbi services Blog<\/title>\n<meta name=\"description\" content=\"create and configure an oracle linked server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create and configure an Oracle linked server in SQL Server Instance\" \/>\n<meta property=\"og:description\" content=\"create and configure an oracle linked server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-15T11:38:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"790\" \/>\n\t<meta property=\"og:image:height\" content=\"602\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"Create and configure an Oracle linked server in SQL Server Instance\",\"datePublished\":\"2020-07-15T11:38:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/\"},\"wordCount\":354,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/install_1.png\",\"keywords\":[\"DBD::Oracle\",\"Linked server\"],\"articleSection\":[\"Database\",\"Oracle\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/\",\"name\":\"Create and configure an Oracle linked server in SQL Server Instance - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/install_1.png\",\"datePublished\":\"2020-07-15T11:38:06+00:00\",\"description\":\"create and configure an oracle linked server\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/install_1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/install_1.png\",\"width\":790,\"height\":602,\"caption\":\"Install oracle database client\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create and configure an Oracle linked server in SQL Server Instance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Create and configure an Oracle linked server in SQL Server Instance - dbi services Blog","description":"create and configure an oracle linked server","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:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/","og_locale":"en_US","og_type":"article","og_title":"Create and configure an Oracle linked server in SQL Server Instance","og_description":"create and configure an oracle linked server","og_url":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2020-07-15T11:38:06+00:00","og_image":[{"width":790,"height":602,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"Create and configure an Oracle linked server in SQL Server Instance","datePublished":"2020-07-15T11:38:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/"},"wordCount":354,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_1.png","keywords":["DBD::Oracle","Linked server"],"articleSection":["Database","Oracle","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/","url":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/","name":"Create and configure an Oracle linked server in SQL Server Instance - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_1.png","datePublished":"2020-07-15T11:38:06+00:00","description":"create and configure an oracle linked server","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/install_1.png","width":790,"height":602,"caption":"Install oracle database client"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/create-and-configure-an-oracle-linked-server-in-sql-server-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Create and configure an Oracle linked server in SQL Server Instance"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14413"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14414"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}