Shulou(Shulou.com)06/01 Report--

No matter what kind of technology it is, it is very important to understand the concept at the beginning of learning. After mastering the concept, connect the various knowledge points and understand its architecture through practice. If the concept is not clear, it will feel foggy in the face of flexible configuration parameters. The oracle official documentation is a treasure for learning oracle technology, and you can find the part you need in the documentation from the entry stage to the improvement phase. The company recently started to do the OGG project, take this opportunity to systematically learn, open the dusty documents to begin the learning journey.

Configuring Manager and Network Communications

Configuring the Manager process. Configure the Manager process

Specifying ports for local and remote network communications. Specify ports for local and remote network connections

All Oracle GoldenGate ports are configurable. All ogg ports are configurable

Manager process

Before configuring and running Oracle GoldenGate, the Manager process must be running on both source and target systems, or on any mediation system. The functions of the management process are as follows:

Start the Oracle GoldenGate process start the dynamic process start the Collector process management process port number execution trail management create events, errors, and threshold reports assign ports to local traffic

Each Manager process installed by Oracle GoldenGate requires a dedicated port that establishes a communication connection between itself and other Oracle GoldenGate processes.

The port is specified with the parameter PORT in the Manager parameter file.

The port must be specified in the configuration file, and you can choose either the default value or a different value. Default value is 7809

The port must be available and not restricted, such as firewall restrictions

If there is more than one manager instance on the system, the port number cannot be the same

The parameter DYNAMICPORTLIST can also be used in the Manager parameter file to specify multiple ports, even as many as 5000. The list format is as follows:

7830, 7833, 7835

7830-7835

7830-7835, 7839

Although DYNAMICPORTLIST is not a required parameter, it is strongly recommended for transmission performance. If multiple communication ports are set, the Collector process will find out in time when the port being communicated fails, and then try to use the next port number in the port list until one is available, which greatly reduces the single point of failure of the port. If Collector hasn't found a working port at the end of the list, but the port number at the top of the file can be used, can you go back and select it? This requires setting the number of retries in tcperrs file. The opportunity to retry runs out of ports that are still not available. Manager sends an error message recorded in ggserr log.

Just like when we take the subway, there are often times when it is not easy to swipe a credit card. The easiest way is to change the next entrance and swipe the card again. It is not good to try to swipe the card at another entrance, so we can't go to the staff for help. In most cases, as long as the card is not demagnetized, a change of mouth to swipe the card should work. Imagine that if there is only one entrance, it is difficult to swipe a credit card at a subway station during the rush hour, so you have no choice but to squeeze out the crowd to ask the staff for help, and then squeeze back into the crowd after repair to continue to swipe the card.

For more information on PORT and DYNAMICPORTLIST, see reference guide.

Manager recommended parameters

AUTOSTART: after the Manager process starts, the Extract and Replicat processes can also be started. This parameter must be set in a clustered environment. It is very useful to start Oracle GoldenGate immediately after the cluster system starts. Multiple AUTOSTART statements can be used in a parameter file.

AUTORESTART: this parameter can restart the Extract or Replicat process when it is stopped when it fails. This parameter must also be set in a clustered environment.

PURGEOLDEXTRACTS: when Oracle GoldenGate finishes using the trail file, there is no PURGEOLDEXTRACTS statement to eliminate it, and trail will continue to take up disk space. It is best used in the Manager parameter

PURGEOLDEXTRACTS, not in Extract or Replicat

STARTUPVALIDATIONDELAY: I don't quite understand this kind of verification mechanism.

USERID: if you use Oracle GoldenGate DDL support, you must set USERID

Create a management parameter file

GGSCI > EDIT PARAMS MGR

PORT 7809DYNAMICPORTLIST 7810-7820, 7830

AUTOSTART ER t*AUTORESTART ER tweets, RETRIES 4, WAITMINUTES 4

STARTUPVALIDATIONDELAY 5

PURGEOLDEXTRACTS / ogg/dirdat/tt*, USECHECKPOINTS, MINKEEPHOURS 2

Start and stop Manager

GGSCI > START MANAGER

GGSCI > STOP MANAGER

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.