2.2 Supported Target Types

This topic lists the target types supported in Classic and Microservices instances.

• Target Types Supported in Classic
  
• Target Types Supported in Microservices
  

2.2.1 Target Types Supported in Classic

The target types supported in Oracle GoldenGate Enterprise Manager Classic instances are as follows:

• Oracle GoldenGate
  Oracle GoldenGate target type represents an Oracle GoldenGate classic instance. It's the parent target of Manager, Extract, and Replicat targets.
• Extract and Replicat
  You can view detailed metrics of Extract, logs, and configuration of extract on an Extract page; and view detailed metrics of Replicat, logs, and configuration of Replicat on a Replicat page.
• Manager
  The Manager process controls all the Oracle GoldenGate processes in the classic instance. Part of its role is to generate information about critical monitoring events, which it passes to the agent. For target types Replicat, Extract, and Manager, you can control the process though start, stop, kill, and resume actions.

2.2.1.1 Oracle GoldenGate

Oracle GoldenGate target type represents an Oracle GoldenGate classic instance. It's the parent target of Manager, Extract, and Replicat targets.

The Oracle GoldenGate target displays the collective status of all the processes available in Oracle GoldenGate excluding the Initial Load processes. The following is an example that illustrates how the collective status of this target works: there may be 5 Extract and Replicat processes and 2 Initial Load processes in Oracle GoldenGate, out of which, only 2 are discovered and promoted in the Oracle Enterprise Manager. This means that a subset of the Oracle GoldenGate processes is being monitored in the Enterprise Manager. However, the Oracle GoldenGate target displays the collective status of all the processes available in Oracle GoldenGate, and does not display only the status of the processes that are monitored in the Enterprise Manager.

• GoldenGate Monitor Agent
  The GoldenGate Monitor Agent represents the GoldenGate Monitor agent that is connecting to the Oracle GoldenGate Instance.

2.2.1.1.1 GoldenGate Monitor Agent

The GoldenGate Monitor Agent represents the GoldenGate Monitor agent that is connecting to the Oracle GoldenGate Instance.

Version and details of other metrics are displayed on the Oracle GoldenGate Target page.

This topic discusses the GoldenGate Monitor Agent process for Oracle GoldenGate Enterprise Manager Plug-in Classic instance.

Metric	Description
GoldenGate Monitor Agent Status	UP arrow indicates Golden Gate Agent is up and running. Down arrow indicates Golden Gate agent is down or unreachable. 1 represents UP and 2 represents Down for setting incidents and alerts.
WebService Availability	Indicates whether or not the Webservice of Oracle GoldenGate is up and running. 0 represents down status and 1 represents up status . This metric is available only from Oracle GoldenGate Monitor Agent release 12.2.1.2.210930 onwards.
Host Name	Shows the name of GoldenGate Monitor Agent host.
Agent Port	Shows the port on which the GoldenGate Monitor Agent process is running.
User Name	Shows the user name to connect to the Monitor agent.
Agent Version	Indicates the version of GoldenGate Monitor Agent. This metric is available only from GoldenGate Monitor Agent 12.2.1.2.210930 version onwards
Agent Start Time	Shows the time number of milliseconds from January 1, 1970, 00:00:00 GMT to Oracle GoldenGate Monitor Agent start time. This metric is available only from Oracle GoldenGate Monitor Agent 12.2.1.2.210930 version onwards.
Installation Path	Shows the directory that contains the Oracle GoldenGate Monitor Agent executable file. This is the home directory of the Oracle GoldenGate Monitor Agent installation. This metric is available only from GoldenGate Monitor Agent 12.2.1.2.210930 version onwards.
Config Path	Shows the Oracle GoldenGate Monitor Agent configuration properties location. This metric is available only from Oracle GoldenGate Monitor Agent 12.2.1.2.210930 version onwards.

2.2.1.2 Extract and Replicat

You can view detailed metrics of Extract, logs, and configuration of extract on an Extract page; and view detailed metrics of Replicat, logs, and configuration of Replicat on a Replicat page.

For more information, see the Extract and the Replicat target types, see Extract and Replicat.

2.2.1.3 Manager

The Manager process controls all the Oracle GoldenGate processes in the classic instance. Part of its role is to generate information about critical monitoring events, which it passes to the agent. For target types Replicat, Extract, and Manager, you can control the process though start, stop, kill, and resume actions.

This topic discusses the Manager process for Oracle GoldenGate Enterprise Manager Plug-in Classic instance.

