8.1.2 Setting Credentials for Oracle GoldenGate Targets

8.1.2.1 Setting Credentials for Oracle GoldenGate Classic Instance

To set preferred credentials for an Oracle GoldenGate classic instance, you need to set both the Host credentials as well as the OGG Admin credentials.

To set preferred credentials:
  1. Navigate to the Setup menu, select Security, then select Preferred Credentials.
  2. On the Preferred Credentials page, type goldengate in search box, then click Search.
  3. Under the Target Type column, click Oracle GoldenGate to highlight the row, then click Manage Preferred Credential
  4. On the Oracle GoldenGate Preferred Credentials page, you can create both the Default Preferred Credentials as well as the Target Preferred Credentials.

    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.

  5. Under Default Preferred Credentials, select the Host Credentials credential set, and click Set to display the Select Named Credential dialog box. Create new or use existing credential that can be used to login to the EM Agent host machine.
  6. Under Default Preferred Credentials, select OGG Admin Credentials credential set, and click Set to display the Select Named Credential dialog box. Create new credential by entering the same Monitor Agent Username and Monitor Agent Password credentials that were used to discover this GoldenGate instance.
  7. Under Target Preferred Credentials, click a target with Host Credentials credential set, then click Test by wrench icon. It brings up the Test Named Credential page. Keep the Test Type as Basic, and click Test button. Ensure all targets with Host Credentials credential set are tested with successful results.

8.1.2.2 Setting Credentials for Oracle GoldenGate Microservices Instance

Monitoring credentials are set by default after discovery. Choose to modify them if and when the credentials change. You can set Host and Monitoring credentials for Oracle Administration Service too if the credentials are different than Service Manager, or Oracle GoldenGate Deployment in-case of OCI GoldenGate Service.

8.1.2.2.1 Setting Preferred Credentials

These credentials are applicable only to the Service Manager's child targets (Extract and Replicat) or the child targets of Oracle GoldenGate Deployment in case of OCI GoldenGate Service.

To set the Preferred credentials for the Oracle GoldenGate Service Manager (Oracle GoldenGate Deployment in case of OCI GoldenGate Service):

  1. Navigate to the Setup menu, select Security, and then select Preferred Credentials to display the Security > Preferred Credentials page.
  2. Select the Oracle GoldenGate Service Manager Target Type. In case of OCI GoldenGate Service, select the Oracle GoldenGate Deployment Target Type. Click Manage Preferred Credentials to view the Oracle GoldenGate Service Manager Preferred Credentials page. Note that in case of OCI GoldenGate Service, you can view the Oracle GoldenGate Deployment Preferred Credentials page.
  3. Under Default Preferred Credentials, select Host Credentials, and click Set to display the Select Named Credential dialog box.
  4. Click New to enter the EM Agent UserName, Password, and Confirm Password. Use credential that can be used to login to the EM Agent Host machine.
  5. Click Save to save the new credentials.
    The Preferred Credentials are set and an information that the Named credential association has been completed successfully is indicated on the screen.
  6. If you want to change the credentials for the Oracle GoldenGate Administration Service, then you can set the credentials under Oracle GoldenGate Administration Service Target type. This is an Optional Step.

8.1.2.2.2 Setting Monitoring Credentials

These credentials are applicable only to the Service Manager's child targets (Extract and Replicat) or the child targets of Oracle GoldenGate Deployment in case of OCI GoldenGate Service.

To set the Monitoring credentials for the Oracle GoldenGate Service Manager (or Oracle GoldenGate Deployment in case of OCI GoldenGate Service):

  1. Navigate to the Setup menu, select Security, and then select Monitoring Credentials to display the Security > Monitoring Credentials page.
  2. Select Oracle GoldenGate and click Manage Monitoring Credentials to view the Oracle GoldenGate Service Manager Monitoring Credentials page. In case of OCI GoldenGate Service, select Oracle GoldenGate Deployment to view the Oracle GoldenGate Deployment Monitoring Credentials page.
  3. Select the Target under Target type.
  4. Enter the Username, Password, and Confirm Password, click Save and Close. You need to provide Service Manager user name and password here in order to administer Oracle GoldenGate Microservices targets.
    In case of OCI GoldenGate Service, you need to provide the GGS User Name and Password in order to administer the Oracle GoldenGate Microservices target.
    The Monitoring Credentials are set and an information that the credentials are set successfully is shown on the screen.

    Note:

    If there are any changes to the Service Manager or Deployment credentials for OCI GoldenGate Service in Oracle GoldenGate Core, then you need to include the same as Monitoring credential for the Service Manager (and Deployment target in case of OCI GoldenGate Service).
  5. If you want to change the credentials for the Oracle GoldenGate Administration Service, then you can set the credentials under Oracle GoldenGate Administration Service Target type. This is an optional step.

    Note:

    If you have set the Administration Service credentials, then the credentials are applicable only for its child target types.