Oracle® GoldenGate

Release Notes for Oracle GoldenGate Monitor

12c (12.2.1.2.0)

E79859-03

May 2017

This document introduces Oracle GoldenGate Monitor 12c (12.2.1.2.0). It is comprised of these sections:

1.1 What's New in This Release?

General Features

  • A new Java agent for Oracle GoldenGate Monitor 12c (12.2.1.2) with iSeries support was added in Release 12.2.1.2.170425, May 2017.

  • Support for Informix database is introduced.

  • Support for Monitor Jagent to withstand the Oracle GoldenGate Manager RESTful API unavailability was added.

  • Support for repository of Oracle GoldenGate Monitor Server for MySQL database was removed.

Simplification

  • The Monitor UI layout was redesigned for improved information conveyance as follows:

    Monitor Home Page Enhancements

    • Data and Alerts View is renamed to Metrics and Alerts

    • Historical Data and Alert History Tabs are consolidated as the History Tab

    • Alert Definition is renamed to Alert Management

    Metrics and Alerts Enhancements

    Clicking on an Instance node results in the following tabs displaying in right-hand panel replacing the 'Instance' diagram, Attributes table and Alerts table:

    • Process Metrics Tab

    • Manager Metrics Tab

    • Logs Tab

    • Configuration Tab

    • Alerts Tab

    • GGSCI Tab

    Capture Node Enhancements

    Clicking on a Capture node results in the following tabs displaying in right-hand panel replacing the Capture diagram, Attributes table, and Alerts table.

    • Metrics Tab

    • Logs Tab

    • Configuration Tab

    • Alerts Tab

    Delivery Node Enhancements

    Clicking on Delivery node results in the following tabs displaying in right-hand panel replacing the Delivery diagram, Attributes table, and Alerts table.

    • Metrics Tab

    • Logs Tab

    • Configuration Tab

    • Alerts Tab

    Database Node Enhancements

    Clicking on a Database node results in the Metrics tab displaying in right-hand panel replacing the Database' diagram, Attributes table, and Alerts table.

    Trial Node Enhancements

    Clicking on a Trial node results in the Metrics tab displaying in right-hand panel replacing the Trial diagram, Attributes table, and Alerts table.

    Instance Node Enhancements

    Clicking on an Instance Node results in the Configuration tab displaying in right-hand panel replacing the Trial diagram, Attributes table, and Alerts table.

    The mgr.prm and GLOBALS subtabs are displayed on the Configuration Tab. The mgr.prm subtab displays the contents of this file. You can refresh the contents of the mgr.prm file using the Refresh button and edit it using the Edit button.

    Capture' Node/Delivery Node – 'Configuration' Tab

    The Capture process related parameter file is displayed on the Configuration' Tab You can refresh the contents of this file using the Refresh button and edit it using the Edit button.

  • The configuration of Email, SNMP and CLI for alert actions was redesigned so that the User Interface (UI) is used.

  • The Solution Graph was enhanced to bookend databases.

  • The instance diagram is replaced by a tabular layout.

  • The Problem Summary and Solution title icon were removed.

  • The UI tab and subtabs appearance was modified to condense the information for better classification and ease of use.

  • Compact domain support was replaced with Extended Domain support for SQL Server.

Manageability

  • Ability to run GGSCI commands from the UI was added.

  • Ability to alert on more Monitor Points was added.

  • In addition to the Message.Code and Message.Severity attributes, you can now configure alerts using the Message.Text attribute. This new metric was added in the Metrics drop-down list on the Alert Definition Tab.

  • Monitor Alerts now include additional existing monitoring points.By default, all Monitor Alerts include the following Oracle GoldenGate Monitor Server instance Metrics for the 'Instance', 'Capture', and 'Delivery' object types :

    OGG Instance Details:
    OGG Hostname =abc.host.com
    OGG Working Directory = /root/core
    OGG Manager Port = 7650
    

Security

  • Instance Level security for the Alert Module.

Extensibility

  • Ability to run multiple Monitor Agents to services both Oracle GoldenGate Monitor and Oracle GoldenGate Monitor Enterprise Management Plug-In.

For more information on these feature and additional links to their documentation elsewhere in the product library, see "What's New?" in Administering Oracle GoldenGate Monitor.

1.2 Prerequisites

Oracle GoldenGate Monitor 12c (12.2.1.2.0) requires that the following are installed:

  • Java SE, JDK 8u40 and greater

  • WebLogic Server 12c (12.2.1) with JRF

  • One of the following supported databases:

    • Oracle 11gR2, 12c

    • Microsoft SQL Server 2008, 2012

For more information, see "Preparing to Install" in Installing and Configuring Oracle GoldenGate Monitor.

1.3 Corrected Problems

This section contains information about bugs that have been corrected. For questions on specific bugs or ticket numbers, consult Oracle Customer Support. SR is the Oracle Support SR number, and BugDB is the bug identification number. The information in this section is divided into the following releases:

1.3.1 Release 12.2.1.2.170425 — May 2017

No new bugs were added in the 12.2.1.2.170425 release.

1.3.2 Release 12.2.1.2.170215 — February 2017

Bug 21909349 - Unable to create alerts after upgrading MSSQL MON121300 to 122100

An issue where alerts were not created after upgrading from MSSQL MON121300 to MSSQL MON122100 was fixed.

Bug 21943985 - Pre-upgrade alerts throwing "An unresolvable error " after upgrading to 122100