Metric	Description
Host Name	Shows the name of the host system. Valid values: The fully qualified DNS name of the host, or its IP address
Manager Port	Shows the port on which the Manager process of the Instance is running on its local system. The default port number is 7809, but a different port could be specified for this Manager and can be identified by viewing the Manager parameter file or by issuing the INFO MANAGER command in GGSCI (if Manager is running). Valid values: The port number for the Manager process, as specified in the Manager parameter file
Start Time	Shows the time that an Oracle GoldenGate component received its startup information after it has been created. Valid values: 64-bit Julian GMT time stamp in microseconds
Version	Indicates the version of Oracle GoldenGate that the selected Oracle GoldenGate Instance represents. Valid values: X.x.x (major, minor, and maintenance version levels), for example 11.1.1
Working Directory	Shows the directory that contains the Manager executable file for the selected Oracle GoldenGate Instance. This is the home directory of the Oracle GoldenGate installation. Valid values: The full path name of the directory

2.2.2 Target Types Supported in Microservices

The target types supported in Oracle GoldenGate Enterprise Manager Microservices instances are as follows:

• Administration Server
  You can use the Administration Server page to manage Extract and Replicat processes and to monitor the metrics of these processes.
• Extract and Replicat
  On the Extract target and Replicat target pages, you can view the respective Oracle GoldenGate process metrics, set alerts for these metrics, view logs, configuration files, and monitor historical trends.
• Service Manager
  The Service Manager page lists all the Oracle GoldenGate Miscroservices Architecture deployments. From the Service Manager page, you can access Administration Server, Receiver Server, and Distribution Server targets. If you have multiple deployments, then you can also filter using the Deployment drop-down list.
• Deployment
  Following are the details that you can view for each deployment.
• Distribution Server
  The Distribution Server displays the distribution path, and the details of each path, such as status, time taken for data movement, source and target path details, and the database name.
• Receiver Server
  The Receiver Server displays the receiver path, and the details of each path, such as status, time taken for data movement, source and target path details, and the database name.

2.2.2.1 Administration Server

You can use the Administration Server page to manage Extract and Replicat processes and to monitor the metrics of these processes.

2.2.2.2 Extract and Replicat

On the Extract target and Replicat target pages, you can view the respective Oracle GoldenGate process metrics, set alerts for these metrics, view logs, configuration files, and monitor historical trends.

The following table lists the metrics used to monitor the Extract and Replicat processes. Metrics are fetched every 60 seconds by default from the targets. However, you can change the fetch frequency.

