<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Abhii on Medium]]></title>
        <description><![CDATA[Stories by Abhii on Medium]]></description>
        <link>https://medium.com/@abhii5?source=rss-9b3dc9345867------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*igL-aLLlsd5Wdwl1</url>
            <title>Stories by Abhii on Medium</title>
            <link>https://medium.com/@abhii5?source=rss-9b3dc9345867------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 23:19:48 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@abhii5/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Oracle GoldenGate Supported RDBMS to GCP Big Queries]]></title>
            <link>https://abhii5.medium.com/oracle-goldengate-supported-rdbms-to-gcp-big-queries-44afd49e75f8?source=rss-9b3dc9345867------2</link>
            <guid isPermaLink="false">https://medium.com/p/44afd49e75f8</guid>
            <category><![CDATA[migration]]></category>
            <category><![CDATA[golden-gate]]></category>
            <category><![CDATA[big-data]]></category>
            <category><![CDATA[google-bigquery]]></category>
            <category><![CDATA[oracle]]></category>
            <dc:creator><![CDATA[Abhii]]></dc:creator>
            <pubDate>Fri, 20 Nov 2020 21:33:55 GMT</pubDate>
            <atom:updated>2020-12-11T04:02:55.612Z</atom:updated>
            <content:encoded><![CDATA[<h3>Oracle GoldenGate Supported RDBMS to GCP BigQuery</h3><p>In this poc source database will be MySQL and target will be GCP BigQuery. We will use Oracle GoldenGate for MySQL on source and on target server Oracle GoldenGate Big Data → BigQuery Handler.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/990/1*ZwucoqGQn_HdFtfg_YeSUA.png" /></figure><p>Note:- In my case both source and target server are on same server.</p><p>Below are Perquisite need to be done on source server where oracle or MySQL DB is running.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/672/1*nTVJ_Qx_uEKtada906cAgg.png" /></figure><p>Below are Perquisite need to be done on Target server where we have to install Oracle GoldenGate Bigdata.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/673/1*Px2eUtNHKZWlHuXzEgANNw.png" /></figure><p>First we will do all the activity on source server like create initial load extract process, cdc extract process, cdc pump process.</p><p><strong><em>Step 1:-</em></strong> Create initial load extract, file to replicat method.</p><pre>GGSCI (pocgg) 9&gt; edit param EINLOAD</pre><pre>GGSCI (pocgg) 10&gt; view param EINLOAD</pre><pre>SOURCEISTABLE<br>SOURCEDB sourcegg@pocgg, USERID ggsuser_S, PASSWORD Ggsuser$1234<br>RMTHOST 10.128.0.6, MGRPORT 7820<br>RMTFILE /GGbigdata/OGGHOME/dirdat/ia, megabytes 200<br>TABLE sourcegg.categories;<br>TABLE sourcegg.customers;<br>TABLE sourcegg.departments;<br>TABLE sourcegg.order_items;<br>TABLE sourcegg.orders;<br>TABLE sourcegg.products;</pre><p><strong><em>Step 2:-</em></strong> Create and Run change data capture (cdc) extract process.</p><pre>GGSCI (pocgg) 14&gt; edit param EGCPBIG</pre><pre>GGSCI (pocgg) 15&gt; view param EGCPBIG</pre><pre>EXTRACT EGCPBIG<br>SOURCEDB sourcegg@pocgg, USERID ggsuser_S, PASSWORD Ggsuser$1234<br>DISCARDFILE ./dirrpt/egcpbig.dsc, append, MEGABYTES 10<br>TRANLOGOPTIONS ALTLOGDEST &quot;/var/lib/mysql/binlog.index&quot;<br>EXTTRAIL /oggmysql/OGG19c/dirdat/ed<br>TABLE sourcegg.categories;<br>TABLE sourcegg.customers;<br>TABLE sourcegg.departments;<br>TABLE sourcegg.order_items;<br>TABLE sourcegg.orders;<br>TABLE sourcegg.products;</pre><pre>Before starting extract process check for supplemental logging on table. For MySQL ADD trandata owner.table name doesn&#39;t work. By default Goldengate determine column identifier based on <br>1. primary key <br>2. First unique key alphanumerically that does not contain a timestamp or non-materialized computed column<br>3.If Primary or Unique Key doesn&#39;t exist then Oracle GoldenGate constructs a pseudo key of all columns that the database allows to be used in a unique key. </pre><pre>GGSCI (pocgg) 5&gt; dblogin SOURCEDB sourcegg@pocgg, USERID ggsuser_S, PASSWORD Ggsuser$1234<br>Successfully logged into database.</pre><pre>In our case all table have a PK column. </pre><pre>Now Add and start the extract process </pre><pre>GGSCI (pocgg DBLOGIN as ggsuser_S) 12&gt;  ADD EXTRACT EGCPBIG, TRANLOG, BEGIN NOW<br>EXTRACT added.</pre><pre>GGSCI (pocgg DBLOGIN as ggsuser_S) 13&gt; ADD EXTTRAIL /oggmysql/OGG19c/dirdat/ed , EXTRACT EGCPBIG<br>EXTTRAIL added.</pre><pre>GGSCI (pocgg DBLOGIN as ggsuser_S) 14&gt; info all</pre><pre>Program     Status      Group       Lag at Chkpt  Time Since Chkpt</pre><pre>MANAGER     RUNNING<br>EXTRACT     STOPPED     EGCPBIG     00:00:00      00:00:07<br>REPLICAT    RUNNING     RCDC1       00:00:00      00:00:02</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/567/1*A7nsqta3IzspJWltKv5KiA.png" /></figure><p><strong><em>Step 3</em></strong>:- Create and Run change data capture pump process.</p><pre>GGSCI (pocgg) 8&gt; edit param PUMPGCP</pre><pre>GGSCI (pocgg) 9&gt; view param PUMPGCP</pre><pre>EXTRACT PUMPGCP<br>SOURCEDB sourcegg@pocgg, USERID ggsuser_S, PASSWORD Ggsuser$1234<br>DISCARDFILE ./dirrpt/pumpgcp.dsc, append, MEGABYTES 10<br>RMTHOST 10.128.0.6, MGRPORT 7820<br>RMTTRAIL /GGbigdata/OGGHOME/dirdat/rd<br>TABLE sourcegg.categories;<br>TABLE sourcegg.customers;<br>TABLE sourcegg.departments;<br>TABLE sourcegg.order_items;<br>TABLE sourcegg.orders;<br>TABLE sourcegg.products;</pre><pre>GGSCI (pocgg) 27&gt; ADD EXTRACT PUMPGCP, EXTTRAILSOURCE /oggmysql/OGG19c/dirdat/ed<br>EXTRACT added.</pre><pre>GGSCI (pocgg) 28&gt; ADD RMTTRAIL /GGbigdata/OGGHOME/dirdat/rd , EXTRACT PUMPGCP<br>RMTTRAIL added.</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/690/1*amm6h7UUy37UGca_vWcLvQ.png" /></figure><p><strong><em>Step 4</em></strong>:- Now Start initial load extract process.</p><pre>[opc@pocgg OGG19c]$ extract paramfile /oggmysql/OGG19c/dirprm/einload.prm reportfile /oggmysql/OGG19c/dirrpt/einload.rpt</pre><pre>Check file size of trail <br>[opc@pocgg OGG19c]$ ls -ltrh /GGbigdata/OGGHOME/dirdat/ia*<br>-rw-r-----. 1 opc mysql 30M Nov 20 18:18 /GGbigdata/OGGHOME/dirdat/ia000000</pre><pre>Also check report file of all status </pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/670/1*fMRucFQEiDCyfAc886YX3A.png" /></figure><p><strong>B</strong>. Now we create initial load and cdc replicat process on target server.</p><p><strong><em>Step 5</em></strong>:- Create Initial load Replicat process for Big Query Adapter.</p><pre>We need to download latest version of the Java Client library for BigQuery below is the link.<br><a href="https://developers.google.com/api-client-library/java/apis/bigquery/v2">https://developers.google.com/api-client-library/java/apis/bigquery/v2</a></pre><pre>I will share list of Java Client library jar, keep all below jar in a directory (/home/opc/bigquery/libs/) this path will be value for gg.classpath property. <br>Eg:- gg.classpath=/home/opc/bigquery/libs/*</pre><figure><img alt="https://download.jar-download.com/cache_jars/com.google.cloud/google-cloud-bigquery/1.124.4/jar_files.zip" src="https://cdn-images-1.medium.com/max/487/1*5wXg47sxAAMvmpcsw8EVNQ.png" /></figure><p>In bigquery.props file we have to get value of property from GCP console.</p><pre>Eg:-  gg.handler.bigquery.projectId=oracle-******8106</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/762/1*KcLTBUCoOyiY43KoQ3iw4w.png" /></figure><pre>For &quot;gg.handler.bigquery.datasetId&quot; property go to BigQuery Console. On left side you will see your project id detail, click on it, Then create dataset give it a name and location. So value for gg.handler.bigquery.datasetId=CDC_GG</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*J5GNjz-q5YICi383pyH0KQ.png" /></figure><pre>for &quot;gg.handler.bigquery.credentialsFile&quot; property Go to IAM &amp; Admin console, then go to Service Accounts and create a new service account and download the file. Transfer that file to your VM. <br>gg.handler.bigquery.credentialsFile=/home/opc/oracle-****8106-717fb0cdacad.json</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kWForvj0x56P8v8jXdSqXw.png" /></figure><p>Final property file will be look something like this.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/749/1*fBuelBmjuIW0VJOsnptZ0A.png" /></figure><p>Add property to initial load replicat and start it. Run the command</p><p><em>replicat paramfile /GGbigdata/OGGHOME/dirprm/rilogcp.prm reportfile /GGbigdata/OGGHOME/dirrpt/rilogcp.rpt</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*I0wDkRVE6Lmo4AAflm-M2A.png" /></figure><p>initial load replication was successful.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/674/1*iPQA1KNkqe-Y16hSX0hVwg.png" /></figure><p>We are able to see data in Big Query.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*e6G4XMMuDr2CVT-9UkBQUg.png" /></figure><p><strong><em>Step 6</em></strong>:- Create CDC Replicat process for Big Query Adapter.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/775/1*T2CnDc4ZyrtYZUM4Xqnutg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/650/1*go0Gu_e8wxfyxh_eVdC2Lg.png" /></figure><p>Now do some transaction on source database.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/543/1*Jmfm484AdKg9sOhEmWpz9g.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/785/1*UV1cCUwNv_he8D5SFY8WsA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/787/1*Lb12rxlktZzTPXEan2qgaw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*z9i8nHGnwm2S_XwIlpqEYg.png" /></figure><p>Now start your own load testing from here on.</p><pre><strong>Note:<br></strong>1. Initial load for larger table will take long time using GoldenGate. <br>2. If Oracle GoldenGate for RDBMS database is present Client DC and and you have installed GoldenGate Bigdata on GCP VM, then make sure network speed between these VM is high. Other wise you may face lag in pump process. </pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=44afd49e75f8" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Oracle GoldenGate MySQL to MySQL Configuration part 2]]></title>
            <link>https://abhii5.medium.com/oracle-goldengate-mysql-to-mysql-configuration-part-2-20e3b59845b7?source=rss-9b3dc9345867------2</link>
            <guid isPermaLink="false">https://medium.com/p/20e3b59845b7</guid>
            <category><![CDATA[database]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[replication]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[golden-gate]]></category>
            <dc:creator><![CDATA[Abhii]]></dc:creator>
            <pubDate>Mon, 09 Nov 2020 20:54:56 GMT</pubDate>
            <atom:updated>2020-11-09T20:54:56.752Z</atom:updated>
            <content:encoded><![CDATA[<h4>Part 2 Installation of GoldenGate MySQL and steps to perform initial load &amp; CDC extract, pump and replicat process from MySQL to MySQL database.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/884/1*oXhGBgb4CRKPYdtTdVLxQA.png" /></figure><p><strong>Step 1</strong>:- Download Oracle GoldenGate MySQL software from oracle website as show below. Save the link address to use it with <em>wget </em>command.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*4V4aVTb5_mzPiZOw2yKmwQ.png" /></figure><p><strong><em>Note </em></strong>: If you doing it in OCI, then you need to select Market Place image of Oracle GoldenGate for Non Oracle Database and select for MySQL binaries, it will create compute machine with all the required binaries of GoldenGate for remote capture and apply. Other Cloud service doesn’t provide same service as OCI, so you can follow below steps in RHEL or oracle Linux OS. Since Remote capture and apply for MySQL is only certified in these OS.</p><p>[opc@pocgg oggmysql]$ <em>wget </em><a href="https://download.oracle.com/otn/goldengate/191000/191003_ggs_Linux_x64_MySQL_64bit.zip"><em>https://download.oracle.com/otn/goldengate/191000/191003_ggs_Linux_x64_MySQL_64bit.zip</em></a><em>?…….&lt;your auth key &gt;..</em></p><p><strong>Step 2</strong>:- Unzip the Zip file, you will get tar file and OGG 19c documentation. Then un-tar the binaries in different directory that will be your OGG_HOME or GG_HOME (whatever you prefer)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*0hp5j52r4sydQqP4f6RTzA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/582/1*SVDU8B59GuBTy0PUWCiBfA.png" /></figure><p><strong>Step 3</strong>:- Run ggsci command, we can also set it bash profile.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/626/1*Q-a8chXw7_UDrL3kiV5aCA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/637/1*xBlBH-_bkfHAPazwMyEZ5w.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/651/1*cHKgMaa-4MaOa5YxlBwiEQ.png" /></figure><p><strong>Step 4</strong>:- Connect to Mysql database from ggsci prompt.</p><p>GGSCI (pocgg) 2&gt; <em>dblogin SOURCEDB sourcegg@pocgg, USERID ggsuser_S, PASSWORD ****</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*y5YH83oZectyWZhWzRIXQQ.png" /></figure><p><strong><em>Note</em></strong>:- pocgg is hostname, you can put ip also. In my environment it will work without ip/hostname, because MySQL services are running on same server.</p><p><strong>Step 4</strong>:- For Initial load add tables in source and target database and insert dummy value only in table present in source database. You can find the script for dummy table in OGG_HOME(where GG for MySql is installed). You can use <em>demo_mysql_create.sql </em>and <em>demo_mysql_insert.sql</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/550/1*k_wFycZvL0ptT2kgK7B7Og.png" /></figure><p>Run <em>demo_mysql_create.sql </em>on sourcegg and targetgg, and <em>demo_mysql_insert.sql </em>only on sourcegg.</p><p>Step 5:- Create initial load extract process (EILOAD1)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*zJ2QbaIyyq-vuKUq9ubH6w.png" /></figure><p>Note:- You can either choose RMTFILE or RMTTASK. Both work, if you need trailfiles of initial load then use RMTFILE. Keep in mind to delete the trailfiles from target server to free us some space.</p><p><strong>Step 6</strong>:- Create CDC extract process, first we have to start cdc process and later our initial load (EILOAD1) process.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/761/1*KlvkDsE0JeN1b3ZoEgrIdQ.png" /></figure><p>After starting the extract process got below errors.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lz_yHaFoqxy8DogbaQRdYQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rDFCKNkWA26xi91bFfL3Vg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-q2lLvVFCz6GyIwpusCalQ.png" /></figure><p>Referred below documents will help you to resolve this issue.</p><p><em>MySQL Extract Abends With OGG-00146 Call To VAMInitialize Returned With Error Status 600: VAM Client Report (Doc ID 2611678.1) <br>MYSQL Extract Abends with OGG-00146 CAUSE OF FAILURE : Access denied for user (Doc ID 2697378.1)</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/559/1*al-pXqNhrlCu1SMkMDxtbg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/551/1*81oL9aoKm2VbUePENWVyLA.png" /></figure><p><strong>Step 7:- </strong>Do some transaction on tables and check GoldenGate extract process has captured it or not.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/964/1*ZduQbjYoM4L9I61HFFG0lQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/541/1*kpKaWr_qK4y6zFJeA6gb-g.png" /></figure><p><strong>Step 8</strong>:- Create initial load replicat process, also check tables in target database to check tables are empty.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*tmXvYbRuo5hneyQPzuJBBA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/351/1*7mufWcNH2MxA0nEn41kvsQ.png" /></figure><p><strong>Note</strong>:- <em>sourcedefs</em> is not required in our case, since it is MySQL to MySQL replication.</p><p>GGSCI (pocgg DBLOGIN as ggsuser_S) 79&gt; <em>start EXTRACT EILOAD1</em></p><p>Sending START request to MANAGER …<br>EXTRACT EILOAD1 starting</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/632/1*nd3uCAsRg5mVobZZIKAEzA.png" /></figure><p>Initial load replicat will start automatically, we can check report file to see it transactions are applied on target database or not. Also check for records on target database.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/673/1*mdT-SRdOA-yo71tS2nvSyQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/965/1*ZDYetXe_ETuzCy15GKvQ0A.png" /></figure><p><strong>Step 9</strong>:- Now create CDC replicat process. In our case we don’t need pump process because source and target database are on same server. create checkpoint table before adding the replicat process.</p><p>GGSCI (pocgg DBLOGIN as ggsuser_T) 3&gt; add checkpointtable targetgg.ckpt</p><p>Successfully created checkpoint table targetgg.ckpt.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1013/1*2q1dscwDgHfzramG7cWQBg.png" /></figure><p><strong>Step 10:- </strong>Start GoldenGate replicat process.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/574/1*R4JlYCYV42V5NXrkYGWGJg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/713/1*5DLvoaC_ReBtQcVyXRGcEw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8KvRwi-Hh1a7gHIycs5waA.png" /></figure><p><strong>Step 11</strong>:- Lets do some more transactions on source database.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/920/1*zPAk8RQtUTUQoiYfuxW3gQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/592/1*o5Xp5vB0vSMKovjRCkekjw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/492/1*T5K634SRO_VWansYbnOP5g.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/560/1*K1Xf1u8Gb-g-qqu57ZocAQ.png" /></figure><p>Reference :- <a href="https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/GGS_Sect_Config_WinUX_ORA_to_WinUX_MSQ.pdf">https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/GGS_Sect_Config_WinUX_ORA_to_WinUX_MSQ.pdf</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=20e3b59845b7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Oracle GoldenGate MySQL to MySQL Configuration part 1]]></title>
            <link>https://abhii5.medium.com/oracle-goldengate-mysql-to-mysql-configuration-part-1-933b6dbc9e2f?source=rss-9b3dc9345867------2</link>
            <guid isPermaLink="false">https://medium.com/p/933b6dbc9e2f</guid>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[golden-gate]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[replication]]></category>
            <dc:creator><![CDATA[Abhii]]></dc:creator>
            <pubDate>Mon, 09 Nov 2020 20:51:23 GMT</pubDate>
            <atom:updated>2020-11-09T20:51:23.821Z</atom:updated>
            <content:encoded><![CDATA[<h4>Part 1 contain Installation and Configguration of MySQL database in Rhel 7 server. Source and target MySQl database for GoldenGate will be on same server.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/884/1*oXhGBgb4CRKPYdtTdVLxQA.png" /></figure><p>Step1 :- Download and add MySQL Yum Repository to Linux Repository.</p><p><em># wget </em><a href="https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm"><em>https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm</em></a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*WIqwlaGAYTCV14-OOE8CcA.png" /></figure><p>Step 2:- Install the downloaded package by using below command.</p><p><em># yum local install mysql80-community-release-el7–3.noarch.rpm</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*FQ8r-U7NokYL5W-jAvu-RA.png" /></figure><p>Step 3:- Verify that the MySQL Yum repository has been added successfully.</p><p><em># yum repolist enabled | grep “mysql.*-community.*”</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/704/1*aR-JsX73fXGBv1ZBKA88ng.png" /></figure><p>Step 4:- Install latest MySQL using below command.</p><p><em># yum install mysql-community-server</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*MEWuLd1tBKYBdDrg3g_Wyg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*TWgyUADTu92FFcQtsqlwIw.png" /></figure><p>Step 5:- Start MySQL Server and enable it, using below commands.</p><p><em># systemctl start mysqld</em></p><p><em># systemctl enable mysqld</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*eqxSzlPvYaTGF9TIAoQVtA.png" /></figure><p>Step 6:- When MySQL 8.0 version is installed, temporary password for root is stored in mysqld.log file. Run below command to list the password.</p><p><em># cat /var/log/mysqld.log | grep ‘temporary password’</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*TWQnptJam5z1JuQWDLNZpA.png" /></figure><p>Step7:- Get the password and then run below command. To create new password and other things(check screen-shot)</p><p><em># mysql_secure_installation</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*s2REtn7Sn03NnAnfoU9mNA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*dW72gTJLIzwlyLZAqfzwHg.png" /></figure><p>Step8:- Login to MySQL database. (below command can be run from other OS user also)</p><p><em># mysql -u root -p</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/653/1*3F4y8h_uGe-UCCuROh9noQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/241/1*SefU5uOfWv-3z0KjtzULLA.png" /></figure><h4><strong>Create MySQL Source and Target database</strong></h4><p><strong>Step1</strong>:- Create Two Mysql database one for source one for Target</p><p>[opc@pocgg OGG19c]$ <em>mysql -u root -p</em></p><p>mysql&gt; <em>show databases;</em><br>+ — — — — — — — — — — +<br>| Database |<br>+ — — — — — — — — — — +<br>| ggtest |<br>| information_schema |<br>| mysql |<br>| performance_schema |<br>| sys |<br>+ — — — — — — — — — — +<br>5 rows in set (0.00 sec)</p><p>mysql&gt; <em>CREATE DATABASE sourcegg DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;</em><br>Query OK, 1 row affected, 2 warnings (0.01 sec)</p><p>mysql&gt; <em>CREATE DATABASE targetgg DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;</em><br>Query OK, 1 row affected, 2 warnings (0.01 sec)</p><p>mysql&gt; <em>show databases;</em><br>+ — — — — — — — — — — +<br>| Database |<br>+ — — — — — — — — — — +<br>| ggtest |<br>| information_schema |<br>| mysql |<br>| performance_schema |<br>| <strong>sourcegg</strong> |<br>| sys |<br>| <strong>targetgg </strong>|<br>+ — — — — — — — — — — +<br>7 rows in set (0.00 sec)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*QytA_WMDD_FkixdLHNmmXQ.png" /></figure><p><strong><em>Note</em></strong>:- Source Database for GoldenGate will be <strong>sourcegg </strong>and target database for GoldenGate will be <strong>targetgg.</strong></p><p><strong>Step 2</strong>:- Create GoldenGate user for sourcegg and targetgg databases and grant then required privilege&#39;s.</p><p>mysql&gt; <em>CREATE USER ‘ggsuser_S’@’%’ IDENTIFIED BY ‘Ggsuser$1234’;</em><br>Query OK, 0 rows affected (0.01 sec)</p><p>mysql&gt; <em>GRANT ALL PRIVILEGES ON sourcegg.* TO ‘ggsuser_S’@’%’ WITH GRANT OPTION;</em><br>Query OK, 0 rows affected (0.01 sec)</p><p>mysql&gt; <em>CREATE USER ‘ggsuser_T’@’%’ IDENTIFIED BY ‘Ggsuser$1234’;</em><br>Query OK, 0 rows affected (0.01 sec)</p><p>mysql&gt; <em>GRANT ALL PRIVILEGES ON targetgg.* TO ‘ggsuser_T’@’%’ WITH GRANT OPTION;</em><br>Query OK, 0 rows affected (0.00 sec)</p><p><strong>Step 3</strong>:- Check to login to sourcegg and targetgg database from ggsuer_S and ggsuer_T respectively.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/664/1*DGKZPnLiCJ_aqqZOEc0qhQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*duh7rE0OWPx508jZAWAkPg.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=933b6dbc9e2f" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>