KTEXPERTS – Page 50 – KNOWLEDGE SHARING PLATFORM

Enable DDL Replication In GoldenGate

7 years ago by Binnary Ajay KumarEnable/Disable DDL replication

Dear Readers, In this article we will see how to enable DDL Replication in Oracle GoldeGate 12c. On Source database : check processes

GGSCI (gg.orcl.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING 
EXTRACT RUNNING DPINT 00:00:00 00:00:04 
EXTRACT RUNNING EXTINT 00:00:10 00:00:08

GGSCI (gg.orcl.com) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DPINT 00:00:00 00:00:04

EXTRACT RUNNING EXTINT 00:00:10 00:00:08

On Target database :

GGSCI (gg2.orcl.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING 
REPLICAT RUNNING REPINT 00:00:00 00:00:03

GGSCI (gg2.orcl.com) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REPINT 00:00:00 00:00:03

To Enable DDl replication in 12c we need to add DDL include all param inside extract… Read More

How to add new table to existing GoldenGate Replication(Oracle to Oracle)

7 years ago by Binnary Ajay KumarAdd new table to existing GoldenGate Replication

Dear Readers, In this article we will see how to add new table to existing GoldenGate Oracle to Oracle replication. Please check below link for GG installation for Oracle to Oracle GoldenGate: Oracle to Oracle GoldenGate Unidirectional Replication Now we will add new table to… Read More

GoldenGate: MySQL to Oracle Heterogeneous Unidirectional Replication

7 years ago by Binnary Ajay KumarGolden Gate

MySQL to Oracle Heterogeneous GoldenGate Unidirectional Replication In this article we will see MySQL to Oracle GoldenGate Unidirectional Replication. Prerequisites for Replication: 1.Create two VM’s on your machine 2.Install MySQL on Source Sever. 3.Install Oracle Software and Create database on target. 4.Make sure two Vm’s are… Read More

GoldenGate: Oracle to Oracle GoldenGate Unidirectional Replication

7 years ago by Binnary Ajay KumarGolden Gate

Dear Readers, In this article we will see Oracle to Oracle GoldenGate Unidirectional Replication. Prerequisites for Replication: 1.Create two Vm/s on your machine 2.Install Oracle Software and Create databases. 3.Make sure two Vm’s are pining each other Node Details : GG1 (SOURCE) 192.168.0.51 gg1.orcl.com gg1… Read More

ORACLE TWO NODE RAC INSTALLATION ON VMWARE WORKSTATION (PART-6)

7 years ago by Binnary Ajay Kumar11gR2 RAC

Dear Readers, In this article we will see How to install Oracle software and creation of database. on RAC Environment . Please check the below link : How to install Oracle software on RAC Environment To Install Oracle software we need download Oracle binaries for… Read More

ORACLE TWO NODE RAC INSTALLATION ON VMWARE WORKSTATION (PART-5)

7 years ago by Binnary Ajay Kumar11gR2 RAC

Dear Readers, In this article we will see How to Installing Cluster software Please check the video link : Install Cluster software To install cluster software we required to download Grid infrastructure binaries from OTN Otherwise check below link for download software https://drive.google.com/open?id=1tyr0aQzipiUUllOajDf4I-TgNI2B3lfA Login with Oracle… Read More

ORACLE TWO NODE RAC INSTALLATION ON VMWARE WORKSTATION (PART-4)

7 years ago by Binnary Ajay Kumar11gR2 RAC

Dear Readers, In this article we will see How to clone a virtual machine and setting up eth0 and eth1 files.. Please check the video link : How to clone Virtual machine Cloning from RAC1 to RAC2 :- Copy all files from RAC1 folder to RAC2… Read More

ORACLE TWO NODE RAC INSTALLATION ON VMWARE WORKSTATION (PART-3)

7 years ago by Binnary Ajay Kumar11gR2 RAC

Dear Readers, In this article we will see How to setup N/W , Pre-requisites RPM’s ,directories and how to add shared storage. Please check the video link : Setting Up Network iP’s To setup IP Addresses Goto preferences–> Network Authentication It will pop-up following terminal Select… Read More

ORACLE TWO NODE RAC INSTALLATION ON VMWARE WORKSTATION (PART-2)

7 years ago by Binnary Ajay Kumar11gR2 RAC

Dear Readers, In this article, we will see Installing OEL Operating System on Virtual machine and installing Vmware tools. Please check the video link : To install Oracle Enterprise Linux on Virtual machine , we need to download OEL operating ISO image file from Oracle.com In… Read More

ORACLE TWO NODE RAC INSTALLATION ON VMWARE WORKSTATION (PART-1)

7 years ago by Binnary Ajay Kumar11gR2 RAC

Dear Readers, In this article we will see how to install Two Node RAC installation on VM ware workstation. Entire two node RAC installation i have categorized into 6 parts. PART-1 Installing VMWARE WORKSTATION on WINDOWS and Creating Virtual machine ORACLE TWO NODE RAC INSTALLATION… Read More