Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

Reporting and statistics


An important feature of any computer system is its ability to report and provide statistics on its availability and performance. GoldenGate offers a number of options to monitor status, latency, and throughput using its command-line interface.

To monitor errors and warnings, we can look beyond the GGSCI tool and in the log files, which we will discuss in the following sections.

Monitoring errors

It is important to note that errors detected by GoldenGate are not automatically alerted to network managers, sms gateways, or e-mail servers. Therefore, the GoldenGate administrator must proactively monitor the logs generated by GoldenGate, the OS, and the database.

This includes the following log file list (Linux):

  • <GoldenGate_Home>/ggserr.log: This provides all GoldenGate INFO, WARNING, and ERROR messages

  • /var/log/messages: This provides all Operating System INFO, WARNING, and ERROR messages, including GoldenGate processes

  • $ORACLE_BASE/diag/rdbms/$ORACLE_SID/trace/alert_...