{"id":2821,"date":"2013-04-16T14:40:23","date_gmt":"2013-04-16T11:40:23","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=2821"},"modified":"2013-06-26T11:52:31","modified_gmt":"2013-06-26T08:52:31","slug":"oracle-goldengate-kurulum-yapilandirma-ve-yonetimi","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=2821","title":{"rendered":"Oracle GoldenGate 11g R2 Kurulum, Yap\u0131land\u0131rma ve Y\u00f6netimi"},"content":{"rendered":"<p style=\"text-align: justify;\"><a href=\"http:\/\/www.koraykey.com\/wp-content\/uploads\/OracleGG.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2822\" alt=\"OracleGG\" src=\"http:\/\/www.koraykey.com\/wp-content\/uploads\/OracleGG.jpg\" width=\"250\" height=\"216\" \/><\/a><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu makalemizde Oracle&#8217;\u0131n &#8220;Fussion Middleware&#8221; \u00fcr\u00fcn grubuna dahil etti\u011fi disaster \u00e7\u00f6z\u00fcm\u00fc, kritik sistemlerindeki s\u00fcreklili\u011fi sa\u011flamak i\u00e7in kullan\u0131lan &#8220;Oracle GoldenGate&#8221; \u00fcr\u00fcn\u00fcn\u00fc inceleyce\u011fiz. Kurulum i\u015flemlerimizi &#8220;Oracle Enterprise Linux 6.4&#8221; \u0130\u015fletim sistemi \u00fczerinde yapaca\u011f\u0131z.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate Nedir?<\/span><\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle \u2018\u0131n Fussion Middleware \u00fcr\u00fcn grubuna dahil etti\u011fi Oracle GoldenGate, veritabanlar\u0131 aras\u0131nda mevcut datan\u0131n DML, DDL, DCL ve TCL replikasyonuna olanak sa\u011flayan bir yaz\u0131l\u0131m \u00e7\u00f6z\u00fcm\u00fcd\u00fcr. Bu c\u00fcmleyi k\u0131saca a\u00e7\u0131klamak gerekirse, Oracle GoldenGate sayesinde kaynak veritaban\u0131 \u00fczerinde yap\u0131lan i\u015flemlerin kay\u0131tlar\u0131n\u0131 istedi\u011fimiz hedef veritabanlar\u0131 \u00fczerine dilersek ger\u00e7ek zamanl\u0131 veya gecikmeli olarak aktar\u0131p, i\u015fletebiliriz. Bu aktar\u0131m i\u015flemi kaynak veritaban\u0131nda yap\u0131lan b\u00fct\u00fcn i\u015flemleri kapsayabilece\u011fi gibi, spesifik olarak sadece bir seqeunce \u2018in, tablonun veya \u015feman\u0131n aktar\u0131m\u0131 olarak da yap\u0131labilir.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate \u2018in \u00f6nemli \u00f6zelliklerinden biride hibrit yap\u0131ya sahip olmas\u0131d\u0131r. Kaynak veritaban\u0131 Oracle olabilece\u011fi gibi hedef veritaban\u0131 MS-SQL Server veya tersi olabilir. Oracle GoldenGate hibrit yap\u0131s\u0131 sayesinde kros platform veya database \u2018de replikasyon yap\u0131lmas\u0131na destek verebilmektedir. Bunlara \u00f6rnek; Oracle, MS-SQL, Postgre SQL, MySQL ve IBM DB2.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate kaynak ve hedef sunuculara ayr\u0131 olarak kurulur ve sunucular\u0131n konfigrasyonlar\u0131 birbirinden farkl\u0131d\u0131r. Kaynak sunucuda Extract ve Pumper ismini verdi\u011fimiz servisler \u00e7al\u0131\u015f\u0131rken, hedef sunucuda Collector ve Replicat ismini verdi\u011fimiz servisler \u00e7al\u0131\u015f\u0131r. Bunlar\u0131n haricinde her iki sunucuda ortak olarak Manager servisleri hizmet verir. \u015eimdi k\u0131saca bu terimleri a\u00e7\u0131klayal\u0131m.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"><strong>Manager:<\/strong> \u0130sminden de anla\u015f\u0131laca\u011f\u0131 \u00fczere bu servis Oracle GoldenGate \u2018in y\u00f6netim servisidir. Hem kaynak hemde hedef sunucularda \u00e7al\u0131\u015f\u0131r. GoldenGate \u2018in konfigrasyonu bu servis \u00fczerinden y\u00f6netilir.\u00a0 \u00d6rnek; Extract process \u2018i taraf\u0131ndan \u00fcretilen trail dosyalar\u0131n\u0131 takip edilmesi ve raporlama i\u015flemleri bu servisin y\u00f6netimi alt\u0131ndad\u0131r. Extract, pumper ve replicat servislerinin \u00e7al\u0131\u015fabilmesi i\u00e7in Manager ervisinin \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 gereklidir.\u00a0 Extract servisi taraf\u0131ndan \u00fcretilen trail dosyalar\u0131n\u0131n ne kadar s\u00fcre saklanaca\u011f\u0131 vs. bilgileri Manager servisi \u00fczerinden kontrol edilir.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"><strong>Extract:<\/strong> Kaynak veritaban\u0131 \u00fczerinde \u00e7al\u0131\u015fan bu servis, veritaban\u0131nda ger\u00e7ekle\u015ftirilen b\u00fct\u00fcn i\u015flemlerin kayd\u0131n\u0131 yakalamakla g\u00f6revlidir. Bu kay\u0131tlar\u0131 \u00f6ncelikle Online Redolog (RBA numaralar\u0131ndan \u00e7\u0131kart\u0131l\u0131r) dosyalar\u0131ndan veya\u00a0 archive dosyalar\u0131 \u00fczerinden toplan\u0131r.<\/span><\/p>\n<p><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"><strong>Pumper:<\/strong> Bu servisin g\u00f6revi Extract process \u2018i taraf\u0131ndan olu\u015fturulan trail dosyalar\u0131n\u0131 hedef sunucuya Manager servisi \u00fczerinde tan\u0131ml\u0131 7809 portu (TCP\/IP) \u00fczerinden g\u00f6ndermektir.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"><strong>Replicat:<\/strong> Replicat servisi ad\u0131ndan da anla\u015f\u0131laca\u011f\u0131 \u00fczere, kaynak sunucu \u00fczerinde \u00e7al\u0131\u015fan Pumper process \u2018i taraf\u0131ndan g\u00f6nderilen trail dosyalar\u0131n\u0131n hedef veritaban\u0131na i\u015flenmesinden sorumludur. Gelen trail dosyalar\u0131n\u0131 ger\u00e7ek zamanl\u0131 olarak (online) i\u015fletebilece\u011finiz gibi parametreler yard\u0131m\u0131yla belirtece\u011finiz bir s\u00fcre vas\u0131tas\u0131yla gecikmeli olarakta i\u015fletebilirsiniz.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"><strong>Collector:<\/strong> Collector servisi GoldenGate \u2018in bir background servisidir ve sadece hedef sunucu \u00fczerinde \u00e7al\u0131\u015f\u0131r. Bu servis g\u00f6nderilen trail dosyalar\u0131n\u0131 i\u015fleyerek Replicat servisinin kullanabilece\u011fi formata getirilmesinden sorumludur.<\/span><\/p>\n<p><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate Kullan\u0131m Ama\u00e7lar\u0131<\/span><\/strong><\/p>\n<ul>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130\u015f s\u00fcreklili\u011finin devam\u0131 ve high availability ortamlar\u0131n\u0131n haz\u0131rlanmas\u0131<\/span><\/li>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131nda bulunan datan\u0131n ta\u015f\u0131nmas\u0131 veya upgrade i\u015flemleri<\/span><\/li>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veriambar\u0131 olu\u015fturmak i\u00e7in (Data Warehousing)<\/span><\/li>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Data entegrasyonu ve konsolidasyon i\u015flemleri<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate i\u00e7in ilk etapta yapaca\u011f\u0131m\u0131z yaz\u0131l\u0131m\u0131 kurmak olacakt\u0131r,yaz\u0131l\u0131m\u0131 kurduktan sonra konfig\u00fcrasyon yapabiliriz. Biz denemelerimizi &#8220;Oracle Enterprise Linux&#8221; \u00fczerinde yapaca\u011f\u0131z. \u0130lk olarak Golden Gate \u00fcr\u00fcn\u00fcn\u00fc indirmemiz gerekiyor. <a href=\"https:\/\/edelivery.oracle.com\/\" target=\"_blank\">&#8220;Oracle Software Delivery Cloud&#8221;<\/a> sayfas\u0131ndan \u00fcr\u00fcn\u00fc indirebiliriz. Oracle Media Pack aramas\u0131ndan Product type olarak Oracle Fusion Middleware ve ilgili i\u015fletim sistemini se\u00e7iyoruz. \u00dcr\u00fcn paketi olarak Oracle GoldenGate on Oracle Media Pack for Linux x86-64 olarak se\u00e7iyoruz. Daha sonra gelen listeden i\u015fletim sistemimizin tipine ve kulland\u0131\u011f\u0131m\u0131z veritaban\u0131 versiyonuna g\u00f6re se\u00e7im yapabiliriz<\/span><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"><br \/>\n<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130\u015fletim sistemi kurulumu i\u00e7in <a title=\"Oracle Enterprise Linux 6.x Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=228\">&#8220;Oracle Enterprise Linux Kurulumu&#8221;<\/a> makalemizi kullanabilirsiniz.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131 kurulumu i\u00e7in tercihimize g\u00f6re; <\/span><\/p>\n<p style=\"text-align: justify;\"><a title=\"Oracle Grid Infrastructure ile Single Instance (Standalone) Veritaban\u0131 Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=520\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle Grid Infrastructure ile Single Instance (Standalone) Veritaban\u0131 Kurulumu<\/span><\/a><\/p>\n<p style=\"text-align: justify;\"><a title=\"Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle Veritaban\u0131 Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=1565\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle Veritaban\u0131 Kurulumu<\/span><\/a><\/p>\n<p style=\"text-align: justify;\"><a title=\"Oracle Enterprise Linux \u0130\u015fletim Sisteminde Oracle Real Application Cluster (Rac) Veritaban\u0131 Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=1679\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle Enterprise Linux \u0130\u015fletim Sisteminde Oracle Real Application Cluster (Rac) Veritaban\u0131 Kurulumu<\/span><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">makalelerimizi kullanabilirsiniz.<\/span><\/p>\n<p style=\"text-align: justify;\">1. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130\u015fletim Sistemi ve Veritaban\u0131 kurulum i\u015flemlerimizi tamamlad\u0131ktan sonra &#8220;Oracle GoldenGate&#8221; kurulumuna ba\u015flayabiliriz. Kuruluma ba\u015flayabilmek i\u00e7in \u00f6ncelikle &#8220;Oracle GoldenGate&#8221; yaz\u0131l\u0131m\u0131n\u0131n kullanaca\u011f\u0131 dizinleri her iki sunucumuzda yarat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- A\u015fa\u011f\u0131daki i\u015flemleri \"oracle\" kullan\u0131c\u0131s\u0131 ile yap\u0131yoruz.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ mkdir \/u01\/app\/goldengate\r\n$ mkdir \/u01\/app\/goldengate\/discard\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\">2. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Kuruluma ge\u00e7ebilmemiz i\u00e7in ftp yada ba\u015fka bir y\u00f6ntem ile kurulum dosyalar\u0131m\u0131z\u0131 her iki sunucumuzda olu\u015fturdu\u011fumuz \u201c\/u01\/orainstall\/gg\u201d dizini alt\u0131na at\u0131yoruz. E\u011fer sunucumuzda ftp server \u00f6zelli\u011fi aktif edilmemi\u015fse <a title=\"Linux \u0130\u015fletim Sistemlerinde HTTP ve FTP Server Yap\u0131land\u0131rmas\u0131\" href=\"http:\/\/www.koraykey.com\/?p=361\">\u201cLinux \u0130\u015fletim Sistemlerinde FTP Server Yap\u0131land\u0131rmas\u0131\u201d <\/a>makalemizden faydalanarak gerekli ayarlar\u0131 yapabiliriz.<\/span><\/p>\n<p style=\"text-align: justify;\">3. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Kurulum i\u00e7in \u201c\/u01\/app\/goldengate\u201d alt\u0131na koydu\u011fumuz kurulum dosyalar\u0131m\u0131z\u0131\u00a0 her iki sunucumuzda a\u00e7\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ cd \/u01\/app\/goldengate<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ unzip V34339-01.zip\r\n$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar\r\n\r\n-- Diskimizde yer kaplamamas\u0131 i\u00e7in kurulum dosyalar\u0131n\u0131 silebiliriz.\r\n$ rm V34339-01.zip\r\n$ rm fbo_ggs_Linux_x64_ora11g_64bit.tar\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\">4. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucumuzda bulunan &#8220;oracle&#8221; kullan\u0131c\u0131s\u0131na ait &#8220;.bash_profile&#8221; dosyam\u0131z\u0131 her iki sunucumuzda a\u015fa\u011f\u0131daki gibi d\u00fczenliyoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\"># Oracle bash_profile Environment Settings<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">TMP=\/tmp; export TMP<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">TMPDIR=$TMP; export TMPDIR<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_HOSTNAME=koraykey-db1.localdomain; export ORACLE_HOSTNAME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">DB_HOME=$ORACLE_BASE\/product\/11.2.0.3\/db; export DB_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_HOME=$DB_HOME; export ORACLE_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_SID=orcl; export ORACLE_SID<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_HOME_LISTNER=$ORACLE_HOME export ORACLE_HOME_LISTNER<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GG_HOME=\/u01\/app\/goldengate export GG_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_TERM=xterm; export ORACLE_TERM<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">BASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">PATH=$ORACLE_HOME\/bin:$GG_HOME:$ORACLE_HOME\/OPatch:$PATH:$BASE_PATH; export PATH<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib:$ORACLE_HOME\/lib:$GG_HOME; export LD_LIBRARY_PATH<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">if [ $USER = \"oracle\" ]; then<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  if [ $SHELL = \"\/bin\/ksh\" ]; then<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    ulimit -p 16384<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    ulimit -n 65536<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  else<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    ulimit -u 16384 -n 65536<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  fi<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">fi<\/span><\/pre>\n<p style=\"text-align: justify;\">5. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">De\u011fi\u015fkenlerimizi hemen ge\u00e7erli olabilmesi i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ export PATH=$PATH:\/u01\/app\/goldengate<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ export LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/u01\/app\/goldengate<\/span><\/pre>\n<p style=\"text-align: justify;\">6. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate kurulum i\u015flemine ba\u015flayabiliriz. A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 s\u0131ras\u0131yla her iki sunucumuzda yapaca\u011f\u0131z.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ cd \/u01\/app\/goldengate<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ .\/ggsci<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle GoldenGate Command Interpreter for Oracle<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (C) 1995, 2012, Oracle and\/or its affiliates. All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 1&gt; CREATE SUBDIRS<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Creating subdirectories under current directory \/u01\/app\/goldengate<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Parameter files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirprm: created<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Report files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirrpt: created<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Checkpoint files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirchk: created<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Process status files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirpcs: created<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL script files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirsql: created<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database definitions files\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirdef: created<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Extract data files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirdat: created<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Temporary files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirtmp: created<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Stdout files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/goldengate\/dirout: created<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 2&gt; exit\r\n\r\nGacle GoldenGate taraf\u0131ndan kullan\u0131lacak \"Extract\" ve \"Replicat\" prosesleri\r\ni\u00e7in bir veritaban\u0131 kullanic\u0131s\u0131 olu\u015fturup, haklar\u0131n\u0131 vermeliyiz. \u00d6ncelikle\r\nolu\u015fturaca\u011f\u0131m\u0131z kullan\u0131c\u0131m\u0131z\u0131n kullanmas\u0131 i\u00e7in bir \"tablespace\" ard\u0131nan\r\n\"user\" yarat\u0131yoruz. Sonras\u0131nda yaratm\u0131\u015f oldu\u011fumuz kullanc\u0131ya gerekli haklar\u0131\r\nveriyoruz.\r\n\r\n$ sqlplus \/ as sysdba \r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 02:40:28 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; <\/span><span style=\"font-family: courier new,courier; font-size: 10px;\">create tablespace goldengate datafile size 256m autoextend on next 10m maxsize unlimited;\r\n<\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">Tablespace created.\r\n\r\n-- Not: Veritaban\u0131nda OMF (Oracle Managed File) kulland\u0131\u011f\u0131m i\u00e7in tablespace\r\nyolunu vermedim.\r\n\r\nSQL&gt; create user goldengate identified by goldengate default tablespace goldengate;\r\nUser created.\r\n\r\nSQL&gt; grant connect,resource to goldengate;\r\nGrant succeeded.\r\n\r\nSQL&gt; grant select any dictionary, select any table to goldengate;\r\nGrant succeeded.\r\n\r\nSQL&gt; grant create table to goldengate;\r\nGrant succeeded.\r\n\r\nSQL&gt; grant flashback any table to goldengate;\r\nGrant succeeded.\r\n\r\nSQL&gt; grant execute on dbms_flashback to goldengate;\r\nGrant succeeded.\r\n\r\nSQL&gt; grant execute on utl_file to goldengate;\r\nGrant succeeded\r\n\r\nSQL&gt; grant alter any table to goldengate;\r\nGrant succeeded\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\">7. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle veritaban\u0131 taraf\u0131nda yapmam\u0131z gereken i\u015flemlerden biri veritabanlar\u0131m\u0131z\u0131n &#8220;Archivelog&#8221; modunun a\u00e7\u0131k oldu\u011funu kontrol etmemiz olacakt\u0131r. E\u011fer a\u00e7\u0131k de\u011filse a\u015fa\u011f\u0131daki i\u015flemlerle a\u00e7abiliriz.\u00a0&#8220;Archivelog&#8221; mod her iki sunucumuzda a\u00e7\u0131k olmal\u0131d\u0131r.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 01:57:21 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select log_mode from v$database;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">LOG_MODE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ARCHIVELOG<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">E\u011fer yukar\u0131daki gibi archive log modumuz a\u00e7\u0131k de\u011filse (NOARCHIVELOG) a\u00e7mak i\u00e7in<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izlemeliyiz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Veritaban\u0131m\u0131z\u0131 tutarl\u0131 bir \u015fekilde kapat\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; shutdown immediate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database closed.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database dismounted.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE instance shut down.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Veritaban\u0131m\u0131z\u0131 \"mount\" modda a\u00e7\u0131yoruz.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\r\nSQL&gt; startup mount;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE instance started.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Total System Global Area 1068937216 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Fixed Size                  2235208 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Variable Size             641729720 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database Buffers          419430400 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Redo Buffers                5541888 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database mounted.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Veritaban\u0131m\u0131z\u0131 \"ARCHIVELOG\" moda al\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database archivelog;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Veritaban\u0131m\u0131z\u0131 a\u00e7\u0131yoruz.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\r\nSQL&gt; alter database open;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database altered.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Tekrar sorgulad\u0131\u011f\u0131m\u0131zda \"ARCHIVELOG\" modda oldu\u011funu g\u00f6r\u00fcyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select log_mode from v$database;   <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">LOG_MODE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ARCHIVELOG<\/span><\/pre>\n<p style=\"text-align: justify;\">8. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131nda da &#8220;Supplemental Logging&#8221; \u00f6zelli\u011fini her iki sunucumuzda aktif ederek veritaban\u0131n\u0131n ek olarak log \u00e7\u0131kartmas\u0131n\u0131 sa\u011flayaca\u011f\u0131z.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 02:22:50 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database add supplemental log data (all) columns;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database altered.<\/span><\/pre>\n<p style=\"text-align: justify;\">9. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131nda da &#8220;Supplemental Logging&#8221; \u00f6zelli\u011fini her iki sunucumuzda t\u00fcm tablolarda aktif ettik e\u011fer sadece belli tablolarda bu i\u015flemi yapacaksak &#8220;GoldenGate&#8221; komut sat\u0131r\u0131ndan &#8220;ADD TRANDATA&#8221; komutu ile tablo ismi belirleyerek ekleyebiliriz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Oracle GoldenGate y\u00f6neticisine ba\u011flan\u0131rken a\u015fa\u011f\u0131daki gibi bir hata al\u0131rsak<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 1&gt; DBLOGIN USERID goldengate, PASSWORD goldengate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Aborted (core dumped)<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">gibi bir hata al\u0131rsak a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izlemeliyiz.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">\u0130\u015fletim Sistemi seviyesinde \"ggMessage.dat\" dosyas\u0131na okuma hakk\u0131 veriyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ cd $GG_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ chmod 644 ggMessage.dat<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ ls -l ggMessage.dat<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-rw-r--r-- 1 oracle oinstall 1280336 Aug 24  2012 ggMessage.dat<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Ard\u0131ndan a\u015fa\u011f\u0131daki gibi oturum a\u00e7may\u0131 denedi\u011fimizde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6rece\u011fiz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ cd $GG_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ ggsci<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle GoldenGate Command Interpreter for Oracle<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (C) 1995, 2012, Oracle and\/or its affiliates. All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 1&gt; DBLOGIN USERID goldengate, PASSWORD goldengate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Successfully logged into database.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 2&gt; <\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">\u015eimdi \"ADD TRANDATA\" komutu ile  \"ADD TRANDATA\" komutu ile tablo baz\u0131nda\r\nayarlama yapal\u0131m.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 2&gt; ADD TRANDATA KORAYKEY.TEST<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Logging of supplemental redo data enabled for table KORAYKEY.TEST<\/span><\/pre>\n<p style=\"text-align: justify;\">10. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131z Oracle 10g ise\u00a0Oracle GoldenGate ile DDL (Data Definition Language) i\u015flemleri (create, alter, drop, truncate) yapacaksak her iki sunucumuzda a\u015fa\u011f\u0131daki i\u015flemleri yapmam\u0131z gerekiyor. E\u011fer veritaban\u0131m\u0131z Oracle 11g ise \u00c7\u00f6p Kutusu (recycle bin) a\u00e7\u0131k olabilir.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- DDL i\u015flemleri i\u00e7in Oracle 10g Veritabanlar\u0131nda \u00c7\u00f6p Kutusu (recycle bin)\r\n\u00f6zelli\u011fi kapal\u0131 olmal\u0131d\u0131r.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; ALTER SYSTEM SET recyclebin = OFF SCOPE = SPFILE;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Veritaban\u0131m\u0131z\u0131 kapat\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; shu immediate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database closed.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database dismounted.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE instance shut down.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Veritaban\u0131m\u0131z\u0131 yeniden ba\u015flat\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; startup;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE instance started.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Total System Global Area 1068937216 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Fixed Size                  2235208 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Variable Size             650118328 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database Buffers          411041792 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Redo Buffers                5541888 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database mounted.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database opened.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Kontrol etti\u011fimizde \"OFF\" durumda oldu\u011funu g\u00f6r\u00fcyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; show parameter recycle;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">NAME                                 TYPE        VALUE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------------------------------ ----------- ------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">buffer_pool_recycle                  string<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">db_recycle_cache_size                big integer 0<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">recyclebin                           string      OFF<\/span><\/pre>\n<p style=\"text-align: justify;\">11. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131zda Oracle GoldenGate ile DDL (Data Definition Language) i\u015flemleri i\u00e7in gerekli scriptlerimizi her iki sunucumuzda \u00e7al\u0131\u015ft\u0131r\u0131yoruz. Scriptlerimiz \u00e7al\u0131\u015f\u0131rken bizden \u015fema ismimizi soracakt\u0131r. \u00d6nceki ad\u0131mlarda yaratt\u0131\u011f\u0131m\u0131z \u015fema ismini (goldengate) burada yaz\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ cd $GG_HOME<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 04:17:18 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\"><strong>Birinci scriptimizi \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/strong><\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; @marker_setup.sql;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Marker setup script<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">You will be prompted for the name of a schema for the Oracle \r\nGoldenGate database objects.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">NOTE: The schema must be created prior to running this script.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">NOTE: Stop all DDL replication before starting this installation.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Enter Oracle GoldenGate schema name:goldengate<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Marker setup table script complete, running verification script...<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Please enter the name of a schema for the GoldenGate database objects:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Setting schema name to GOLDENGATE<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">MARKER TABLE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-------------------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">OK<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">MARKER SEQUENCE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-------------------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">OK<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Script complete.\r\n\r\n-- <\/span><span style=\"font-family: courier new,courier; font-size: 12px;\"><strong>\u0130kinci Scriptimizi \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/strong>\r\n\r\nSQL&gt; @ddl_setup.sql;\r\n\r\nOracle GoldenGate DDL Replication setup script\r\n\r\nVerifying that current user has privileges to install DDL Replication...\r\n\r\nYou will be prompted for the name of a schema for the Oracle GoldenGate\r\ndatabase objects.\r\nNOTE: For an Oracle 10g source, the system recycle bin must be disabled.\r\nFor Oracle 11g and later, it can be enabled.\r\nNOTE: The schema must be created prior to running this script.\r\nNOTE: Stop all DDL replication before starting this installation.\r\n\r\nEnter Oracle GoldenGate schema name:goldengate\r\n\r\nWorking, please wait ...\r\nSpooling to file ddl_setup_spool.txt\r\n\r\nChecking for sessions that are holding locks on Oracle Golden Gate \r\nmetadata tables ...\r\n\r\nCheck complete.\r\n\r\nUsing GOLDENGATE as a Oracle GoldenGate schema name.\r\n\r\nWorking, please wait ...\r\n\r\nDDL replication setup script complete, running verification script...\r\nPlease enter the name of a schema for the GoldenGate database objects:\r\nSetting schema name to GOLDENGATE\r\n\r\nCLEAR_TRACE STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nCREATE_TRACE STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nTRACE_PUT_LINE STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nINITIAL_SETUP STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nDDLVERSIONSPECIFIC PACKAGE STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nDDLREPLICATION PACKAGE STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nDDLREPLICATION PACKAGE BODY STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nDDL IGNORE TABLE\r\n-----------------------------------\r\nOK\r\n\r\nDDL IGNORE LOG TABLE\r\n-----------------------------------\r\nOK\r\n\r\nDDLAUX\u00a0 PACKAGE STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nDDLAUX PACKAGE BODY STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nSYS.DDLCTXINFO\u00a0 PACKAGE STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nSYS.DDLCTXINFO\u00a0 PACKAGE BODY STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nDDL HISTORY TABLE\r\n-----------------------------------\r\nOK\r\n\r\nDDL HISTORY TABLE(1)\r\n-----------------------------------\r\nOK\r\n\r\nDDL DUMP TABLES\r\n-----------------------------------\r\nOK\r\n\r\nDDL DUMP COLUMNS\r\n-----------------------------------\r\nOK\r\n\r\nDDL DUMP LOG GROUPS\r\n-----------------------------------\r\nOK\r\n\r\nDDL DUMP PARTITIONS\r\n-----------------------------------\r\nOK\r\n\r\nDDL DUMP PRIMARY KEYS\r\n-----------------------------------\r\nOK\r\n\r\nDDL SEQUENCE\r\n-----------------------------------\r\nOK\r\n\r\nGGS_TEMP_COLS\r\n-----------------------------------\r\nOK\r\n\r\nGGS_TEMP_UK\r\n-----------------------------------\r\nOK\r\n\r\nDDL TRIGGER CODE STATUS:\r\n\r\nLine\/pos\u00a0\u00a0 Error\r\n---------- ------------------------\r\nNo errors\u00a0 No errors\r\n\r\nDDL TRIGGER INSTALL STATUS\r\n-----------------------------------\r\nOK\r\n\r\nDDL TRIGGER RUNNING STATUS\r\n-----------------------------------\r\nENABLED\r\n\r\nSTAYMETADATA IN TRIGGER\r\n-----------------------------------\r\nOFF\r\n\r\nDDL TRIGGER SQL TRACING\r\n-----------------------------------\r\n0\r\n\r\nDDL TRIGGER TRACE LEVEL\r\n-----------------------------------\r\n0\r\n\r\nLOCATION OF DDL TRACE FILE\r\n-----------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl\/trace\/ggs_ddl_trace.log\r\n\r\nAnalyzing installation status...\r\n\r\nSTATUS OF DDL REPLICATION\r\n-----------------------------------\r\nSUCCESSFUL installation of DDL Replication software components\r\n\r\nScript complete.\r\n\r\n-- <strong>\u00dc\u00e7\u00fcnc\u00fc Scriptimizi \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/strong>\r\n\r\nSQL&gt; @role_setup.sql;\r\n\r\nGGS Role setup script\r\n\r\nThis script will drop and recreate the role GGS_GGSUSER_ROLE\r\nTo use a different role name, quit this script and then edit the params.sql\r\nscript to change the gg_role parameter to the preferred name.\r\n(Do not run the script.)\r\n\r\nYou will be prompted for the name of a schema for the GoldenGate database objects.\r\nNOTE: The schema must be created prior to running this script.\r\nNOTE: Stop all DDL replication before starting this installation.\r\n\r\nEnter GoldenGate schema name:goldengate\r\nWrote file role_setup_set.txt\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nRole setup script complete\r\n\r\nGrant this role to each user assigned to the Extract, GGSCI,\r\nand Manager processes, by using the following SQL command:\r\n\r\nGRANT GGS_GGSUSER_ROLE TO &lt;loggedUser&gt;\r\n\r\nwhere &lt;loggedUser&gt; is the user assigned to the GoldenGate processes.\r\n\r\n-- <strong>D\u00f6rd\u00fcnc\u00fc Scriptimizi \u00e7al\u0131\u015ft\u0131r\u0131yoruz.\r\n\r\n<\/strong><\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant GGS_GGSUSER_ROLE to goldengate;\r\n<\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">Grant succeeded.\r\n\r\nSQL&gt; @ddl_enable.sql;\r\nTrigger altered.\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\">12. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucumuzda &#8220;Oracle GoldenGate&#8221; ile ilgili ayarlar\u0131 tamamlad\u0131k \u015fimdi basit bir replikasyon testi ger\u00e7ekle\u015ftirerek ayarlar\u0131m\u0131z\u0131 kontrol edelim. Bu i\u015flem i\u00e7in \u00f6ncelikle kaynak ve hedef veritabanlar\u0131m\u0131zda farkl\u0131 isimlerle birer kullan\u0131c\u0131 olu\u015fturup gerekli haklar\u0131 verelim.<br \/>\n<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Kaynak (Veri G\u00f6nderen) Veritaban\u0131nda\r\n\r\n$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 04:56:22 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; <\/span><span style=\"font-family: courier new,courier; font-size: 10px;\">create user kaynak identified by kyn123 default tablespace users temporary tablespace temp;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant connect,resource,unlimited tablespace to kaynak;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant select any dictionary, select any table to kaynak;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant create table to kaynak;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant flashback any table to kaynak;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Hedef (Veri Alan) Veritaban\u0131nda<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 04:57:35 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; <\/span><span style=\"font-family: courier new,courier; font-size: 10px;\">create user hedef identified by hdf123 default tablespace users temporary tablespace temp;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant connect,resource,unlimited tablespace to hedef;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant select any dictionary, select any table to hedef;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant create table to hedef;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; grant flashback any table to hedef;<\/span><\/pre>\n<p style=\"text-align: justify;\">13. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate &#8220;Extract&#8221; process&#8217;ni kullanarak replikasyonumuza ba\u015flayal\u0131m. Her iki sunucuda bu servisimizi ba\u015flat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- A\u015fa\u011f\u0131daki i\u015flemleri her iki sunucumuzda yaparak manager servisini\r\nba\u015flat\u0131yoruz.\r\n\r\n$ cd $GG_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ ggsci<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle GoldenGate Command Interpreter for Oracle<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (C) 1995, 2012, Oracle and\/or its affiliates. All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 1&gt; edit params mgr<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">A\u00e7\u0131lan VI Edit\u00f6r ekran\u0131nda dosyam\u0131z\u0131n i\u00e7eri\u011fine<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">PORT 7809<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">yazarak kaydedip \u00e7\u0131k\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 2&gt; start manager<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Manager started.\r\n\r\nGGSCI (koraykey-db1.localdomain) 3&gt; info all\r\n\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\n\r\n-- Kaynak sunucumuzdan \"extract\" i\u015flemine ba\u015fl\u0131yoruz. Buradaki i\u015flemler\r\nsadece kaynak sunucumuzda yap\u0131lacakt\u0131r.\r\nGGSCI (koraykey-db1.localdomain) 4&gt; add extract ext1, tranlog, begin now\r\nEXTRACT added.\r\n\r\n-- Extract i\u015flemi olu\u015ftuktan sonra yakalanan i\u015flemleri yerelde bir alana\r\nyazmas\u0131 i\u00e7in Trail servisimizi ayarl\u0131yoruz. Burada dizin ismi 2 karekteri\r\nge\u00e7memelidir.\r\n<\/span><span style=\"font-family: courier new,courier; font-size: 10px;\">GGSCI (koraykey-db1.localdomain) 5&gt; ADD EXTTRAIL \/u01\/app\/goldengate\/dirdat\/ex, EXTRACT EXT1\r\nEXTTRAIL added.\r\n\r\nGGSCI (koraykey-db1.localdomain) 6&gt; ADD RMTTRAIL \/u01\/app\/goldengate\/dirdat\/lt, EXTRACT EXT1\r\nRMTTRAIL added.\r\n<\/span><span style=\"font-size: 10px;\">\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 7&gt; edit params ext1\r\n\r\n-- Parametrelerimizi d\u00fczenliyoruz. Burada a\u00e7\u0131lan VI Edit\u00f6r ekran\u0131nda\r\na\u015fa\u011f\u0131daki de\u011fi\u015fkenleri giriyoruz.\r\n<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SETENV (ORACLE_HOME = \"\/u01\/app\/oracle\/product\/11.2.0.3\/db\")<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SETENV (ORACLE_SID = \"orcl\")<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">EXTRACT ext1<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">USERID goldengate, PASSWORD goldengate<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">--EXTTRAIL \/u01\/app\/goldengate\/dirdat\/ex<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">RMTHOST KORAYKEY-DB2, MGRPORT 7809<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ddl include mapped objname kaynak.*;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">RMTTRAIL \/u01\/app\/goldengate\/dirdat\/lt<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">TABLE kaynak.*;\r\n\r\n-- Servislerimizin durumunu kontrol ediyoruz.\r\n<\/span>\r\n<\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 8&gt; info all\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\r\nEXTRACT\u00a0\u00a0\u00a0\u00a0 STOPPED\u00a0\u00a0\u00a0\u00a0 EXT1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:08:51\r\n\r\n-- Kaynak sunucumuzda yap\u0131land\u0131rmam\u0131z bitti. \u015eimdi hedef taraf\u0131 i\u00e7in \r\ntan\u0131mlamalar\u0131m\u0131z\u0131 yapal\u0131m.\r\n-- A\u015fa\u011f\u0131daki i\u015flemleri sadece hedef sunucumuzda yap\u0131yoruz.\r\n-- Hedef taraftaki trail dosyalar\u0131n\u0131 okuyup veritaban\u0131na yazacak\r\nservisimizi yap\u0131land\u0131r\u0131yoruz.\r\n\r\n$ cd $GG_HOME\r\n$ ggsci\r\n\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO\r\nLinux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21\r\n\r\nCopyright (C) 1995, 2012, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nOracle GoldenGate dizini i\u00e7erisinde \"GLOBAL\" dosyam\u0131z\u0131 a\u00e7arak i\u00e7erisine\r\nt\u00fcm replikasyon bilgilerini tutan \"CHECKPOINTTABLE\" tablomuzun ismini\r\nyazabilir. Bu ad\u0131m zorunlu de\u011fildir. \u0130stenildi\u011fi takdirde bir sonraki\r\nad\u0131mla yap\u0131labilir.\r\n\r\nGGSCI (koraykey-db2.localdomain) 1&gt; edit params .\/GLOBAL\r\n\r\n-- A\u00e7\u0131lan VI Edit\u00f6r ekran\u0131nda a\u015fa\u011f\u0131daki parametreleri giriyoruz.\r\n\r\nGGSCHEMA goldengate\r\nCHECKPOINTTABLE goldengate.checkpoint\r\n\r\n-- Ayn\u0131 i\u015flemi komutlarla yapabiliriz.\r\nGoldenGate sistemimizde oturum a\u00e7\u0131yoruz.\r\n\r\nGGSCI (koraykey-db2.localdomain) 2&gt; dblogin userid goldengate\r\nPassword: \r\nSuccessfully logged into database.\r\n\r\nGGSCI (koraykey-db2.localdomain) 3&gt; add checkpointtable goldengate.checkpoint\r\n\r\nSuccessfully created checkpoint table goldengate.checkpoint.\r\n\r\nGGSCI (koraykey-db2.localdomain) 4&gt; add replicat rep1, \r\nexttrail \/u01\/app\/goldengate\/dirdat\/lt,checkpointtable goldengate.checkpoint\r\nREPLICAT added\r\n(Komut yan yana olmal\u0131d\u0131r)\r\n\r\n-- Oracle GoldenGate \"Replicat\" servisinin parametre ayalar\u0131n\u0131 yap\u0131yoruz ve\r\ndiscard dizinine 10 mb'l\u0131k dosyalar halinde yazaca\u011f\u0131n\u0131 belirtiyoruz.\r\n\r\nGGSCI (koraykey-db2.localdomain) 5&gt; edit params rep1\r\n\r\n-- A\u00e7\u0131lan VI Edit\u00f6r ekran\u0131nda a\u015fa\u011f\u0131daki parametreleri giriyoruz.\r\n\r\nSETENV (ORACLE_HOME = \"\/u01\/app\/oracle\/product\/11.2.0.3\/db\")\r\nSETENV (ORACLE_SID = \"orcl\")\r\nREPLICAT rep1\r\nASSUMETARGETDEFS\r\nuserid goldengate, password goldengate\r\ndiscardfile \/u01\/app\/goldengate\/discard\/rep1.txt, append, megabytes 10\r\nDDL\r\nmap kaynak.*, target hedef.*;\r\n\r\n-- Kaynak tarafta \"extract\" servisini ba\u015flat\u0131yoruz.\r\n\r\nGGSCI (koraykey-db1.localdomain) 9&gt; start extract ext1\r\nSending START request to MANAGER ...\r\nEXTRACT EXT1 starting\r\n\r\nGGSCI (koraykey-db1.localdomain) 10&gt; info all\r\n\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\r\nEXTRACT\u00a0\u00a0\u00a0\u00a0 RUNNING\u00a0\u00a0\u00a0\u00a0 EXT1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:01\r\n\r\nHedef tarafta \"replicat\" servisini ba\u015flat\u0131yoruz.\r\n\r\nGGSCI (koraykey-db2.localdomain) 6&gt; start replicat rep1\r\n\r\nSending START request to MANAGER ...\r\nREPLICAT REP1 starting\r\n\r\nGGSCI (koraykey-db2.localdomain) 7&gt; info all\r\n\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\r\nREPLICAT\u00a0\u00a0\u00a0 RUNNING\u00a0\u00a0\u00a0\u00a0 REP1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:06\r\n\r\nServislerimizin durumu a\u015fa\u011f\u0131daki komut ile kontrol edebiliriz.\r\nKaynak sunucumuzda \"extract\" servisinin durumunu sorgulamak i\u00e7in\r\na\u015fa\u011f\u0131daki komutu kullanabiliriz.\r\n\r\nGGSCI (koraykey-db1.localdomain) 11&gt; view report ext1\r\n\r\n***********************************************************************\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle GoldenGate Capture for Oracle\r\n\u00a0Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO\r\n\u00a0\u00a0 Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:32:12\r\n\r\nCopyright (C) 1995, 2012, Oracle and\/or its affiliates. All rights reserved.\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Starting at 2013-04-16 05:31:48\r\n***********************************************************************\r\n\r\nOperating System Version:\r\nLinux\r\nVersion #1 SMP Thu Apr 4 03:49:00 PDT 2013\r\nNode: koraykey-db1.localdomain\r\nMachine: x86_64\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft limit\u00a0\u00a0 hard limit\r\nAddress Space Size\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nHeap Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nFile Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nCPU Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\n\r\nProcess id: 28427\r\n.\r\n.\r\n.\r\n\r\n-- Hedef sunucumuzda \"Replicat\" servisinin durumunu sorgulamak i\u00e7in\r\na\u015fa\u011f\u0131daki komutu kullanabiliriz.\r\n\r\nGGSCI (koraykey-db2.localdomain) 8&gt; view report rep1\r\n\r\n***********************************************************************\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle GoldenGate Delivery for Oracle\r\n\u00a0Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO\r\n\u00a0\u00a0 Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:37:31\r\n\r\nCopyright (C) 1995, 2012, Oracle and\/or its affiliates. All rights reserved.\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Starting at 2013-04-16 05:32:17\r\n***********************************************************************\r\n\r\nOperating System Version:\r\nLinux\r\nVersion #1 SMP Thu Apr 4 03:49:00 PDT 2013,\r\nNode: koraykey-db2.localdomain\r\nMachine: x86_64\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft limit\u00a0\u00a0 hard limit\r\nAddress Space Size\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nHeap Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nFile Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nCPU Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\n\r\nProcess id: 27717\r\n.\r\n.\r\n.\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\">14. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate yap\u0131land\u0131rmam\u0131z\u0131n do\u011fru \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 kontrol edebilmek i\u00e7in baz\u0131 testlerimizi yapal\u0131m. \u00d6ncelikle kaynak sunucumuzda bir tablo yarat\u0131p i\u00e7ine bir ka\u00e7 sat\u0131r bilgi giriyoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 16:08:25 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; conn kaynak\/kyn123;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; create table gldgate (DURUM varchar2(20));<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Table created.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; insert into gldgate values('GOLDENGATE-TEST');<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">1 row created.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; insert into gldgate values('GOLDENGATE-TEST1');<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">1 row created.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; insert into gldgate values('GOLDENGATE-TEST2');<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">1 row created.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; commit;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Commit complete.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select * from gldgate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">DURUM<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">--------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GOLDENGATE-TEST<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GOLDENGATE-TEST1<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GOLDENGATE-TEST2<\/span><\/pre>\n<p style=\"text-align: justify;\">15. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzda kaynak sunucu \u00fczerinde yaratt\u0131\u011f\u0131m\u0131z tablo ve bilgilerin gelip gelmedi\u011fini kontrol ediyoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 16:17:33 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; conn hedef\/hdf123;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select * from gldgate;\r\nDURUM\r\n--------------------\r\nGOLDENGATE-TEST\r\nGOLDENGATE-TEST1\r\nGOLDENGATE-TEST2<\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">\r\n\r\n-- G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi hedef sunucumuzda tablomuz ve bilgilerimiz replikasyon olmu\u015f\r\ndurumdad\u0131r.\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\">16. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate servislerimizde bir de\u011fi\u015fiklik olmas\u0131 durumunda veya\u00a0 &#8220;info all&#8221; komutu ile sorgulad\u0131\u011f\u0131m\u0131zda servis durumunu &#8220;ABENDING&#8221; g\u00f6r\u00fcyorsak a\u015fa\u011f\u0131daki i\u015flemlerle \u00e7\u00f6zebiliriz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ cd GG_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ ggsci<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db2.localdomain) 1&gt; info all<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Program     Status      Group       Lag at Chkpt  Time Since Chkpt<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">MANAGER     RUNNING                                           <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">REPLICAT    ABENDING     REP1        00:00:00      00:00:05<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Servisimiz ABENDING durumda<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db2.localdomain) 2&gt;  stop replicat rep1<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Sending STOP request to REPLICAT REP1 ...<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Request processed.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db2.localdomain) 3&gt; alter rep1 begin now<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">REPLICAT altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db2.localdomain) 4&gt;  start replicat rep1<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Sending START request to MANAGER ...<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">REPLICAT REP1 starting<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db2.localdomain) 5&gt; info all<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Program     Status      Group       Lag at Chkpt  Time Since Chkpt<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">MANAGER     RUNNING                                           <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">REPLICAT    RUNNING     REP1        00:00:00      00:00:08<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Servisimiz \u00e7al\u0131\u015f\u0131r durumda.<\/span><\/pre>\n<p style=\"text-align: justify;\">17. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate istatisliklerini a\u015fa\u011f\u0131daki komut ile sorgulayabiliriz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ cd $GG_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ ggsci<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle GoldenGate Command Interpreter for Oracle<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (C) 1995, 2012, Oracle and\/or its affiliates. All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">GGSCI (koraykey-db1.localdomain) 1&gt; stats *<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Sending STATS request to EXTRACT EXT1 ...<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">No active extraction maps<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">DDL replication statistics (for all trails):<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">*** Total statistics since extract started     ***<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        Operations                                         1.00<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        Mapped operations                                  1.00<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        Unmapped operations                                0.00<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        Other operations                                   0.00<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        Excluded operations                                0.00<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">.\r\n.\r\n.<\/span><\/pre>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle GoldenGate sunucumuz haz\u0131r art\u0131k kullanabiliriz. <\/span><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu makalemizde &#8220;Oracle Enterprise Linux 6.4&#8221; \u0130\u015fletim Sistemi \u00fczerinde Oracle GoldenGate Kurulum, Yap\u0131land\u0131rma ve Y\u00f6netimini inceledik.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bir sonraki makalemizde g\u00f6r\u00fc\u015fmek \u00fczere&#8230;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bu makalemizde Oracle&#8217;\u0131n &#8220;Fussion Middleware&#8221; \u00fcr\u00fcn grubuna dahil etti\u011fi disaster \u00e7\u00f6z\u00fcm\u00fc, kritik sistemlerindeki s\u00fcreklili\u011fi sa\u011flamak i\u00e7in kullan\u0131lan &#8220;Oracle GoldenGate&#8221; \u00fcr\u00fcn\u00fcn\u00fc inceleyce\u011fiz. Kurulum i\u015flemlerimizi &#8220;Oracle Enterprise Linux 6.4&#8221; \u0130\u015fletim sistemi \u00fczerinde yapaca\u011f\u0131z. Oracle GoldenGate Nedir? Oracle \u2018\u0131n Fussion Middleware \u00fcr\u00fcn grubuna &hellip; <a href=\"https:\/\/www.koraykey.com\/?p=2821\">Okumaya devam et <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[250,21,290,20,19,251,380,379,252,249,447],"class_list":["post-2821","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-goldengate-kurulumu","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-koray-gunduz","tag-koraykey","tag-linux-oracle-goldengate-kurulumu","tag-oracle-golden-gate","tag-oracle-goldengate","tag-oracle-goldengate-11g-kurulumu","tag-oracle-goldengate-kurulumu","tag-oracle-goldengate-nedir"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/2821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2821"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/2821\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}