3 Setting the Credentials

Credentials — Overview

The Enterprise Manager Credential subsystem enables the Enterprise Manager Administrators to store credentials in a secure manner — as preferences or operation credentials. The credentials can then be used to perform different system management activities, such as real-time monitoring, patching, provisioning, and other target administrative operations.

You need to set the Preferred Credentials for Oracle GoldenGate classic instance and for Oracle GoldenGate microservices (MA) instance, you need to set the Monitoring Credentials.

Named Credentials

To set a preferred credential, you must first create a named credential. Credentials are stored within Enterprise Manager as named entities. Administrators can define and store credentials within Enterprise Manager and refer to the credential by a credential name.

Preferred Credentials

Preferred credentials are used to simplify access to the managed targets by storing target login credentials in the Management Repository. With a preferred credentials set, you can carry out administrative operations by using the job system without being prompted to log in to the target. Preferred credentials are set on a per user basis, thus ensuring the security of the managed enterprise environment. The credentials are hierarchical in nature. For example, if credentials are provided for Oracle GoldenGate target type, then by default, they are applicable to its child target types as well, which means that they are applicable for Oracle GoldenGate Extract, Manager, or Replicat processes

Default Preferred Credentials

Default preferred credentials can be set for a particular target type and are available for all the targets of the target type. These credentials are overridden by target preferred credentials.

Target Preferred Credentials

Target credentials are preferred credentials set for a particular target.

Setting Preferred Credentials for Oracle GoldenGate Classic Instance

Before you set the preferred credentials, you need to create named credentials for the Oracle GoldenGate instance.

Creating Named Credentials

To create named credentials:
  1. Navigate to the Setup menu, select Security, then select Named Credentials, and then click Create.
  2. Enter an appropriate name and description for the credential.
  3. Select Oracle GoldenGate from the Authenticating Target Type drop-down list.
  4. Select OGG Credentials from the Credential Type drop-down list.
  5. Select the scope.
    If you select Global, this named credential becomes applicable for all Oracle GoldenGate targets.
    If you select Target, then:
    1. Select Oracle GoldenGate as the target type.
    2. Select the Oracle GoldenGate instance for which this named credential is applicable.
  6. Enter the jagent user name and password in the credential properties.
  7. You can Test and Save the credentials.

Setting Preferred Credentials for Oracle GoldenGate Target

To set the preferred credentials for Oracle GoldenGate target:
  1. Navigate to the Setup menu, select Security, then select Named Credentials.
  2. Select Oracle GoldenGate.
  3. Click Managed Preferred Credentials.
Credential Sets for Oracle GoldenGate Target
Host Credential
Host Credential is the credential to login to the EM host machine. It is used by the Enterprise Management agent to communicate with the Enterprise Manager Plug-In Oracle GoldenGate.
OGG Admin Credentials
OGG Admin Credentials is the credentials of Oracle GoldenGate Monitoring Agent (jAgent). The username is defined in the config.properties in jAgent installation.
Setting Default or Target Preferred Credentials for Oracle GoldenGate

If you want to set a preferred credential for Oracle GoldenGate, which is applicable for all Oracle GoldenGate targets, then go to Default Preferred Credentials.

If you want to set a preferred credential for Oracle GoldenGate applicable only to a specific Oracle GoldenGate target, then go to Target Preferred Credentials.

To set default or target preferred credentials:

  1. Select the Oracle GoldenGate instance.

  2. Select OGG Admin Credentials as Credential Set.

  3. Click Set.

  4. Select the named credentials that you created in Creating Named Credentials. Only those named credentials with scope as global appears in the list.

  5. Repeat steps 3 to 4 for Host Credentials as Credential Set.

  6. You can Test and Save the credentials.

Monitoring Credentials for Oracle GoldenGate Microservices

To set the monitoring credentials for Oracle GoldenGate microservices (MA) instance
  1. Navigate to the Setup menu, select Security, then select Monitoring Credentials.
  2. Select Oracle GoldenGate target, click Manage Monitoring Credentials to display the Oracle GoldenGate Monitoring Credentials page.
  3. For the target, select OGG Rest Credentials Set and click Set Credentials.
    Note that you shouldn't modify the Monitoring OGG Credentials set.
  4. Enter the service manager username and password and click Save.
  5. Click Save.