{"id":7980,"date":"2022-03-21T11:16:59","date_gmt":"2022-03-21T10:16:59","guid":{"rendered":"https:\/\/www.carajandb.com\/blog\/2022\/oracle-datenbank-link-nach-mysql-einrichten\/"},"modified":"2022-08-16T09:14:26","modified_gmt":"2022-08-16T07:14:26","slug":"setup-oracle-database-link-to-mysql","status":"publish","type":"post","link":"https:\/\/carajandb.com\/en\/2022\/03\/21\/setup-oracle-database-link-to-mysql\/","title":{"rendered":"Setup Oracle Database Link to MySQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">This Blog describes how to set up a Database link from an Oracle Database to a MySQL Database. As an example serves an Oracle Standard Edition Two Version 19c (19.14.0) Database with the Standard Edition High Availability (SEHA) configuration on Oracle Linux 8.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Packageinstallation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For the installation two RPM-Packages are needed:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><code>yum install unixODBC<\/code><\/li><li>Download <code>mysql-connector-odbc-8.0.28-1.el8.x86_64.rpm<\/code><\/li><li><code>rpm -ihv mysql-connector-odbc-8.0.28-1.el8.x86_64.rpm<\/code><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The package <code>unixODBC <\/code>installs the basic libraries including <code>\/usr\/lib64\/libodbc.so<\/code> which is needed later and the files <code>\/etc\/odbc.ini<\/code> as well as<code> \/etc\/odbcinst.ini<\/code>. Furthermore the tool <code>\/usr\/bin\/isql<\/code> belongs to that package<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The package&nbsp;mysql-connector-odbc then installs the specific mysql libraries. The file <code>\/etc\/odbcinst.ini<\/code> is also going to be adjusted<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">ODBC Configuration<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For the next step the ODBC client will be configured. For this, the configuration for one or more connections is entered in <code>\/etc\/odbc.ini<\/code>. &nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example:<\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">[TESTMYDB]\nDescription     = Test-MYSQL-Datenbank\nDriver          = \/usr\/lib64\/libmyodbc8w.so\nTrace           = no\nServer          = 192.168.168.168\nPort            = 3306\nDatabase        = daten\nUser            = TESTUSER\nPassword        = passwort<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">It is important to have the name of the entry (<code>TESTMYDB<\/code>) and the correct driver. The driver for a unicode MySQL Database is <code>libmyodbc8w.so<\/code>. Otherwise &nbsp;<code>libmyodbc8a.so <\/code>can be used for a MySQL Database with a 1-Byte character set.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With this it should be possible to connect to the MySQL database from the server.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">isql TESTMYDB TESTUSER passwort<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Gateway Installation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For the next step, the Oracle Gateway software will be installed. Unfortunately it is still necessary to unpack the software first and then install it:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">cd \/u05\/share\/software\nunzip LINUX.X64:193000_gateways.zip\ncd gateways\n.\/runInstaller\n<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"591\" height=\"465\" src=\"https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image.png\" alt=\"\" class=\"wp-image-7973\" title=\"\" srcset=\"https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image.png 591w, https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image-450x354.png 450w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><figcaption>Gateway Software Installation Directory<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"591\" height=\"465\" src=\"https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image-1.png\" alt=\"\" class=\"wp-image-7975\" title=\"\" srcset=\"https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image-1.png 591w, https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image-1-450x354.png 450w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><figcaption>Selection of Gateways<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In the example the gateway for MS-SQL is also installed. This is not important for this configuration.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"591\" height=\"465\" src=\"https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image-2.png\" alt=\"\" class=\"wp-image-7977\" title=\"\" srcset=\"https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image-2.png 591w, https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/image-2-450x354.png 450w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><figcaption>Summary<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Thus the gateway is installed in the directory <code>\/u01\/app\/oracle\/product\/19c\/gwhome_1<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Gateway Configuration<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Three components are responsible for the configuration:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><code>listener.ora<\/code><\/li><li><code>tnsnames.ora<\/code><\/li><li><code>init&lt;GATEWAYNAME&gt;.ora<\/code><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><code>listener.ora<\/code><\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">LISTENER=\n   (DESCRIPTION=\n      (ADDRESS_LIST=\n         (ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))\n         (ADDRESS=(PROTOCOL=TCP)(HOST=seha01)(PORT=1521))\n      )\n   )\n\nSID_LIST_LISTENER =\n   (SID_LIST=\n      (SID_DESC=\n         (SID_NAME=TESTMYDB)\n         (ORACLE_HOME=\/u01\/app\/oracle\/product\/19\/gwhome_1)\n         (PROGRAM=dg4odbc)\n      )\n   )<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The <code>SID_NAME <\/code>must correspond to the name in the<code> \/etc\/odbc.ini<\/code> file. Of course there can be further SIDs for databases or further ODBC connections. On the second SEHA server the parameter &#8220;<code>HOST<\/code>&#8221; must be adjusted.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><code>tnsnames.ora<\/code><\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">TESTMYDB =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = seha01)(PORT = 1521))\n    (ADDRESS = (PROTOCOL = TCP)(HOST = seha02)(PORT = 1521))\n    (CONNECT_DATA =\n      (SID = TESTMYDB)\n    )\n    (HS = OK)\n  )<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">For RAC or SEHA databases, the scan address cannot be used here. Instead, the <code>HOSTS <\/code>has to be specified explicitly.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The TNS alias may have a different name than the SID, which again must be identical to the entry in <code>\/etc\/odbc.ini<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><code>initTESTWEBDB.ora<\/code><\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">HS_FDS_CONNECT_INFO = TESTWEBDB\n#HS_FDS_TRACE_LEVEL = OFF\n#HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P15\nHS_FDS_SHAREABLE_NAME = \/usr\/lib64\/libodbc.so<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The name of the file must correspond to the name of the <code>odbc.ini<\/code> entry.<br>It is important that the parameter <code>HS_FDS_SHAREABLE_NAME<\/code> is not the ODBC library of MySQL but the so called &#8220;<em>ODBC Drive Manager<\/em>&#8220;. In this case it is the <code>libodbc.so<\/code> from the <code>unixODBC<\/code>&nbsp;package.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Database-Link<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After all the preparation, the database link can now be created as usual:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE DATABASE LINK jostest\nCONNECT TO \"TESTUSER\" IDENTIFIED BY \"password\"\nUSING 'TESTMYWEBDB\";<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">With this the connection to the MySQL database should work.<br>If the following error occurs:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ORA-28500: connection from ORACLE to a non-Oracle system returned this message:\n[<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This is probably because the MySQL database is not a Unicode database. The easiest way to solve the problem is to set the following parameter in the <code>initTESTMYDB.ora<\/code> file:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P15<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">When accessing the MySQL databases, please note that tables and databases are usually written in lower case. So it is better to put the database and table names in double quotation marks.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT * FROM \"daten\".\"test\"@jostest;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If something is still missing or errors occurred, then please send a short message to me or leave a comment on the blog.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Good luck!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This Blog describes how to set up a Database link from an Oracle Database to a MySQL Database. As an example serves an Oracle Standard Edition Two Version 19c (19.14.0) Database with the Standard Edition High Availability (SEHA) configuration on Oracle Linux 8.<\/p>\n","protected":false},"author":3,"featured_media":9384,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[406],"tags":[497,498,499,500],"class_list":["post-7980","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-en","tag-mysql-en","tag-odbc-en","tag-odbc-ini-en","tag-oracle-2-en"],"acf":{"occupation":"Write the Occupation of the Person","person_can-be-speaker":true,"person_is-team":true,"person_related-user-account":null,"person_ordering-number":50,"publication_speakers":null,"publication_content-language":["de"],"publication_files":null,"publication_event":"","publication_date":null},"spectra_custom_meta":{"_encloseme":["1"],"_wpml_word_count":["{\"total\":734,\"to_translate\":{\"en\":734}}"],"layout_header":["light"],"_layout_header":["field_5a48111185e5f"],"layout_background":[""],"_layout_background":["field_5a481193c0995"],"layout_hide_services":["0"],"_layout_hide_services":["field_5a4811c5c0996"],"layout_show-author-box":["1"],"_layout_show-author-box":["field_5a64ee9cc6490"],"layout_show-categories-tags":["1"],"_layout_show-categories-tags":["field_5a64eee4c6491"],"blogpost_related-publications":[""],"_blogpost_related-publications":["field_5a480debdac62"],"blogpost_related-files":[""],"_blogpost_related-files":["field_5a480f377db29"],"_wpml_media_duplicate":["1"],"_wpml_media_featured":["1"],"_yoast_wpseo_content_score":["90"],"_yoast_wpseo_estimated-reading-time-minutes":["5"],"_wpml_location_migration_done":["1"],"_edit_lock":["1752708887:8"],"_last_translation_edit_mode":["native-editor"],"_edit_last":["3"],"_wp_old_slug":["oracle-datenbank-link-nach-mysql-einrichten"],"_yoast_wpseo_wordproof_timestamp":[""],"astra_style_timestamp_css":["1780463271"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_internal_links_processed":["1"],"rank_math_og_content_image":["a:2:{s:5:\"check\";s:32:\"cffb27281123cc064aacaff8c6cd8381\";s:6:\"images\";a:1:{i:0;i:7973;}}"],"wpil_sync_report3":["1"],"wpil_links_inbound_internal_count":["10"],"wpil_links_inbound_internal_count_data":["eJztV0tu2zAQvQrBvW1ZsmyX3rVdJk2LLrIUaIq2pqZIlaTQGoG3PUCP2JN0KCquk6BAtpayE0fzefPecCBxNk\/YA7Bkc8fmOaP3Daji1pRSFTegD5TNM\/bg2IpRhccCSroJzo5ljLZWUXxap4xW3jdsNrNS8VaLKk3SxVRwy79xXW6nwtQzY7lQclJyL\/WW68Mk5JtoLqpJfXTf1USCtiAqfD2tfN1lXmBi43x4TJeM\/j97B4NR0F5azTF2y+YxvuniX\/T2OZj73hB+bCtfL0Nn6OnBK0k3n2IOf2wkvUznGKJxnvvWRSekRxgsrn0855Eud07hVLuPB4wUCsTju3WXEzwYHQ0BqLF7rkEU3vLdDsQ5UJbgje395oxysSue19VGiw76qQvhyFcIQRSo2F0nAvn4KAIJGpMgArk9fv1yQ\/6JQHssvCxlWWyPRYMtgA7UJhG3MoJH3E8JQEaTflx+VOAaaQthJZY8z07ADq7grTfB7dKMLYsD6P3FpAVzbcpWyeKJd9oX6Qr\/9NF+AlR+yKNs2WozVmXTQSv72iWVZ29L6upHORv0KFu2WD\/fUhkydC8BI5R0UhPQpNVOWlmT98rsyZ9fv69XzsXo5BzNTc1HJ+2gb+py0HK++hti+fYNcfWbaTXoUbbIx4tfnQxxf0AaQLeSINclMhj2k2kt2V79blqPT9DRXNZ349N2yJf19Bc\/gPs5"],"wpil_links_outbound_internal_count":["0"],"wpil_links_outbound_internal_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_links_outbound_external_count":["0"],"wpil_links_outbound_external_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_sync_report2_time":["2024-08-27T11:47:23+00:00"],"adv-header-id-meta":[""],"stick-header-meta":[""],"ast-featured-img":["disabled"],"theme-transparent-header-meta":[""],"_thumbnail_id":["9384"],"_wp_attachment_metadata":[""],"_uagb_previous_block_counts":["a:90:{s:21:\"uagb\/advanced-heading\";i:0;s:15:\"uagb\/blockquote\";i:0;s:12:\"uagb\/buttons\";i:0;s:18:\"uagb\/buttons-child\";i:0;s:19:\"uagb\/call-to-action\";i:0;s:15:\"uagb\/cf7-styler\";i:0;s:11:\"uagb\/column\";i:0;s:12:\"uagb\/columns\";i:0;s:14:\"uagb\/container\";i:0;s:21:\"uagb\/content-timeline\";i:0;s:27:\"uagb\/content-timeline-child\";i:0;s:14:\"uagb\/countdown\";i:0;s:12:\"uagb\/counter\";i:0;s:8:\"uagb\/faq\";i:0;s:14:\"uagb\/faq-child\";i:0;s:10:\"uagb\/forms\";i:0;s:17:\"uagb\/forms-accept\";i:0;s:19:\"uagb\/forms-checkbox\";i:0;s:15:\"uagb\/forms-date\";i:0;s:16:\"uagb\/forms-email\";i:0;s:17:\"uagb\/forms-hidden\";i:0;s:15:\"uagb\/forms-name\";i:0;s:16:\"uagb\/forms-phone\";i:0;s:16:\"uagb\/forms-radio\";i:0;s:17:\"uagb\/forms-select\";i:0;s:19:\"uagb\/forms-textarea\";i:0;s:17:\"uagb\/forms-toggle\";i:0;s:14:\"uagb\/forms-url\";i:0;s:14:\"uagb\/gf-styler\";i:0;s:15:\"uagb\/google-map\";i:0;s:11:\"uagb\/how-to\";i:0;s:16:\"uagb\/how-to-step\";i:0;s:9:\"uagb\/icon\";i:0;s:14:\"uagb\/icon-list\";i:0;s:20:\"uagb\/icon-list-child\";i:0;s:10:\"uagb\/image\";i:0;s:18:\"uagb\/image-gallery\";i:0;s:13:\"uagb\/info-box\";i:0;s:18:\"uagb\/inline-notice\";i:0;s:11:\"uagb\/lottie\";i:0;s:21:\"uagb\/marketing-button\";i:0;s:10:\"uagb\/modal\";i:0;s:18:\"uagb\/popup-builder\";i:0;s:16:\"uagb\/post-button\";i:0;s:18:\"uagb\/post-carousel\";i:0;s:17:\"uagb\/post-excerpt\";i:0;s:14:\"uagb\/post-grid\";i:0;s:15:\"uagb\/post-image\";i:0;s:17:\"uagb\/post-masonry\";i:0;s:14:\"uagb\/post-meta\";i:0;s:18:\"uagb\/post-taxonomy\";i:0;s:18:\"uagb\/post-timeline\";i:0;s:15:\"uagb\/post-title\";i:0;s:20:\"uagb\/restaurant-menu\";i:0;s:26:\"uagb\/restaurant-menu-child\";i:0;s:11:\"uagb\/review\";i:0;s:12:\"uagb\/section\";i:0;s:14:\"uagb\/separator\";i:0;s:11:\"uagb\/slider\";i:0;s:17:\"uagb\/slider-child\";i:0;s:17:\"uagb\/social-share\";i:0;s:23:\"uagb\/social-share-child\";i:0;s:16:\"uagb\/star-rating\";i:0;s:23:\"uagb\/sure-cart-checkout\";i:0;s:22:\"uagb\/sure-cart-product\";i:0;s:15:\"uagb\/sure-forms\";i:0;s:22:\"uagb\/table-of-contents\";i:0;s:9:\"uagb\/tabs\";i:0;s:15:\"uagb\/tabs-child\";i:0;s:18:\"uagb\/taxonomy-list\";i:0;s:9:\"uagb\/team\";i:0;s:16:\"uagb\/testimonial\";i:0;s:14:\"uagb\/wp-search\";i:0;s:19:\"uagb\/instagram-feed\";i:0;s:10:\"uagb\/login\";i:0;s:17:\"uagb\/loop-builder\";i:0;s:18:\"uagb\/loop-category\";i:0;s:20:\"uagb\/loop-pagination\";i:0;s:15:\"uagb\/loop-reset\";i:0;s:16:\"uagb\/loop-search\";i:0;s:14:\"uagb\/loop-sort\";i:0;s:17:\"uagb\/loop-wrapper\";i:0;s:13:\"uagb\/register\";i:0;s:19:\"uagb\/register-email\";i:0;s:24:\"uagb\/register-first-name\";i:0;s:23:\"uagb\/register-last-name\";i:0;s:22:\"uagb\/register-password\";i:0;s:30:\"uagb\/register-reenter-password\";i:0;s:19:\"uagb\/register-terms\";i:0;s:22:\"uagb\/register-username\";i:0;}"],"_uag_css_file_name":["uag-css-7980.css"]},"uagb_featured_image_src":{"full":["https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/einrichtung-oracle-postgresql-datenbanken.png",842,670,false],"thumbnail":["https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/einrichtung-oracle-postgresql-datenbanken-200x200.png",200,200,true],"medium":["https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/einrichtung-oracle-postgresql-datenbanken-450x358.png",450,358,true],"medium_large":["https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/einrichtung-oracle-postgresql-datenbanken-768x611.png",768,611,true],"large":["https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/einrichtung-oracle-postgresql-datenbanken.png",842,670,false],"1536x1536":["https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/einrichtung-oracle-postgresql-datenbanken.png",842,670,false],"2048x2048":["https:\/\/carajandb.com\/wp-content\/uploads\/2022\/03\/einrichtung-oracle-postgresql-datenbanken.png",842,670,false]},"uagb_author_info":{"display_name":"Johannes Ahrends","author_link":"https:\/\/carajandb.com\/en\/author\/9aa6cdb2095bd409\/"},"uagb_comment_info":12,"uagb_excerpt":"This Blog describes how to set up a Database link from an Oracle Database to a MySQL Database. As an example serves an Oracle Standard Edition Two Version 19c (19.14.0) Database with the Standard Edition High Availability (SEHA) configuration on Oracle Linux 8.","_links":{"self":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/7980","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/comments?post=7980"}],"version-history":[{"count":2,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/7980\/revisions"}],"predecessor-version":[{"id":8025,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/7980\/revisions\/8025"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media\/9384"}],"wp:attachment":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media?parent=7980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/categories?post=7980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/tags?post=7980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}