After successfully deploying the Enterprise Manager Plug-In for Oracle GoldenGate, you must add the plug-in target to Enterprise Manager Cloud Control for central monitoring and management.

1. In the OGG Home page, select Setup, click Add Target, and then select Configure Auto Discovery to display the Setup Discovery page.
2. In Setup Discovery page, click Advanced: Discovery Modules to go to modules page. In the Discovery Module page, you can find GoldenGate Discovery module.
3. Click GoldenGate Discovery Module to display the Configure Target Discovery for Target Types page, select the agent host name and click Edit Parameters to display the Edit Parameters: GoldenGate Discovery dialog box.
4. Enter the following information required to connect to the Oracle GoldenGate agent:

   • JAgent/Service Manager Username: Enter the Service Manager User Name in case of the MA instance. In case of a classic instance, enter the jAgent username.

   • JAgent/Service Manager Password: Enter the Service Manager Password in case of the MA instance. In case of a classic instance, enter the jAgent password.

   • JAgent RMI Port/Service Manager Port: Enter the Service Manager port for the connection in case of the MA instance. In case of a classic instance, enter the jAgent RMI Port.

   • JAgent/Service Manager Host Name: Enter the hostname of the Oracle GoldenGate instance or Cluster Virtual IP (VIP) of high availability cluster environment (HA/RAC).

     Note:

     To monitor multiple Oracle GoldenGate instances where individual Oracle Enterprise Manager agent is installed on each of the same host as Oracle GoldenGate, do not use LOCALHOST.

     Note:

     For HA/RAC environments, when the targets are promoted, the host property of the targets is updated with VIP. When these targets are relocated or failed over to another node, they are still accessible using the same monitoring details. This is because the Enterprise Manager agent continues monitoring the Oracle GoldenGate instance irrespective of where the Oracle GoldenGate instance is actually running.

   • GoldenGate (Classic or Microservices): Enter microservices if you want to discover Oracle GoldenGate microservices instance or else enter classic.

5. Click OK when finished to display the Discovery Module: GoldenGate Discovery module page.
6. In the Discovery Module: GoldenGate Discovery module page, click OK to display the Setup Discovery page.

   Target discovery has been configured on this host.

7. In the Setup Discovery page, click the Targets on Host tab.
8. Search for a target host name, and click Search.
9. Select the target host and then click Discover Now to discover targets, and click Yes in the Discover Now confirmation dialog box.
10. After the discovery is successful, click Close in the Confirmation dialog box.

Once the targets are discovered successfully, you need to promote them in order to view and monitor the targets. After the targets are promoted, they are displayed on the OGG Home page.

1. In the Targets on Host page click Discovered Targets to view a list of discovered targets.
2. From this list, select a target that you want to promote, and then click Promote to display the Custom Promotion for GoldenGate Targets page. In this page, you can deselect the processes, which are not required for promotion.

   Note:

   When you select any target, its parent targets are auto selected.
3. Click Promote in the Custom Promotion for GoldenGate Targets page.
4. Click Yes in the Confirmation dialog box if you want to manage agents.
5. After the promotion is sucessfully completed, click Close to display the Manage EM Agents for OGG instance page.
6. Select the Target Name and then click Submit.
   An Information box is displayed indicating that the changes are submitted successfully.
7. Click OGG Home to display all the targets that are promoted.

   Once a target is successfully promoted, the target is displayed on the Home page, and the Management Agent installed on the target host begins collecting metric data on the target. See Home Page Metrics.

Before verifying and validating the Enterprise Manager Plug-In for Oracle GoldenGate, you must promote the Oracle GoldenGate target that is found during auto-discovery.

1. Click the Oracle GoldenGate target link from the All Target page to open theOracle GoldenGate Home Page.
2. Select Target, Monitoring and then Metric Collection Errors to verify that no metric collection errors are reported.
3. Select Target, Information Publisher Reports to view reports for the Oracle GoldenGate target type, and ensure that no errors are reported.
4. Select Target, Configuration, Last Collected Ensure that configuration data can be seen. If configuration data doesn’t immediately appear, click Refresh on the Latest Configuration page.

Enterprise Manager provides instance-level security flexibility to provide target-level privileges to administrators.

1. Log in as a super admin (for example, sysman).
2. Select Setup, Security, Administrators to open the Administrators page.
3. Select the User for whom you need to modify the access.
4. Click Edit to modify access for an existing user.
5. Click Create/Create Like to create a new user and to assign the appropriate user roles to display the Properties tab.
6. Enter the required credentials for the new user, and click Next to open the Create Administrator userName: Roles page.

   This page lets you to assign roles to the named user by moving the role from the Available Roles column to the Selected Roles column.

7. Select one or more roles from the Available Roles list and click Move to add them to the new user.

   At a minimum, you must select the EM_BASIC_SUPPORT_REP role in addition to the preselected roles. This table shows the different roles.

   RM Role Name	Edit/View Parameter	View Report	View Discard
   EM_ALL_ADMINISTRATOR	Yes	No	No
   EM_ALL_OPERATOR	Yes	No	No
   EM_ALL_VIEWER	No	No	No
   PUBLIC	No	No	No
   EM_PLUGIN_USER	No	No	No

   Do not select any ALL roles in this step, such as EM_ALL_ADMINISTRATOR, EM_ALL_OPERATOR, and so on, else the user role you’re creating will be entitled to all OGG instances.

   Enterprise Manager (EM) supports object-level access control so administrators can be given roles for specific targets only. See Creating Roles for Systems Infrastructure Administration in the Enterprise Manager Cloud Control Administrator’s Guide.

