Manage connections
Learn connection management tasks including how to edit, unassign, move, and delete connections.
Related Topics
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, refresh, move, add tags, and delete
- View connection information such as:
- The connection's OCID
- The compartment in which the connection was created
- When the connection was created and updated
- Encryption key management
- Network information
- View and edit the connection's subnet
Note:
If you change the subnet, the connection's Ingress IPs and Private IP also changes. - Traffic routing method, either Shared or Dedicated
- The Ingress IP show one or more IP addresses. The connection endpoint for OCI GoldenGate originates from one of these IP addresses. You must ensure that the appropriate subnet security rules are in place to allow connectivity from these IP addresses to the database's private IP.
- Private IPs get rewritten in the format,
ip-xx-xx-xx-xx.ociggsvc.oracle.vcn.com
.
- View and edit the connection's subnet
- Connection type and connectivity information specific to that type, including the password secret for Autonomous Database users
- View, assign, unassign, and test connections
- View, add, edit, or remove network security groups (NSGs) for
connections with Dedicated endpoints
Note:
Connections with Shared endpoints inherit NSG settings from the assigned deployment. 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 Autonomous Database connections, editing and saving the connection automatically retrieves the latest wallet version.WARNING:
- You must only create and edit connections in the Oracle Cloud console. Refrain from creating or editing connections in the Credentials screen of the deployment console. Updates are automatically synced to the deployment from the Oracle Cloud console.
- Changes made to the connection string result in the use of new Ingress IPs for that connection and may require you to update firewall settings to prevent disruptions to your Extracts and Replicats.
Assign a deployment to a connection
- On the Connections details page, under Resources, click Assigned deployments.
- Click Assign deployment.
- In the Assign deployments dialog, select a connection from the dropdown. Click Change Compartment, to select a connection from a different compartment.
- Click Assign deployment.
Unassign a deployment
- On the Connection details page, under Resources, click Assigned deployments.
- From the Actions (ellipsis icon) menu for the deployment you want to unassign, select Unassign.
- In the Unassign deployment dialog, confirm that you want to unassign the connection from this deployment, and then click Unassign deployment.
Test connections
After you assign connections to a deployment, test the connectivity to ensure the deployment can connect to them.
Test connection performs two types of tests: network-level and application-level. Network-level connectivity tests check that the host and port are reachable from the deployment, while application-level tests check that the credentials are valid by logging into the endpoint.
Some connections perform both tests, while others, such as Big Data connection types, don't currently support application-level tests. As long as your connection passes network-level connectivity tests, you can use your connection and start creating extract and replicat processes.
Before you test a connection, ensure that you first create and assign a connection to the deployment.
Move a connection
- 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.
- In the Move to another compartment dialog, select the compartment in which to move the connection.
- 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
- 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.
- On the Connections details page, click Delete.
- 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:
- Launch the deployment console for a deployment that uses the Autonomous Database connection.
- In the deployment console, open the navigation menu, and then click Configuration.
- 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)))
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.