Metric	Description
Checkpoint Position	Valid for Extract and Replicat Shows a composite representation of the checkpoints that were persisted to disk most recently by Extract or Replicat. The value is captured by the monitoring agent when the attribute is published, right after the checkpoint gets persisted. Extract creates read and write checkpoints, and Replicat creates only read checkpoints. Each individual checkpoint within the composite Checkpoint Position consists of the RBA (relative bye address) of a record in the transaction log or trail (depending on the process and whether it is a read or write checkpoint) and the sequence number of the log or trail file that contains the record. There can be a series of read checkpoints in multiple data source log files (such as Extract from Oracle Real Application Cluster), and/or multiple write checkpoints such as in Extract configurations with multiple trail files. Valid values: Different databases use different representations of the position of a record in the log. Therefore, instead of numeric values, Checkpoint Position is published as a string of text characters encoded in UTF8. For each individual checkpoint within Checkpoint Position, the following are shown the way that they are returned by the GGSCI SEND group-name STATUS command: The values of the RBA (relative byte address) The file sequence number The time stamp
Delta Deletes	Valid for Extract and Replicat Shows the number of DELETE operations that were processed by the selected Oracle GoldenGate process since the last fetched value. Valid values: A positive integer
Delta Discards	Valid for Extract and Replicat Shows the DISCARD operations that were processed by the selected Oracle GoldenGate process since the last fetched value. Valid values: Positive integer.
Delta Executed DDLs	Valid for Extract and Replicat Shows the count of executed Data Definition Language (DDL) operations that were processed by the selected Oracle GoldenGate process since the last fetched value. Valid values: Positive integer
Delta Ignores	Valid for Extract Shows the number of data manipulation language (DML) operations that through an error were configured to be ignored since the last fetched value. Valid values: Positive integer
Delta Inserts	Valid for Extract and Replicat Shows the number of data manipulation language (DML) INSERT operations that were processed by the selected Oracle GoldenGate process since the last fetched value. Valid values: A positive integer
Delta Operation Per Second	Valid for Extract and Replicat Shows the number of operations (per second) that were processed by the selected Oracle GoldenGate process since the last fetched value. Valid values: A positive integer
Delta Operations	Valid for Extract and Replicat Shows the total number of Data Definition Language (DDL) and Data Manipulation Language (DML) INSERT, UPDATE, DELETE, AND TRUNCATE operations that were processed by the selected Oracle GoldenGate process since the last fetched value. Valid values: A positive integer
Delta Row Fetch Attempts	Valid for Extract Shows the number of row fetch attempts that were processed by the selected Oracle GoldenGate process since the last fetched value. Valid values: Positive integer
Delta Row Fetch Failures	Valid for Extract Shows the number of row fetch failures that were processed by the selected Oracle GoldenGate process since the last fetched value. Valid values: Positive integer
Delta Truncates	Valid for Extract and Replicat Shows the number of TRUNCATE operations that were processed by the selected Oracle GoldenGate process in its current run session since the last fetched value. Valid values: A positive integer
Delta Updates	Valid for Extract and Replicat Shows the number of UPDATE (including primary key updates) operations that were processed by the selected Oracle GoldenGate process in its current run session since the last fetched value. Valid values: A positive integer
End of File	Valid for Extract and Replicat Shows whether or not the selected process has reached the end of the input from its data source (transaction log or trail file). Valid values: TRUE (at end of file) or FALSE. Note: End of File metrics value 0 means FALSE. For the alert template, ensure to use the stored metric values 0 and 1, where 0 means FALSE and 1 means TRUE. Note: For the alert template, ensure to use the stored metric value in milliseconds (since Unix Epoch) to all the following metrics: last_checkpoint_ts, last_processed_ts, last_operation_ts, start_time, last_checkpoint_ts, last_processed_ts, last_operation_ts, start_time.
Lag (sec)	Valid for Extract and Replicat Shows the time difference between the Last Operation Timestamp and the Last Processed Timestamp. This attribute represents the true lag between theOracle GoldenGate process and its data source. This lag value should match the value that is returned from the GGSCI command SEND groupGETLAG . Valid values: The lag time, in seconds
Last Checkpoint Timestamp	Valid for Extract and Replicat Shows the time when the last checkpoint was written by the process. Valid values: Datetime value in the format of MM/DD/YYYY HH:MM:SS {AM | PM}, for example: 01/14/2011 09:36:32 AM.
Last Operation Timestamp	Valid for Extract and Replicat Shows the time when an operation (INSERT, UPDATE, DELETE) was committed in the data source, as recorded in the transaction log. Valid values: Datetime value in the format of MM/DD/YYYY HH:MM:SS {AM | PM}, for example:01/14/2011 09:36:32 AM
Last Processed Timestamp	Valid for Extract and Replicat Shows the time when a valid record was returned to the selected process. For Extract, this time value is assigned when the record is processed after the container transaction commits (not the time when the record is read from the transaction log). For a Data Pump or Replicat, this time value is returned immediately, because all transactions in the trail are known to be committed. Valid values: Date time value in the format of MM/DD/YYYY HH:MM:SS {AM | PM}, for example: 01/14/2011 09:36:32 AM
Message	Valid for Extract and Replicat The message includes the following information: Message code number of an event message from the Oracle GoldenGate error log. Valid values: The numerical code of an Oracle GoldenGate event message in the event log, for example, OGG-00651. Message Date: Timestamp of an event message from the Oracle GoldenGate log. Valid values: A datetime value in the form of YYYY-MM-DD HH:MM:SS (in 24-hour clock format) Message Text: Text of an event message from the Oracle GoldenGate error log. Valid values: A text string from the message.
Name	Valid for Extract and Replicat Name of the selected object. Valid values: Name of the object as displayed in the Oracle GoldenGate Monitor interface.
Seconds Since Last OGG Checkpoint	Valid for Extract and Replicat Time (in seconds) since the last OGG checkpoint.
Start Time	Valid for Extract and Replicat Shows the time that an Oracle GoldenGate component received its startup information after it has been created. Valid values: 64-bit Julian GMT time stamp in microseconds
Status	Valid for Extract and Replicat Shows the run status of the selected process. Note: The alert for Metric status is set for numeric value. For more information on setting metric alert, see Setting Metric Alerts and Incidents for Extract and Replicat.
Total Deletes	Valid for Extract and Replicat Shows the total number of DELETE operations that were processed by the selected Oracle GoldenGate process in its current run session. Valid values: A positive integer
Total Discards	Valid for Extract and Replicat Shows the total number of operations that were discarded by the selected Oracle GoldenGate process in its current run session. The records are written to the discard file that is associated with the process. Valid values: Positive integer.
Total Executed DDLs	Valid for Extract and Replicat Shows the total number of Data Definition Language (DDL) operations that were processed by the selected Oracle GoldenGate process in its current run session. Valid values: Positive integer
Total Ignores	Valid for Extract Shows the total number of Data Manipulation Language (DML) operations that were ignored by the process in its current run session. Errors are included in the Total Ignores metric. Valid values: Positive integer
Total Inserts	Valid for Extract and Replicat Shows the total number of Data Manipulation Language (DML) INSERT operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process. Note: If any tables are mapped to targets in the Extract configuration, the statistics will reflect the total operations for all of the targets. Valid values: A positive integer
Total Operations	Valid for Extract and Replicat Shows the total number of Data Definition Language (DDL) and Data Manipulation Language (DML) INSERT, UPDATE, DELETE, and TRUNCATE operations that were processed by the selected Oracle GoldenGate process in this current run session. Valid values: A positive integer
Total Row Fetch Attempts	Valid for Extract Shows the total number of row fetches that the selected process performed in its current run session. A fetch must be done sometimes to obtain row values when the information is incomplete or absent in the transaction log. Valid values: Positive integer
Total Row Fetch Failures	Valid for Extract Shows the total number of row fetches that the selected process was unable to perform in its current run session. Valid values: Positive integer
Total Truncates	Valid for Extract and Replicat Shows the total number of TRUNCATE operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process. Note: if any tables are mapped to targets in the Extract configuration, the statistics will reflect the total operations for all of the targets. Valid values: A positive integer
Total Updates	Valid for Extract and Replicat Shows the total number of UPDATE (including primary key updates) operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process. Note: If any tables are mapped to targets in the Extract configuration, the statistics will reflect the total operations for all of the targets. Valid values: A positive integer

