2.4.2 Create the Connection

This topic describes the systematic instructions to create the connection.

User can create the Oracle Database connection by following the process below:

  1. From the OCI GoldenGate Overview screen, click Connections.

    Note:

    User can also click Create Connection under the Get started section and move to next step
  2. On the Connections page, click Create Connection.
  3. In the Create Connection tab, complete the General Information fields as follows:

    Table 2-5 General Information

    Field Description
    Name Specify a name for the connection.
    Description

    Optional

    Specify a description that helps you distinguish this connection from others.
    Compartment Select the compartment in which to create the connection.
    Type From Oracle, select Oracle Database.
    Show advances options

    Optional

    Click the link to manage keys or add tags.
  4. From Security, select one of the following:
    • Select Use Oracle-managed encryption key, to leave all encryption key management to Oracle.
    • Select Use Customer-managed encryption key, to select a specific encryption key stored in the OCI Vault to encrypt the user’s connection credentials.
  5. From Tags, add tags to organize the resources
  6. Click Next.
  7. Complete the Connection Details fields as follows:
    1. Select an existing database in the selected compartment and complete the rest of the fields as needed.
    2. Click Change Compartment, to select a database in a different compartment. Also, maintain the following details:

      Table 2-6 Compartment Details

      Field Description
      Database Information Specify the database details.
      Database Connection String

      Optional

      Specify the database's connection string.
      Database Username Specify the username to connect to the database.
      Database Password Specify the password associated to the username provided in the previous step.
      Database Wallet

      Optional

      Drag-drop or select the wallet.zip for the database.
      • Network Connectivity: Select a traffic routing method as follows:
        • Shared endpoint: To share an endpoint with the assigned deployment. User must allow connectivity from the deployment's ingress IP.
        • Dedicated endpoint: For network traffic through a dedicated endpoint in the assigned subnet in the VCN. User must allow connectivity from this connection's ingress IPS.
        • Select a Session mode.
        • Direct, to use the local listener running on a single database node, and then select the required subnet.
        • Redirect, to use the SCAN listener used in Oracle Real Application Cluster (RAC) deployments, and then select the required subnet.
    3. Click Create.
  8. Assign the deployment details.

    Click Options icon to the extreme right, for the assigned deployment and click Test connection.

    Figure 2-40 GGC - OBCS_POC_ATP1



    Note:

    • If an error message Network-level connectivity test failed! is displayed, then you need to allow ingress rule for port 1522. For more information, refer OCI Autonomous Database Setup.
    • The user should also unlock the GGADMIN account before testing the connection.