Site icon IT Tutorial

Oracle GoldenGate 12c Installation And Configuration -3

Hi,

I will continue to explain Oracle GoldenGate 12c Installation And Configuration with this post.

 

You should read following first and second articles before this post read.

 

Oracle GoldenGate 12c Installation And Configuration -1

 

Oracle GoldenGate 12c Installation And Configuration -2

 

 

 

10. From the installation directory, you can see some important directories, starting with dir*. For example dirprm is parameter files directory, dirrpt is reports ( log ) directory, dirsql is sql directory and etc.

 

11. From the installation path you can run goldengate to configure

[oracle@MehmetSalih goldengate]$ ./ggsci

12. Check what is running on default when Goldengate is started

GGSCI (MehmetSalih ) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER    RUNNING

 

 

13. Configuring Manager ( Apply this steps on Source and Target DB site )

Stop Manager

 

GGSCI (MehmetSalih ) 4> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y

 

Modify Manager Parameter File

 

GGSCI (MehmetSalih ) 6> edit params mgr

 

Paste Below parameters to Purge, Auto Restart and Lag Control, save and exit

 

 

PORT 7809

--Deletion interval of old trail file  

PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS

-- Autorestart Parameters
AUTORESTART ER *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 30
--AUTOSTART ER *

-- Lag control parameters
LAGCRITICALMINUTES 20
LAGINFOMINUTES 20
LAGREPORTMINUTES 20

 

Start Manager

 

GGSCI (MehmetSalih ) 7> start mgr
Manager started.

 

You should run all steps on source goldengate and target goldengate.

 

 

 

Once you completed installation of Goldengate, you can start performing the Replication using Goldengate.

 

You can read the following post to learn How to do Replication with Goldengate.

Oracle Goldengate Step by Step Replication -2

 

Do you want to learn Oracle Goldengate, then read the following articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/

Exit mobile version