{"id":1026,"date":"2026-07-29T11:11:55","date_gmt":"2026-07-29T08:11:55","guid":{"rendered":"https:\/\/oraclius.com.tr\/?p=1026"},"modified":"2026-07-29T14:52:56","modified_gmt":"2026-07-29T11:52:56","slug":"oracle-database-gateway-for-sql-server-19c-kurulumu-adim-adim-rehber","status":"publish","type":"post","link":"https:\/\/oraclius.com.tr\/en\/oracle-database-gateway-for-sql-server-19c-kurulumu-adim-adim-rehber\/","title":{"rendered":"Oracle Database Gateway for SQL Server 19c Kurulumu (Ad\u0131m Ad\u0131m Rehber)"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Oracle Database Link (DB Link), Oracle veritabanlar\u0131 aras\u0131nda veri al\u0131\u015fveri\u015fi yapmak i\u00e7in kullan\u0131lan g\u00fc\u00e7l\u00fc bir \u00f6zelliktir. Ancak Oracle Database Link \u00f6zelli\u011fi, Oracle d\u0131\u015f\u0131ndaki veritabanlar\u0131na (\u00f6rne\u011fin Microsoft SQL Server) do\u011frudan ba\u011flant\u0131 sa\u011flayamaz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu noktada Oracle&#8217;\u0131n&nbsp;<strong>Heterogeneous Services (HS)<\/strong>&nbsp;altyap\u0131s\u0131 ve&nbsp;<strong>Oracle Database Gateway for SQL Server (DG4MSQL)<\/strong>&nbsp;bile\u015feni devreye girer. Oracle Database Gateway, Oracle ile SQL Server aras\u0131nda bir ara katman g\u00f6revi g\u00f6rerek SQL Server \u00fczerindeki tablolar\u0131n Oracle taraf\u0131nda standart bir Database Link \u00fczerinden sorgulanabilmesini sa\u011flar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu makalede Oracle Database 19c ile Microsoft SQL Server aras\u0131nda&nbsp;<strong>Oracle Database Gateway for SQL Server 19c<\/strong>kullan\u0131larak g\u00fcvenli ve kararl\u0131 bir ba\u011flant\u0131n\u0131n nas\u0131l kurulaca\u011f\u0131 ad\u0131m ad\u0131m incelenecektir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kurulum tamamland\u0131\u011f\u0131nda SQL Server tablolar\u0131na Oracle Database \u00fczerinden a\u015fa\u011f\u0131daki gibi eri\u015filebilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM dbo.Employee@MSSQL_LINK;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Mimari<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>                Oracle Database\n                      \u2502\n               Database Link\n                      \u2502\n                      \u25bc\n          Oracle Net Listener\n                      \u2502\n                      \u25bc\n Oracle Database Gateway (DG4MSQL)\n                      \u2502\n                      \u25bc\n Microsoft ODBC Driver\n                      \u2502\n                      \u25bc\n      Microsoft SQL Server<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu mimaride Oracle Database, Microsoft SQL Server ile do\u011frudan ileti\u015fim kurmaz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ba\u011flant\u0131 ak\u0131\u015f\u0131 a\u015fa\u011f\u0131daki bile\u015fenler \u00fczerinden ger\u00e7ekle\u015fir:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Database Link<\/li>\n\n\n\n<li>Oracle Net Listener<\/li>\n\n\n\n<li>Oracle Database Gateway for SQL Server<\/li>\n\n\n\n<li>Microsoft ODBC Driver<\/li>\n\n\n\n<li>Microsoft SQL Server<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Gateway, Oracle SQL ifadelerini SQL Server&#8217;\u0131n anlayabilece\u011fi formata d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve SQL Server taraf\u0131ndan d\u00f6nd\u00fcr\u00fclen sonu\u00e7lar\u0131 Oracle Database&#8217;in i\u015fleyebilece\u011fi yap\u0131ya \u00e7evirir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway kurulumu, mevcut Oracle Database Home \u00fczerine de\u011fil, ayr\u0131 bir Oracle Home dizinine ger\u00e7ekle\u015ftirilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. Gerekli Kurulum Dosyalar\u0131n\u0131n \u0130ndirilmesi<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kuruluma ba\u015flamadan \u00f6nce a\u015fa\u011f\u0131daki yaz\u0131l\u0131mlar\u0131n haz\u0131r olmas\u0131 gerekmektedir.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Yaz\u0131l\u0131m<\/th><th>A\u00e7\u0131klama<\/th><th>\u0130ndirme<\/th><\/tr><\/thead><tbody><tr><td>Oracle Database Gateway 19c<\/td><td>Oracle ile SQL Server aras\u0131nda ba\u011flant\u0131y\u0131 sa\u011flar.<\/td><td><a href=\"https:\/\/www.oracle.com\/downloads\/?utm_source=chatgpt.com\">Oracle Software Delivery Cloud<\/a><\/td><\/tr><tr><td>Microsoft ODBC Driver 18 for SQL Server<\/td><td>Gateway&#8217;in SQL Server&#8217;a ba\u011flanmas\u0131n\u0131 sa\u011flayan ODBC s\u00fcr\u00fcc\u00fcs\u00fcd\u00fcr.<\/td><td><a href=\"https:\/\/learn.microsoft.com\/sql\/connect\/odbc\/download-odbc-driver-for-sql-server?utm_source=chatgpt.com\">Microsoft ODBC Driver for SQL Server<\/a><\/td><\/tr><tr><td>unixODBC<\/td><td>Linux \u00fczerinde ODBC s\u00fcr\u00fcc\u00fclerini y\u00f6neten bile\u015fendir.<\/td><td><a href=\"https:\/\/www.unixodbc.org\/?utm_source=chatgpt.com\">unixODBC Resmi Sitesi<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Bu makaledeki kurulum Oracle Linux \/ RHEL tabanl\u0131 bir Linux sunucu \u00fczerinde ger\u00e7ekle\u015ftirilmi\u015ftir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kurulum s\u0131ras\u0131nda kullan\u0131lan bile\u015fenler:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Database Gateway 19c<\/li>\n\n\n\n<li>Microsoft ODBC Driver 18 for SQL Server<\/li>\n\n\n\n<li>unixODBC<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Not:<\/strong>&nbsp;Oracle Database Gateway yaz\u0131l\u0131m\u0131, Oracle Database kurulum medyas\u0131 i\u00e7erisinde bulunmaz. Oracle lisans\u0131na sahip kullan\u0131c\u0131lar, Gateway kurulum paketini Oracle Software Delivery Cloud veya My Oracle Support \u00fczerinden indirebilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Gateway kurulumu mevcut Oracle Database Home \u00fczerine yap\u0131lmamal\u0131d\u0131r. Kurulum i\u00e7in ayr\u0131 bir Oracle Home dizini kullan\u0131lmal\u0131d\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. Microsoft ODBC Driver Kurulumu<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway for SQL Server (DG4MSQL), Microsoft SQL Server ile do\u011frudan ileti\u015fim kurmaz. SQL Server ba\u011flant\u0131s\u0131 i\u00e7in i\u015fletim sistemi \u00fczerinde Microsoft ODBC Driver kullan\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu nedenle Oracle Database Gateway kurulumu \u00f6ncesinde Microsoft ODBC Driver&#8217;\u0131n Oracle Gateway sunucusuna kurulmas\u0131 gerekmektedir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu \u00f6rnek kurulum\u00a0<strong>Oracle Linux 7.9 \/ RHEL 7.9<\/strong>\u00a0i\u015fletim sistemi \u00fczerinde ger\u00e7ekle\u015ftirilmi\u015ftir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.1. Microsoft Repository&#8217;yi Ekleyin<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo rpm --import https:\/\/packages.microsoft.com\/keys\/microsoft.asc\n\nsudo curl -o \/etc\/yum.repos.d\/mssql-release.repo \\\nhttps:&#47;&#47;packages.microsoft.com\/config\/rhel\/7\/prod.repo<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.2. ODBC Driver&#8217;\u0131 Kurun<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo ACCEPT_EULA=Y yum install -y msodbcsql18<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">RHEL 7 veya Oracle Linux 7 kullan\u0131yorsan\u0131z&nbsp;<code>dnf<\/code>&nbsp;yerine&nbsp;<code>yum<\/code>&nbsp;komutunu kullanabilirsiniz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.3. Kurulumu Do\u011frulay\u0131n<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>odbcinst -q -d<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek \u00e7\u0131kt\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;ODBC Driver 18 for SQL Server]<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu \u00e7\u0131kt\u0131y\u0131 al\u0131yorsan\u0131z Microsoft ODBC Driver ba\u015far\u0131yla kurulmu\u015ftur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Driver k\u00fct\u00fcphane dosyas\u0131n\u0131 do\u011frulamak i\u00e7in:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>find \/opt\/microsoft -name \"libmsodbcsql*.so\"<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3. unixODBC Kurulumu<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">unixODBC, Linux i\u015fletim sistemlerinde ODBC s\u00fcr\u00fcc\u00fclerini y\u00f6neten ve uygulamalar\u0131n ODBC tabanl\u0131 ba\u011flant\u0131lar kurmas\u0131n\u0131 sa\u011flayan katmand\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway for SQL Server (DG4MSQL), Microsoft ODBC Driver \u00fczerinden SQL Server&#8217;a ba\u011flan\u0131rken unixODBC altyap\u0131s\u0131n\u0131 kullan\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu nedenle Microsoft ODBC Driver kurulumundan sonra unixODBC paketlerinin kurulmas\u0131 gerekmektedir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3.1. unixODBC Paketlerini Kurun<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo yum install -y unixODBC unixODBC-devel<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Oracle Linux 7 veya RHEL 7 kullan\u0131yorsan\u0131z&nbsp;<code>dnf<\/code>&nbsp;yerine&nbsp;<code>yum<\/code>&nbsp;kullanabilirsiniz.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">3.2. Kurulumu Do\u011frulay\u0131n<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki komut ile kurulumun ba\u015far\u0131l\u0131 oldu\u011funu do\u011frulay\u0131n.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odbcinst -j<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek \u00e7\u0131kt\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>unixODBC 2.3.7\nDRIVERS............: \/etc\/odbcinst.ini\nSYSTEM DATA SOURCES: \/etc\/odbc.ini\nFILE DATA SOURCES..: \/etc\/ODBCDataSources\nUSER DATA SOURCES..: \/home\/oracle\/.odbc.ini<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu \u00e7\u0131kt\u0131,&nbsp;<code>unixODBC<\/code>&#8216;nin do\u011fru \u015fekilde kuruldu\u011funu ve yap\u0131land\u0131rma dosyalar\u0131n\u0131n kullan\u0131laca\u011f\u0131 yollar\u0131 g\u00f6sterir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">4. Oracle Database Gateway 19c Kurulumu (OUI)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway for Microsoft SQL Server kurulumu, Oracle Universal Installer (OUI) kullan\u0131larak ger\u00e7ekle\u015ftirilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Gateway kurulumu mevcut Oracle Database Home \u00fczerine yap\u0131lmamal\u0131d\u0131r. Oracle Database ve Gateway i\u00e7in ayr\u0131 Oracle Home dizinleri kullan\u0131lmal\u0131d\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek dizin yap\u0131s\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Oracle Database Home: \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\n\nOracle Database Gateway Home: \/u01\/app\/oracle\/product\/gateway<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway, SQL Server ba\u011flant\u0131s\u0131 i\u00e7in kullan\u0131lan ayr\u0131 bir Oracle yaz\u0131l\u0131m bile\u015fenidir ve herhangi bir database instance olu\u015fturmaz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4.1. Gateway Kurulum Medyas\u0131n\u0131n Haz\u0131rlanmas\u0131<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway 19c kurulum dosyalar\u0131 Oracle Software Delivery Cloud veya My Oracle Support \u00fczerinden indirilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kurulum dosyas\u0131 Linux sunucu \u00fczerinde uygun bir dizine aktar\u0131l\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/stage \nunzip LINUX.X64_193000_gateways.zip\ncd gateways\n.\/runInstaller<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Kurulum ad\u0131mlar\u0131:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Specify Installation Location\n<ul class=\"wp-block-list\">\n<li>Oracle Base: \/u01\/app\/oracle<\/li>\n\n\n\n<li>Software location: \/u01\/app\/oracle\/product\/gateway<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Available Product Components\n<ul class=\"wp-block-list\">\n<li>Component Name: Oracle Database Gateway for Microsoft SQL Server<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Oracle Database Gateway For Microsoft SQL Server\n<ul class=\"wp-block-list\">\n<li>Hostname: &lt;sql_server_host_ip><\/li>\n\n\n\n<li>Port: 1433 (default)<\/li>\n\n\n\n<li>Server Name: &lt;sql_server_name><\/li>\n\n\n\n<li>Database Name: &lt;db_name><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">4.2. Gateway Kurulum Kontrol\u00fc<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Kurulum sonras\u0131 Gateway Oracle Home kontrol edilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ls -ltr \/u01\/app\/oracle\/product\/gateway<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Beklenen dizin yap\u0131s\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>bin\nnetwork\nlib\ndg4msql\n...<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">5. Oracle Database Gateway Konfig\u00fcrasyonu<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway kurulumu tamamland\u0131ktan sonra Gateway&#8217;in Microsoft SQL Server ile ileti\u015fim kurabilmesi i\u00e7in initialization dosyas\u0131n\u0131n yap\u0131land\u0131r\u0131lmas\u0131 gerekir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Gateway ba\u011flant\u0131 ayarlar\u0131 a\u015fa\u011f\u0131daki dosyada bulunur:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/u01\/app\/oracle\/product\/gateway\/dg4msql\/admin\/initdg4msql.ora<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">5.1. ODBC Driver Bilgilerinin Kontrol Edilmesi<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Gateway&#8217;in kullanaca\u011f\u0131 ODBC driver bilgileri kontrol edilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6ncelikle unixODBC yap\u0131land\u0131rma yollar\u0131 g\u00f6r\u00fcnt\u00fclenir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odbcinst -j<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek \u00e7\u0131kt\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>unixODBC 2.3.1 \nDRIVERS............: \/etc\/odbcinst.ini \nSYSTEM DATA SOURCES: \/etc\/odbc.ini\n...<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">ODBC driver tan\u0131m\u0131 kontrol edilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cat \/etc\/odbcinst.ini<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek \u00e7\u0131kt\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;ODBC Driver 18 for SQL Server] \nDescription=Microsoft ODBC Driver 18 for SQL Server Driver=\/opt\/microsoft\/msodbcsql18\/lib64\/libmsodbcsql-18.so UsageCount=1<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Buradaki\u00a0<code>Driver<\/code>\u00a0parametresinde belirtilen yol, Gateway yap\u0131land\u0131rmas\u0131nda kullan\u0131lacakt\u0131r.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5.2. Gateway Initialization Dosyas\u0131n\u0131n D\u00fczenlenmesi<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Gateway ba\u011flant\u0131 ayarlar\u0131 i\u00e7in dosya a\u00e7\u0131l\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>vi \/u01\/app\/oracle\/product\/gateway\/dg4msql\/admin\/initdg4msql.ora<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki parametreler eklenir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>HS_FDS_CONNECT_INFO=\"100.100.100.101:1433\/\/ERPDB\"\n\nHS_FDS_SHAREABLE_NAME=\/opt\/microsoft\/msodbcsql18\/lib64\/libmsodbcsql-18.so\n\nHS_FDS_TRACE_LEVEL=OFF\n\nHS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8\n\nHS_NLS_NCHAR=UCS2<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Note: \/etc\/odbcinst.ini dosyas\u0131ndaki Driver parametresini burada HS_FDS_SHAREABLE_NAME parametresine yaz\u0131lmas\u0131 gerekir.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Parametre<\/th><th>A\u00e7\u0131klama<\/th><\/tr><\/thead><tbody><tr><td><code>HS_FDS_CONNECT_INFO<\/code><\/td><td><code>\/etc\/odbc.ini<\/code>&nbsp;dosyas\u0131nda tan\u0131mlanan DSN ad\u0131d\u0131r.<\/td><\/tr><tr><td><code>HS_FDS_TRACE_LEVEL<\/code><\/td><td>Gateway log seviyesini belirler. Normal kullan\u0131mda&nbsp;<code>OFF<\/code>&nbsp;\u00f6nerilir.<\/td><\/tr><tr><td><code>HS_LANGUAGE<\/code><\/td><td>Oracle karakter setini belirtir.<\/td><\/tr><tr><td><code>HS_NLS_NCHAR<\/code><\/td><td>Unicode karakter deste\u011fini sa\u011flar.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">6. Oracle Listener Yap\u0131land\u0131rmas\u0131<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway servisinin Oracle Listener taraf\u0131ndan kar\u015f\u0131lanabilmesi i\u00e7in Gateway SID tan\u0131m\u0131n\u0131n Listener yap\u0131land\u0131rmas\u0131na eklenmesi gerekir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu i\u015flem ile Oracle Database, Gateway servisine Oracle Net \u00fczerinden ula\u015fabilir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">6.1. listener.ora Dosyas\u0131n\u0131n D\u00fczenlenmesi<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki dosyay\u0131 a\u00e7\u0131n:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>vi $ORACLE_HOME\/network\/admin\/listener.ora<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Mevcut&nbsp;<code>SID_LIST_LISTENER<\/code>&nbsp;i\u00e7erisine Gateway i\u00e7in yeni bir&nbsp;<code>SID_DESC<\/code>&nbsp;eklenir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SID_LIST_LISTENER =\n  (SID_LIST =\n    (SID_DESC =\n      (SDU=32767)\n      (SID_NAME = EXA01)\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1)\n      (PROGRAM = EXA01)\n    )\n    (SID_DESC =\n      (SID_NAME = dg4msql)\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/gateway)\n      (PROGRAM = dg4msql)\n    )\n  )<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">6.2. Listener&#8217;\u0131 Yeniden Ba\u015flat\u0131n<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Yap\u0131lan de\u011fi\u015fikliklerin aktif olmas\u0131 i\u00e7in Listener yeniden ba\u015flat\u0131l\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>lsnrctl stop\nlsnrctl start<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">6.3. Listener Durumunu Kontrol Edin<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Gateway servisinin Listener taraf\u0131ndan g\u00f6r\u00fcld\u00fc\u011f\u00fc kontrol edilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>lsnrctl status<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Ba\u015far\u0131l\u0131 bir yap\u0131land\u0131rmada a\u015fa\u011f\u0131daki benzer \u00e7\u0131kt\u0131 g\u00f6r\u00fcl\u00fcr:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Service \"dg4msql\" has 1 instance(s). \nInstance \"dg4msql\", status UNKNOWN, has 1 handler(s) for this service...<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Not:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database Gateway servislerinde&nbsp;<code>status UNKNOWN<\/code>&nbsp;g\u00f6r\u00fclmesi normaldir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Gateway servisleri klasik Oracle database instance olmad\u0131\u011f\u0131 i\u00e7in Listener taraf\u0131ndan otomatik instance durumu kontrol edilemez. Bu nedenle&nbsp;<code>UNKNOWN<\/code>&nbsp;hata anlam\u0131na gelmez.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu a\u015famadan sonra Oracle Database&#8217;in Gateway servisine ula\u015fabilmesi i\u00e7in TNS yap\u0131land\u0131rmas\u0131 yap\u0131lacakt\u0131r.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">7. TNS Yap\u0131land\u0131rmas\u0131<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database&#8217;in Gateway servisine ba\u011flanabilmesi i\u00e7in&nbsp;<code>tnsnames.ora<\/code>&nbsp;dosyas\u0131na yeni bir servis tan\u0131mlay\u0131n.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">7.1.\u00a0<code>tnsnames.ora<\/code>\u00a0Dosyas\u0131n\u0131 D\u00fczenleyin<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>vi $ORACLE_HOME\/network\/admin\/tnsnames.ora<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki kayd\u0131 ekleyin:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DG4MSQL =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))\n    (CONNECT_DATA =\n      (SID = dg4msql)\n    )\n    (HS = OK)\n  )\n\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Not:<\/strong>&nbsp;Gateway farkl\u0131 bir sunucuda \u00e7al\u0131\u015f\u0131yorsa&nbsp;<code>HOST<\/code>&nbsp;de\u011ferini o sunucunun IP adresi veya hostname&#8217;i ile de\u011fi\u015ftirin.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">7.2. TNS Kayd\u0131n\u0131 Test Edin<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki komut ile TNS kayd\u0131n\u0131n do\u011fru tan\u0131mland\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>tnsping MSSQL<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek \u00e7\u0131kt\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>OK (20 msec)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu \u00e7\u0131kt\u0131y\u0131 al\u0131yorsan\u0131z Oracle Database, Gateway servisine ba\u015far\u0131yla ula\u015fabiliyor demektir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">8. Database Link Olu\u015fturma<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki komut ile SQL Server&#8217;a ba\u011flanacak Database Link&#8217;i olu\u015fturun.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE LINK MSSQL_LINK\nCONNECT TO \"sql_user\"\nIDENTIFIED BY \"password\"\nUSING 'DG4MSQL';<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Not:<\/strong>&nbsp;<code>sql_user<\/code>&nbsp;and&nbsp;<code>password<\/code>&nbsp;bilgilerini SQL Server&#8217;da olu\u015fturdu\u011funuz kullan\u0131c\u0131 bilgileri ile de\u011fi\u015ftirin.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">8.1. Database Link&#8217;i Test Edin<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6ncelikle ba\u011flant\u0131n\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 do\u011frulamak i\u00e7in basit bir sorgu \u00e7al\u0131\u015ft\u0131r\u0131n.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT 1\nFROM dual@MSSQL_LINK;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Ard\u0131ndan SQL Server \u00fczerindeki bir tabloyu sorgulayabilirsiniz.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM dbo.Employee@MSSQL_LINK;<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Not:<\/strong>&nbsp;Oracle, SQL Server nesnelerine eri\u015firken tablo ve \u015fema adlar\u0131nda b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131l\u0131\u011f\u0131 ile ilgili davran\u0131\u015flar g\u00f6sterebilir. Gerekirse nesne adlar\u0131n\u0131 \u00e7ift t\u0131rnak (<code>\" \"<\/code>) i\u00e7erisinde kullanabilirsiniz.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">8.2. Ba\u011flant\u0131y\u0131 Kontrol Etme<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Olu\u015fturulan Database Link&#8217;i a\u015fa\u011f\u0131daki sorgu ile g\u00f6r\u00fcnt\u00fcleyebilirsiniz.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT db_link, username, host\nFROM user_db_links;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>DB_LINK<\/th><th>USERNAME<\/th><th>HOST<\/th><\/tr><\/thead><tbody><tr><td>MSSQL_LINK<\/td><td>sql_user<\/td><td>MSSQL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Bu ad\u0131mla Oracle Database ve SQL Server aras\u0131ndaki ba\u011flant\u0131 tamamlanm\u0131\u015f olur.<\/p>","protected":false},"excerpt":{"rendered":"<p>Oracle Database Link (DB Link), Oracle veritabanlar\u0131 aras\u0131nda veri al\u0131\u015fveri\u015fi yapmak i\u00e7in kullan\u0131lan g\u00fc\u00e7l\u00fc bir \u00f6zelliktir. Ancak DB Link, do\u011frudan Microsoft SQL Server gibi Oracle d\u0131\u015f\u0131ndaki veritabanlar\u0131na ba\u011flanamaz.<\/p>","protected":false},"author":1,"featured_media":1029,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-1026","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel-en"],"_links":{"self":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/1026","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/comments?post=1026"}],"version-history":[{"count":2,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/1026\/revisions"}],"predecessor-version":[{"id":1030,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/1026\/revisions\/1030"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/media\/1029"}],"wp:attachment":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/media?parent=1026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/categories?post=1026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/tags?post=1026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}