Manage connections

Learn connection management tasks including how to edit, unassign, move, and delete connections.

View connection details

Select a connection from the Connections list to view its details. On the Connection details page, you can:

  • View the connection's status, which can be one of the following:
    • Creating
    • Updating
    • Active
    • Deleting
    • Deleted
    • Failed
  • Perform actions on the connection such as, edit, move, add tags, and delete
  • View connection information such as:
    • the connection's OCID
    • the compartment the connection was created in
    • when the connection was created
    • network information

      Note:

      For MySQL databases, OCI GoldenGate generates the Host value depending on the IP you provide during creation.
    • connection type
  • View, assign, or unassign deployments
  • View, add, edit, or remove network security groups (NSGs)

    Note:

    Adding network security groups (NSGs) gives you fine grained control over traffic between a deployment and the source or target systems within your subnet. Learn more.
  • View the connection's work requests

Edit a connection

Note:

For users with Autonomous Database connections, editing and saving the connection automatically retrieves the latest wallet version.
To edit a connection:
  1. From the Connections page, select a connection to edit.
    You can also select Edit from the connection's Action (ellipsis icon) menu, and then skip to step 3.
  2. On the Connection Details page, click Edit.
  3. In the Edit Connections panel, edit the values you want to update, and then click Save Changes.
The changes are automatically synchronized to the OCI GoldenGate deployment that it's assigned to.

Assign a deployment to a connection

When you're on the Connections details page, you can assign deployments to the connection.
To assign a deployment to a connection:
  1. On the Connections details page, under Resources, click Assigned deployments.
  2. Click Assign deployment.
  3. In the Assign deployments dialog, select a connection from the dropdown. Click Change Compartment, to select a connection from a different compartment.
  4. Click Assign deployment.
The selected connection appears in the Assigned deployments list. You can also view and manage this relationship from the Deployment details page, under Assigned connections.

Unassign a deployment

You can remove, or unassign, a connection from a deployment. First ensure that there are no active processes running in your deployment that involve the connection you want to remove.
To unassign a deployment:
  1. On the Connection details page, under Resources, click Assigned deployments.
  2. From the Actions (ellipsis icon) menu for the deployment you want to unassign, select Unassign.
  3. In the Unassign deployment dialog, confirm that you want to unassign the connection from this deployment, and then click Unassign deployment.
The deployment no longer appears in the Assigned deployments list. Unassigning a connection from a deployment doesn't delete the connection. If you want to delete the connection see, Delete a connection.

Move a connection

To move a connection:
  1. On the Connection Details page, click Move resource. You can also select Move connection from the connection's Actions (ellipsis icon) menu on the Connections page.
  2. In the Move to another compartment dialog, select the compartment in which to move the connection.
  3. Click Move resource.

Manage tags for a connection

Tags help you locate resources within your tenancy. You can add and view a connection's tags from the Connections page and from the connection details page.

On the Connections page, from a connection's Action menu (ellipsis icon), select Add Tags or View Tags.

On the connections details page, you can select Add Tags from the More Actions menu, or click the Tags tab to view and edit tags.

Delete a connection

Before you delete the connection, ensure that there are no processes running in the deployment that involve the connection. Consider unassigning the connection from deployments before you delete it.
To delete a connection:
  1. On the Connections page, select the connection you want to delete. You can also select Delete from the connection's Actions (ellipsis) menu in the Connections list, and then skip to Step 3.
  2. On the Connections details page, click Delete.
  3. In the Delete connection dialog, confirm that you want to delete the connection, and then click Delete.

Known issues

Action Required for Autonomous Databases that Use mTLS Authentication

When an Autonomous Database wallet is rotated, the OCI GoldenGate connection to this database must be refreshed to retrieve the latest wallet information.

For more information see, My Oracle Support (MOS) Document 2911553.1.

To refresh an Autonomous Database connection: Edit and save the connection to the Autonomous Database (Autonomous Transaction Processing or Autonomous Datawarehouse). Saving the connection automatically downloads and refreshes the wallet. No other changes to the connection is needed.

To verify:

  1. Launch the deployment console for a deployment that uses the Autonomous Database connection.
  2. In the deployment console, open the navigation menu, and then click Configuration.
  3. On the Credentials screen, observe the Autonomous Database connection string.

    Before the wallet is refreshed, the connection string looks like the following:

    ggadmin@(DESCRIPTION=(TRANSPORT_CONNECT_TIMEOUT=3)(CONNECT_TIMEOUT=60)(RECV_TIMEOUT=120)(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-phoenix-1.oraclecloud.com))(CONNECT_DATA=(COLOCATION_TAG=ogginstance)(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(OVERRIDE=TRUE))(service_name=<adb-servicename>_low.adb.oraclecloud.com))(security=(MY_WALLET_DIRECTORY=“/u02/connections/ocid1.goldengateconnection.oc1.phx.<ocid>/wallet”)(SSL_SERVER_DN_MATCH=TRUE)(ssl_server_cert_dn=“CN=adwc.uscom-east-1.oraclecloud.com,
            OU=Oracle BMCS US, O=Oracle Corporation, L=Redwood City, ST=California,
            C=US”)))

    After the wallet is refreshed, the connection string is updated to look like the following:

    ggadmin@(DESCRIPTION=(TRANSPORT_CONNECT_TIMEOUT=3)(CONNECT_TIMEOUT=60)(RECV_TIMEOUT=120)(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-phoenix-1.oraclecloud.com))(CONNECT_DATA=(COLOCATION_TAG=ogginstance)(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(OVERRIDE=TRUE))(service_name=<adb-servicename>_low.adb.oraclecloud.com))(security=(MY_WALLET_DIRECTORY=“/u02/connections/ocid1.goldengateconnection.oc1.phx.<ocid>/wallet”)(SSL_SERVER_DN_MATCH=TRUE)(ssl_server_dn_match=yes)))