Chapter 8. Managing Oracle GoldenGate

Managing a computer system can be a challenge, especially when there are multiple sites and distributed databases. We need to keep a close eye on things, ensuring that systems remain operational and efficient, checking that; the databases are open, data replication is running with minimal lag, adequate space is available in both the databases and file-systems, the list goes on.

Although Oracle offers a web-based product called Director, for managing and configuring GoldenGate instances, this chapter focuses on the management features already built in to the GoldenGate Command Interpreter (GGSCI). We will discuss and implement a number of utilities, including tips and tricks that allow us to manage our GoldenGate environment effectively at no extra cost. This includes the following:

• Command level security

• Trail File management

• Managing process startup

• Monitoring system health

• Managing TCP/IP errors

• Monitoring performance

• Gathering and reporting on statistics

Let...