Oracle® Fusion Middleware

1.1 Home Page

For each process in the instance, the Oracle GoldenGate EM Plug-in home page displays:

• Target name

• Target type, such as Extract, Replicat, or Manager

• Process status

• The lag in seconds

• Sparkline graphs that display lag trends

• Total operations

• Delta operations

• Delta operations per second

• Incidents

• Time elapsed since last Oracle GoldenGate checkpoint

• Timestamp of last Oracle GoldenGate checkpoint

• Viewing summary of all Oracle GoldenGate release 11g (11.2) and later instances on a single, customizable web page.

• In depth examination into dozens of metric values and metric history.

• Automated notifications and ticket creation through incidents.

• Enhanced EM target promotion; simultaneously promoting all targets in an Oracle GoldenGate instance.

1.2 Custom Screens

The Oracle GoldenGate EM Plug-in includes custom screens for:

• Customizing the display on the home page. This allows the you to:

  • Indicate that certain Oracle GoldenGate instances should or should not be displayed on the home page.

  • Change the order of instances displayed.

  • Define an alternate display name.

  • Add a description for an instance.

• Promoting Oracle GoldenGate targets. To simplify the promotion of Oracle GoldenGate instances that may include many Extract and Replicat processes, a custom screen displays all of the processes defined for an instance and allows the user to promote all or a subset in a single action.

• To support high availability, the tab was added to Manage Agent home screen.

1.3 Supported Platforms

The Oracle GoldenGate EM Plug-in supports monitoring of the platforms where Oracle GoldenGate 11g (11.2 and later) instances can run with the following exceptions: HP NonStop and DB2 for i.

1.4 Versions Supported

The Oracle GoldenGate EM Plug-in has been certified on the following product releases:

• Enterprise Manager Cloud Control 13c Release 1 (13.2.1.0.0) and later.

• Oracle GoldenGate versions supported include:

  • Oracle GoldenGate 12c (12.2.0.1.0) and higher.

  • Oracle GoldenGate 12c (12.1.2.1.0) and higher.

  • Oracle GoldenGate 12c (12.1.2.0.1) and higher.

  • Oracle GoldenGate 11g Release 2 (11.2.1.0.20) and higher.

• Oracle GoldenGate Monitor Agent 12c (12.2.1.0.0) and later is required and is the minimum version required to support Start, Stop, Kill, and Edit features.

8.1 Unable to start the Extract parameter in HP-UX-ias 64

I you are unable to start the Extract parameter in HP-UX-ias 64 environment, you can disable the enablemonitoring parameter from the GLOBAL file as a workaround.

8.2 JDK 7 Update 2 Requirement

For IBM i, Java Platform Standard Edition (Java SE) Development Kit (JDK) 7 Update 2 or later is required with Oracle GoldenGate Monitor Agent 12.2.1.0.0 release.

8.3 Not Able to Start JAgent from GGSCI Console

If JAgent fails to establish a connection with Oracle GoldenGate Monitor server or could not be started from GGSCI console in an Windows environment, you can add the complete Java installation path in jagent.prm file as a workaround.

8.4 Unable to Remove Oracle GoldenGate Core Instance from Oracle GoldenGate Enterprise Manager User Interface

If you are unable to remove Oracle GoldenGate core instances from the Oracle GoldenGate Enterprise Manager interface, you can navigate to Add Target, select Configure Auto Discovery, and then select Managed Target. Select the particular target to remove and click the Remove button.

8.5 Download Failure

When downloading the Enterprise Manager Plug-in for Oracle GoldenGate as previously described, you may encounter an error when the download it initiated. The output would look like this:

Downloading file in staging directory
/scratch/aime/WORKEM12104/mw2587/gcinst2587/em/EMGC_OMS1/sysman/stage/034148593e245c3de050f00a82634a7f ...
Staging directory cleaned up.
Download failed: Exception: Error downloading file: Server returned invalid
response. Status Code = 200, Response Text = [OK | <results>
   <error>
       <id>10-013</id>
       <message>Choose valid parameters.</message>
   </error>
</results>
]

To solve this problem:

1. Clean up in the self update location. For example:

   Middlewarehome/gcinst/em/EMGC_OMS1/sysman/cache/selfupdate
   

2. Check whether Enterprise Manager is pointing to staging or production. If it is pointing to staging, then run the following command to point to production:

   emctl set property -sysman_pwd welcome1 -name oracle.sysman.emSDK.core.mos.mos_url -value https://support.oracle.com
   

8.6 Oracle Application Development Framework (ADF) Error while Monitoring Oracle GoldenGate Instances

Clicking on Log and Configuration tab within the Enterprise Manager interface can cause ADF error while monitoring Oracle GoldenGate instances on Linux.

You can close the browser and login again to recover from the error.

Figure 1 ADF Error in Enterprise Manager Interface

9.1 Viewing the Oracle GoldenGate Knowledge Base

To view the Oracle GoldenGate Knowledge Base, follow these steps:

1. Browse to the My Oracle Support web site at http://support.oracle.com.

2. Select your language and then log in with your email and Oracle password.

3. Click the Knowledge tab.

4. In the Select a product or product line field, enter GoldenGate, and then select an Oracle GoldenGate product from the context-sensitive list to narrow your results. (You may have to wait a few seconds for this list to appear).

5. In the Enter search terms field, enter a search keyword or multiple keywords to focus the query.

Additional information about how to use this tab is obtained by clicking Help.

9.2 Creating an Oracle GoldenGate SR Ticket

If you cannot find an answer to your question or problem in the Knowledge Base, you can open a support request ticket with Oracle Support by following these steps:

1. Browse to the My Oracle Support web site at http://support.oracle.com.

2. Select your language, and then sign in with your credentials. If you have not done so, you will have to register to use this web site.

3. Click the Service Requests tab.

4. Click Create SR.

5. Use the Create Service Request wizard to complete and submit your SR. Additional information about how to use this tab is obtained by clicking Help.