Messages are automatically logged to the server log file for all Oracle GoldenGate actions, such as start and stop as well as for file access, such as parameter, report, and discard.

This topic discusses how to enable these logs for auditing. To enable or disable an audit for a specific action, run the following commands from the oms/bin directory. Enter the values you want to use for each setting:

emcli update_audit_settings
  -audit_switch="ENABLE|DISABLE"
  -operations_to_enable="name_of_operations_to_enable"
  -operations_to_disable="name_of_operations_to_disable"
  -externalization_switch="ENABLE|DISABLE"
  -directory="directory_name"
  -file_prefix="file_prefix"
  -file_size="file_size"
  -data_retention_period="data_retention_period"

You can enable or disable one or more operations using the -operations_to_enable flag. Here is a list of the Oracle GoldenGate operations and the values to use.

Operations can be combined and separated by a semicolon (;). The following is the command to enable all audit logging for the Enterprise Manager Plug-In for Oracle GoldenGate.

emcli update_audit_settings -operations_to_enable="OGG_START_TARGET;OGG_STOP_TARGET;OGG_KILL_TARGET;OGG_VIEW_REPORT;OGG_VIEW_DISCARD;OGG_VIEW_GGSERRLOG;OGG_EDIT_PARAM"

A Cloud Control user with Super Administrator privileges has the access to search for and view audit logs. This topic discusses how to search for and view a specific audit log using Cloud Control.

1. Select Setup, Security, Audit Data to open the Audit Data page.

   
   Description of the illustration audit_data_page1.png

2. Select your search criteria, such as date range, operations, or status.

   You can select specific operations from the Operations drop-down menu. For example, you can select all the operations that begin with OGG.

3. Click Search to display the search results in a grid format.
4. To view the audit log, select an audit log from the search results list.
5. Once selected, you can view audit log information in the Audit Record Details region, as shown. The Audit Record Details are updated automatically for each audit log you select. Click the General, Client Information, CMS Information, and Operation Specific Information tabs for specific information.

   
   Description of the illustration details1.png

The Discard files are displayed in the Discards sub tab under the Logs tab.

1. In the Oracle GoldenGate Home Page, click Oracle GoldenGate Replicat or Oracle GoldenGate Extract to display the Detail Metrics, Logs, and Configuration tabs.
2. Click the Logs tab and then the Discards tab to display the discard file contents.
   If there are any discard files specified in the parameter files and the file exists in Oracle GoldenGate Core, then these files are also displayed in the Discards tab as a list of Discard Files. You can specify the names of the folder, files, or file extensions of your choice. The default discard files are read from the dirrpt folder, for example, dirrpt/processName*.dsc. Note that the file name is an absolute path of the discard file or path related to the OGGCORE location and file extension can be any of the following: .txt, .discard, or .dsc. You can specify multiple discard files as follows:

   DISCARDFILE dirrpt/File1.txt, APPEND, MEGABYTES 
   DISCARDFILE dirdat/File2.txt, APPEND, MEGABYTES

The Configuration tab displays the entire parameter file in view mode. At runtime, new tabs get added on the Configuration tab for the Oracle GoldenGate properties file. There can be multiple such tabs for these files. You can modify the content of the property and parameter files.

To modify the files on the Configuration tab:

1. In the Configuration tab, click Edit to reopen the parameter file in an edit mode.

2. Click the filename (hyperlink) in the parameter file to create a new tab next to the parameter tab. The tab title is displayed as the include/obey file name.

   Note:

   The absolute path to the file is displayed at the bottom of the tab. The content of the existing include/obey file is displayed in new tab. If the file doesn't exist (for example, user-typed new file name in editing mode) the empty tab is displayed with a warning message above the text area.

3. Click Save. If you haven't modified any content, then no action is taken. If you modified the content was modified and then clicked Save , then the new content is saved.

If you want to revert the changes to the parameter configuration files, then click Reload. Changes made to the parameters file in the text area is discarded.

If you want to verify whether the property (or parameter) file is edited, then:

1. Edit the properties file from the Oracle GoldenGate Enterprise Manager Plug-In user interface and save it.

2. Go to the Oracle GoldenGate Core and check for these changes.

3. Add or remove content from the Oracle GoldenGate side and click Refresh on the Oracle GoldenGate Enterprise Manager Plug-In side.

   Existing properties files are displayed in the Oracle GoldenGate Enterprise Manager Plug-In UI.

If you are interested in viewing the data pattern of the targets and analyzing the historical trends, then you can view the details under Metric Data. You can also modify the thresholds to generate alerts.

1. Click the OGG Home tab in the Oracle GoldenGate Home page.
2. Click a target in the Target Name column to display the corresponding process page (either a REPLICAT or an EXTRACT page).
3. Click a metric from the Metrics tab to display the All Metrics page and select a Metric, such as Total Deletes to display the details, such as Statistics, Thresholds, Metric Value History chart, and Metric Alert History table.
   You can also view the Metric Value History in a tabular format, apart from the chart that is displayed by default.
