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/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *