Oracle GoldenGate ctor configuration Manual

Oracle GoldenGate ctor configuration Manual

1. Introduction to GoldenGate ctor

GoldenGate ctor simplifies the monitoring and management of GoldenGate. You can use a graphical interface or a web browser to conveniently and quickly maintain the GoldenGate components in the entire environment.

Ii. Components of GoldenGate ctor

2.1 Structure:

 

2.2 GoldenGate instances

Each instance is a ggsci mgr process. We only need to specify the corresponding IP address (dns) and port to connect to the instance. for large-scale applications, it is best to use dns resolution.

2.3 GoldenGate Director Server

Manage all connected instances. The server is based on weblogic. Mainly includes some applications and Monitor Agent

2.4 GoldenGate Director database

Stores information about GoldenGate ctor, including user, group, topology, event, and so on.

2.5 GoldenGate Director Client

Manage instances through graphical interfaces

2.6 GoldenGate Director Web

This should be your favorite tool. You can monitor the golden gate process in the current environment through the web interface.

2.7 GoldenGate Director Administrator

Used to configure Director Server

Iii. Installation of GoldenGate ctor

3.1 install weblogic

GoldenGate Director is a service running on weblogic, so weblogic must be installed first.

Installation is relatively simple and the process is omitted

3.2 prepare a database

The database is used for GoldenGate ctor database. Currently, only the following three types are supported:

? MySQL 5.x Enterprise version.

? SQL Server 2000 and 2005

? Oracle 9i or later.

I usually use mysql because it is lightweight, fast, and easy to manage. Note: To prepare a user in advance, the password must be 8 characters long.

Installation Process omitted

3.3 install GoldenGate ctor

Run gg-director-serversetup_unix _ *. sh to start server Installation

Run gg-director-client_unix _ *. sh to start client installation

The installation process is simple. Just enter the corresponding value as prompted.

4. Manage configurations

4.1 start GoldenGate Director Server

Go to the installation directory of GoldenGate ctor domain, my on/opt/GG_Directorgg-director/domain

Run the./startWebLogic. sh command to start

After startup, enter http: // ip: 7001/acon in the browser. The default user name/password is admin/admin, as shown in:

4.2 run Director Administrator4.2.1 to start the configuration tool

Go to the/opt/goldengatector/bin directory

Run the./run-admin.sh with the following prompt:

Enter admin in Username, admin in password, and ip and port in server.

4.2.2 Director Administrator Configuration

You can use Director Administrator to configure and manage the following content:

● Change the administrator user information and password

● Manage user accounts

● Manage data sources

● Configure the Monitor Agent

● Set default domain suffixes

The configuration of the data source is mainly used. The following is a configuration example of mine.

 

4.2.3 GoldenGate ctor

You can use this tool to configure golden gate by drawing a picture. If the data source is correctly configured, you can configure a copy process by dragging it. As follows:
 

GoldenGate unidirectional table DML Synchronization

Oracle GoldenGate series: restoration principles of Extract processes

Oracle GoldenGate installation Configuration

OGG-01004 OGG-1296 error for Oracle goldengate

Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations

Build a GoldenGate bidirectional replication environment from Oracle to Oracle