8. Click Next to open the Target Privileges page.
9. Select the Target Privileges tab, scroll down to the Target Privileges section and select the Execute Command Anywhere and Monitor Enterprise Manager roles, and then click Add.

   These two roles are required for full functionality and multi-version support.

10. Scroll below the Privileges Applicable to All Targets table to the Target Privileges section. This section gives the Administrator the right to perform particular actions on targets. Click Add to open the Search and Add: Targets page appears in a new browser window.
11. Select the instances you want the user to have access.

    Remember:

    You’re only assigning Oracle GoldenGate instances at this time. You’re not assigning Manager, Extract, or Replicat processes.

    Here is an example of two Oracle GoldenGate instances ( port numbers 5559 and 5560). Access to only one of them (port number 5560) is being assigned to this user.

    
    Description of the illustration inst_sec_select_target.gif
12. Click Select to save the changes.

    You’re returned to the Add Targets page and the Target Privileges list is refreshed to show your selection.

13. Click the Edit Individual Privileges link under the Manage Target Privilege Grants Column, which is the third-last column from the right, to set the required privileges for the target.

    Select from the following privileges:

    Privilege Name	Description
    Full	Perform all operations on the target, including delete the target.
    View contents of OGG report file	View content of the report files for OGG targets.
    View contents of OGG discard file	View content of the discard files for OGG targets.
    Run OGG command	Run OGG commands (Start, Stop, Kill, and Resume) for OGG targets. You can also select these control operations from the Target drop-down list in the Oracle GoldenGate Home page. Select a control operation to display a confirmation dialog box. Once you click Yes in the confirmation dialog box, the action is sent to Oracle GoldenGate Core for execution. The dialog box refreshes automatically to check the progress of the command. An Error or Success of the command is displayed in the same dialog box. When you click OK, the Home page is refreshed with the latest status of the target.
    Edit OGG parameter file	Edit parameter files for OGG targets.
    Connect Target	Connect and manage target.

    Don’t select both the Full and Connect Target privileges because Full includes Connect Target .

14. Click Continue.
15. Click Review to review your user's privileges, then click Finish.

    The user now has access to the selected instance(s).

    These privileges are automatically assigned from top to bottom in the hierarchy. For example, if the Run OGG Command privilege is assigned to an OGG instance, it’s automatically assigned to all its child processes. However, you can also provide process specific privileges. Suppose the Edit OGG parameter file privilege is assigned to a process, it’s specific to that process and is not assigned to other processes in the instance.

16. Test the instance-level security to confirm that all edited processes are operating with their assigned privileges:
    1. Log in as the newly created or edited user.
    2. Select Targets, GoldenGate to open the Oracle GoldenGate page.
    3. Confirm that only the OGG instances that you have access to are visible.
    4. Log out and log in again as root.
    5. Select Targets, GoldenGate to open the Oracle GoldenGate page.
    6. You should now see all the managed OGG instances.

This topic explains the monitoring of High Availability features for Oracle GoldenGate Management Pack. For the High Availability feature to properly function with Oracle GoldenGate plug-in, virtual IP (not the physical IP) of the Oracle GoldenGate host must be provided at the time of Oracle GoldenGate target discovery.

1. Start Oracle Enterprise Manager Cloud Control.
2. Login using the provided credentials.

   The user must have sysman privilege.

3. Select Setup, Manage Cloud Control, Agents to open the Agents page.

   All the agents are listed on this page.

4. Select Targets, GoldenGate.
5. Select Setup, Add target, Configure Auto Discovery.
6. Select the host and click Discovery Modules to provide credentials details by selecting Goldengate discovery.
   See Discovering Oracle GoldenGate Targets.
7. Click Discovered Targets for a particular Agent Host Name.
   The dialog lists all the targets on hosts, select a particular host.
   1. Click Promote to promote the particular process to display a confirmation dialog box (that says Do You Want to Manage Agents now?) when the promotion process is completed.
   2. In the confirmation dialog box, click Yes to Manage Agents.

      Note:

      You can bypass the Manage Agents page that displays a confirmation page. By bypassing this page, the promotion of the Oracle GoldenGate targets happens quickly.
8. Click Submit from the Manage Agents page to display a confirmation page. However, this is an optional step.

   This page displays after successful completion of the promotion of the targets. It includes the recently promoted Oracle GoldenGate instance with a list of all EM agents where Oracle GoldenGate plug-in is deployed.

   The agent through which these targets were discovered and promoted, is shown as Master for this Oracle GoldenGate instance. All other agents are marked as None, which means that they’re not associated with this Oracle GoldenGate instance. You can select any number of these agents as Slave, and click Submit to save the changes.

   If you don't want to make any such changes, you can click Oracle GoldenGate Home and navigate back to the Oracle GoldenGate plug-in home page.

   After the process promotion, you can see the promoted target in the Oracle GoldenGate Home page.
9. If you want to start, stop, or kill the process, then navigate to the corresponding process page and then select appropriate controls.
10. Click Targets, select GoldenGate, and then select the process, which you want to either start or stop.
    You can select any of the processes, such as Extract, Replicat, or Data Pump to start or stop.
    The status of the Oracle GoldenGate processes is reflected according to the option you selected (Start/Stop/Kill) and it gets reflected in both the OGG Home page as well as Process Details page. Click Refresh to view the updates.