4. Click Table View to display the Metric Value History table.
5. Click Modify Thresholds... to display the Modify Thresholds page.
6. Set the following values:

   Threshold

   Sample Values

   Warning Threshold

   1. If the lead value is 1, then a warning alert is generated.

   Critical Threshold

   4. If the total lead value is greater than or equal to 4, then an alert is generated.

   The generated alert is displayed in the Metric Alert History table.
7. Click the Alerts icon in the top-right corner of the All Metrics page to display the Metric Events details.
   All the metrics of the corresponding process along with the alerts are displayed in the Metric Events page.
8. In the Metric Alert History table, click the Details icon to display the Event Details and Metric Details.

The notification system allows you to notify Enterprise Manager administrators when specific incidents, events, or problems arise. In addition to notifying administrators, the notification system can perform actions such as executing operating system commands (including scripts) and PL/SQL procedures when an alert is triggered. This capability allows you to implement automatically specific IT practices under particular alert conditions.

1. Click the OGG Home tab in the Oracle GoldenGate Home page.
2. Click a target in the Target Name column to display the corresponding process page (either a REPLICAT or an EXTRACT page).
3. Select the process drop-down list and click Monitoring and then click Metric and Collection String to display the Metrics and Collection Settings page.
   There are two tabs on this page: Metrics and Other Collected Items. The Metrics tab displays all the configured metrics for the selected process. From the View drop-down list on this page, you can select the following to view the corresponding details: All metrics, Metrics with Thresholds, Metrics with Adaptive Thresholds, and Metrics with Time based Static thresholds.
4. Select All metrics and specify the Warning Threshold and Critical Threshold in the Metric table, and then click OK to save the changes.
   A threshold gets created for the respective metrics.

If you want to create incidents to be reported for a particular threshold, you need to create an incident rule. An incident rule instructs Enterprise Manager to take specific actions when incidents, events, or problems occur, such as performing notifications. An incident rule set is a collection of rules that apply to a common set of objects such as targets (hosts, databases, groups), jobs, metric extensions, or self updates, and take appropriate actions when there are events and incidents. An event is a significant occurrence of interest on a target that has been detected by Enterprise Manager. An incident is a set of significant events or combination of related events that pertain to the same issue. Create your incident rule sets and subscribe to them so that you are notified every time there is an event or incident.

1. In the Home page, click Enterprise, select Monitoring, and then click Incident Manager to display the Incident Manager page. All the open incidents are listed in this page.
   Alternatively, from the Home page, click Targets, and in the respective process page, click any Incident link in the Incident table to display the Incident Manager page that lists all the incidents for the selected target.
2. To create an Incident Rule, in the Home page, click Setup, select Incidents, and then click Incident Rule.
3. In the Incident Rule page, click Create Rule Set... to display the Create Rule Set page.
4. Enter the following details to create a Rule Set:

   • Name: Enter a name for the Rule set.

   • Applies To: Select an option, such as Targets from the Applies To drop-down list.

   • In the Targets area, select a Targets, such as Oracle GoldenGate Extract from the All targets of types drop-down list to create incident rule sets for all Oracle GoldenGate Extract targets.

5. In the Rules area, click Create... to display the Select Type of Rule to Create dialog box.
6. Select Incoming events and updates to events and click Continue.
7. In the Create New Rule: Select Events page, select Metric Alert from the Type drop-down list to define incident rule for a metric alert.
8. Click Add to display the Select Specific Metric Alert page.
9. Select a target type, such as Oracle GoldenGate Extract from the Target Type drop-down list, and then click Search to display the search results in a table.
10. Select a metric, such as Total Insert from the table
11. From the Select Severity and Corrective Action Status area, select a value, such as All from the Severity drop-down list, and then click OK.
    When a threshold is reached for the Total Inserts metrics, an alert is displayed.
12. In the Create New Rule: Add Actions page, click Next to display the Create New Rule: Add Actions page to add an action for the incident rule.
13. Click Add to display Add Conditional Actions page to add any action, such as sending an email notification.
14. In the Send Notifications area, enter an email address in the E-mail To field, and then click Continue.
15. In the Create New Rule: Add Actions page, click Next to specify a name and description for the incident rule in the Create New Rule: Specify Name and Description page, and then click Next to display the Create New Rule: Review page.
16. Click Continue to go back to the Incident Rules page.
    You can view the new rule in the Incident Rules table.
17. In the Home page, click Target, select Golden Gate to display the OGG Home and Manage Agents tabs.
18. In the OGG Home tab, click the respective Target Name to display the corresponding process page, with the Metrics, Logs, and Configuration tabs.
19. Click the respective metrics, such as Total Inserts, in the Metrics tab to view the notification that is set. An email is also sent to the recipient’s email address. Ensure that you configure the notifications as described in the next steps:
20. In the Home page, click Setup, and select Notifications, and then click Mail Servers to display the Mail Servers page.
21. In the Outgoing Mail (SMTP) Servers page, click Edit to display the Outgoing Mail (SMTP) Server dialog box.
22. Enter the Host, Port, User Name, and Password.
23. Select SSL/TLS as a Use Secure Connection option.
24. Click OK to display the Mail Servers page.
25. In the Outgoing Mail (SMTP) Servers page, click Test Mail Servers to display an Information in the top of the Mail Servers page.
    An Information is displayed in the