An issue where the pre-upgrade alert An unresolvable error was thrown after upgrading to 122100 was fixed.

Bug 22004103 - Handling of missing metric by JAgent

An issue with JAgent and missing metric in Oracle GoldenGate Core was fixed.

Bug 23564507 - JAgent should stop if RMI/JMX ports are not available

An issue where JAgent continued to run without available RMI/JMX ports was fixed.

Bug 23756494 - Unavailability of Manager process by JAgent

An issue with unavailability of the Manager process was fixed.

Bug 24324655 - MON:ogg_agent.log includes warning related to monitor.jmx.port even in OEM mode

An issue where the MON:ogg_agent.log included warnings related to monitor.jmx.port in OEM mode was fixed.

Bug 24477119 - Instance status changing from "Stopped" to "Running" after Re-login

An issue where the status of Oracle GoldenGate Monitor instance was changed from Stopped to Running after re-login was fixed.

Bug 24525589 - JAgent needs to print its version in the ogg_jagent.log with any debug level

An issue where the JAgent version was not updated in the ogg_jagent.log was fixed.

Bug 25101869 - MON:ogg.agent.log is not generated if JAgent is started by startMonitorAgtInstance.sh

An issue where the MON:ogg.agent.log was not generated when JAgent was started using startMonitorAgtInstance.sh was fixed.

Bug 25289835 - JAgent support for remote monitoring using JMX

You can use JAgent to remotely monitor in OEM mode using static ports. By default, remote monitoring is disabled. You can enable this by changing the two properties jmx.enable.remote.monitoring=true, and jmx.broker.port=default (any valid port number).

1.3.3 Release 12.2.1.2.0 — October 2016

Bug 23285087 - Issue with Query String, unable to discover OGG

An issue with the query string where Oracle GoldenGate Monitor was not able to discover Oracle GoldenGate targets was fixed.

Bug 22593701 - Spelling issue in StartMonitorAgent Script

A spelling issue in startMonitorAgentInstance.sh was fixed.

Bug 20545508 - JAgent does not work with Oracle GoldenGate for Java adapter

An issue where JAgent was not functioning properly with Oracle GoldenGate for Java adapter was fixed.

1.3.4 Release 12.2.1.0 ­— October 2015

Initial Release.

1.4 Known Issues

This chapter describes issues that are known to exist in Oracle GoldenGate Monitor. The information in this section is divided into the following releases:

1.4.1 Release 12.2.1.2.170425 — May 2017

No known issues were added in the 12.2.1.2.170425 release.

1.4.2 Release 12.2.1.2.170215 — February 2017

Bug 25507045 - goldengate.jar script stops responding and is unable to discover OGG/SQL Server targets in OEM 13c

You may encounter intermittent thread deadlock issue with Oracle GoldenGate Monitor Agent during target discovery on Windows platform.

1.4.3 Release 12.2.1.2.0 — October 2016

Bug 24735971 - Jagent log display "Invalid username/password" after upgrade to 12.2.1.2.0

JAgent log can display “Invalid username/password after upgrade to 12.2.1.2.0. As a workaround, after Oracle GoldenGate Monitor Server upgrade, copy the following three property values from monitor.properties.bak to monitor.properties file located in <Monitor-Domain>/config/monitorserver/cfg/ directory.

The property values to be replaced are:

  • monitor.jmx.server.host

  • monitor.jmx.server.port

  • monitor.jmx.server.user

Next, manually verify all the other property values in monitor.properties file and replace them with the older values from monitor.properties.bak file.

1.4.4 Release 12.2.1.2 — August 2016

Schema upgrade not required for Oracle GoldenGate Monitor

Schema upgrade from 12.2.1.0.0 to 12.2.1.2.0 is not required and messages ALREADY_UPGRADED and Upgrade not necessary are displayed during readiness check. This is the standard functionality.

1.4.5 Release 12.2.1.0 ­— October 2015

No oggmon.properties in the WebLogic Server Domain After T2P

After T2P, if the target machine does not have the oggmon.properties file in the WLS_DOMAIN_HOME/cfg directory, then you must run the updateOGGMonitorConfig script on target machine in T2P.

Jagent on Windows Does Not Connect to the Monitor Server.

For Windows, if the JAgent s not connecting to the Monitor Server, then you need to add the absolute Java JDK8 path explicitly in the jagent.prm file.

For DB2 on Z/OS: JAgent Stops Unexpectedly

If JAgent should stop unexpectedly, modify the memory options in the jagent. prm file using these steps:

  1. Edit the jagent.prm file in the OGG_AGENT_INST_HOME/dirprm directory.

  2. Locate the Xms and Xmx memory options then change them to -Xms512m -Xmx550m.

  3. Go to the Oracle GoldenGate Core GGSCI console, and stop the Oracle GoldenGate Monitor Agent by executing the stop jagent command:

    GGSCI> stop jagent
    
  4. Backup your ogg_agent.log file.

  5. Start JAgent from GGSCI:

    GGSCI> start jagent
    

1.5 Oracle GoldenGate Monitor Server Documentation

For more information, see the following documents in the Oracle GoldenGate Monitor Server 12c (12.2.1.2.170215) documentation set:

1.6 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.


Oracle® GoldenGate Release Notes for Oracle GoldenGate Monitor, 12c (12.2.1.2.0)

E79859-03

Copyright © 2011, 2017, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.