2.2.2.3 Service Manager

The Service Manager page lists all the Oracle GoldenGate Miscroservices Architecture deployments. From the Service Manager page, you can access Administration Server, Receiver Server, and Distribution Server targets. If you have multiple deployments, then you can also filter using the Deployment drop-down list.

The Service Manager page lists the following for each deployment:

• Service Name: Name of the service, for example: distsrvr:8062
• Service Type, such as Administration Server, Distribution Server, Performance Metrics Server, or Receiver Server
• Port - Port number
• Status - This is the status of the service type.

2.2.2.4 Deployment

Following are the details that you can view for each deployment.

Details	Description
Status	Status of target deployment. For example, running.
GoldenGate Home	The Oracle GoldenGate home that is created on a host computer is the directory that you choose to install the product. This read-only directory contains binary, executable, and library files for the product. The default directory path is: /ogg_install_location.
GoldenGate Etc Home	The location in which your deployment configuration files are stored including parameter files. The default directory path is: /ogg_deployment_location/etc.
GoldenGate Conf Home	The location in which each deployment information and configuration artifacts are stored. The default directory path is: /ogg_deployment_location/etc/conf.
GoldenGate SSL Home	The location in which each deployment security artifacts (certificates, wallets) are stored. The default directory path is: /ogg_deployment_location/etc/ssl.
GoldenGate Var Home	The location in which each deployment logging and reporting processing artifacts are stored. The default directory path is: /ogg_deployment_location/var.
GoldenGate Data Home	The location in which each deployment data artifacts (trail files) are stored. The default directory path is: /ogg_deployment_location/var/lib/data.
Managed by Service Manager	Indicates whether the deployment is managed by the Service Manager. Valid values: true or false.

2.2.2.5 Distribution Server

The Distribution Server displays the distribution path, and the details of each path, such as status, time taken for data movement, source and target path details, and the database name.

Path Details	Description
Distribution Server Path Name	Path Name of the Distribution Server
Status	Status of the Distribution Server. Valid values are: Running Stopped
Processing Lag	Time (number of seconds) taken to move the data from source to target.
Source	Complete path name of the Distribution server.
Target	Complete path name of the Receiver server.
DB Name	Name of the database from which the Extract target is fetching the data from.
Extract	Name of the Extract target (to which the data is fetched into) the Distribution server is connected to.

2.2.2.6 Receiver Server

The Receiver Server displays the receiver path, and the details of each path, such as status, time taken for data movement, source and target path details, and the database name.

Path Details	Description
Receiver Server Path Name	Path Name of the Receiver Server
Status	Status of the Receiver Server. Valid values are: Running Stopped
Processing Lag	Time (number of seconds) taken to move the data from source to target.
Source	Complete path name of the Distribution server.
Target	Complete path name of the Receiver server.
DB Name	Name of the database from which the Extract target is fetching the data from.
Extract	Name of the Extract target (to which the data is fetched into) the Receiver server is connected to.