Managing Connections
To perform migration, create connections to your source and target databases by creating database connection resources. Database Connection resources enable network connectivity to the source and target databases.
Creating Oracle connections
Oracle Cloud Infrastructure Database Migration database connection resources contain the connectivity details of the migration source and target databases. Create connection database resources in the Database Migration Databases Connections page for the following databases:
- Oracle Autonomous Database
- Oracle Database
- Oracle Exadata
- Amazon RDS for Oracle
Oracle Cloud Infrastructure Database Migration service runs network connectivity tests followed by database login tests (to validate credentials) using the information that you provided while creating database connections. See Testing Connectivity of a Database Connection.
If the source database is a multitenant container database (CDB), and you are performing an online migration, you must create two connection entries for the source database: one for the PDB and one for the CDB. For offline migrations only the PDB connection is required.
You will create only one database connection resource for the target database.
Creating an Oracle Autonomous Database connection
Create an Oracle Autonomous Database connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
When the resource creation is complete and successful, check the Security Vault service to verify that the SSH private key file was uploaded and enabled in the vault you configured.
Creating an Oracle Database connection
Create an Oracle Database connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
When the resource creation is complete and successful, check the Security Vault service to verify that the SSH private key file was uploaded and enabled in the vault you configured.
Creating an Oracle Exadata connection
Create an Oracle Exadata connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
When the resource creation is complete and successful, check the Security Vault service to verify that the SSH private key file was uploaded and enabled in the vault you configured.
Creating an Amazon RDS for Oracle connection
Create an Amazon RDS for Oracle connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
When the resource creation is complete and successful, check the Security Vault service to verify that the SSH private key file was uploaded and enabled in the vault you configured.
Creating MySQL connections
Create MySQL connections to connect to the MySQL databases.
Related Topics
Creating an OCI MySQL Heatwave connection
Create an OCI MySQL Heatwave connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
Creating a MySQL Database Server connection
Create a MySQL Database Server connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
Creating an Amazon RDS for MySQL connection
Create an Amazon RDS for MySQL connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
Creating an Azure Database for MySQL connection
Create an Azure Database for MySQL connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
Creating an Amazon Aurora MySQL connection
Create an Amazon Aurora MySQL connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
Creating a Google Cloud SQL for MySQL connection
Create a Google Cloud SQL for MySQL connection by performing the following steps:
After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.
You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.
Testing Connectivity of a Database Connection
- Incorrect IP address and/or port.
- Incorrectly declaring a connection public or private.
- Incorrect, expired, or locked database credentials.
- Missing entries in security lists or NSGs to allow communication with database IP or port.
- Connection failures through FastConnect, VPN, or any other network connectivity issues for your on-premises database.
Oracle Cloud Infrastructure Database Migration service runs a network connectivity check followed by JDBC Connection or Socket Connectivity using the Database Connection data that you provide.
- From the action menu (three dots), select Test connection.
- Select the database connection, which opens the Database connection details page and click the Test connection button.
The Test connection dialog is displayed.
- Result of the connection test.
- Error codes and the accompanying error messages.
- Cause: The issue causing the connection failure.
- Action: The action you can perform to resolve the error.
Viewing Connection Details
Database connection details page
On the Database connection details page you can view a list of your Connections in a table, which includes the following information:
-
Name of the Connection resource
-
State of the Connection resource, which can be any one of the following:
-
Creating: The new Connection resource is being created in OCI.
-
Updating: Changes to the Connection resource are being registered in OCI.
-
Active: The Connection resource has finished being created or updated and is ready for use.
-
Inactive: A fallback state for unexpected errors.
-
Deleting: This state appears when you delete a Connection resource. The resource remains in this state until deletion is completed, at which point the resource is no longer listed in the console.
-
Failed: There are problems with the Connection resource. You can review the Connection resource work requests to investigate the issue.
-
-
Created date and time
Database connection details page
Select a Connection from the Database connection details to view its details.
On the Database connection details page you can view the Connection information, including:
- OCID: The resource's unique Oracle Cloud ID.
- Compartment: The compartment where the Connection resides.
- Created: The date and time when the Connection was created.
- Encryption Vault: The link takes you to the Vault Details page.
- Encryption Key: The link takes you to the Key Details page
- Subnet: The link takes you to the Subnet Details page.
- Database Type: Autonomous Database, Database (BareMetal, VM, Exadata), VM Cluster Database (Exadata), Oracle, or Amazon RDS
- Database: For OCI co-managed databases--Autonomous Database, Database (BareMetal, VM, Exadata), VM Cluster Database (Exadata)--the display name of this Connection is also shown. The link takes you to the Database Details page in OCI.
Network security groups
- You can associate NSGs available in your VCN to the connection. The NSGs that are listed for a subnet are only applicable to your current VCN.
- You can add network security groups in Database Migration Service to control traffic, if you have connected over private endpoints while registering databases. The advantage of network security groups (NSGs) is that rules can be limited to individual resources within a subnet, whereas Security Lists apply to all resources within a subnet.
- Associating NSGs to database connections provides you fine grained control over the access to your database connection resources that are involved in the migration process (Source and Target). See Network Security Groups for more information.
- Click Add network security groups to open the Add network security groups panel.
- Select a network security group from the compartment and click Add network security groups.
- You can add up-to five unique network security groups by clicking on Another network security group.
-
Name : The name of the added network security group.
-
State: The state of the network security group.
-
Compartment : The compartment where the network security group resides.
-
Created : The date and time when the network security group was created.
Select single or multiple network security groups to remove them by clicking Remove in the Remove network security groups confirmation dialog.
Select View details from the actions menu (three dots) for a specific NSG to view information related to VCN.
Work Requests
On the Database connection details page, under the Connection information box you can find the Work Requests list. Work Requests lists any work requests sent to OCI to facilitate the creation, update, or deletion of this resource. Click the work request to go to the Work Request Details page for more information about the work request.
Moving a Connection
You can move a Connection from one compartment to another.
To move a Connection:
After you move the Connection to the new compartment, inherent policies apply immediately and may affect access to the Connection through the Console. For more information, see Managing Compartments.
Deleting a Connection
Before you delete a Connection, ensure that you carefully review any resources that reference the Connection. It is not possible to delete a Connection if it is references by a migration. You must delete the migration before deleting the associated Connections.
Deleting a Connection also deletes the private connection and database credentials, so it will no longer be accessible to migrations. After you delete a Connection, it cannot be restored.
Connections also capture and synchronize database credentials to Database Migration. Any change made to the credential, such as updating or deleting, synchronizes to Database Migration. You will encounter issues when the Replicat or Extract attempts to reconnect to a deleted Connection.
Managing Tags for Connections
Tags help you locate resources within your tenancy. You can add and view a connection's tags from the Database Connections page and from the Database connection details page.
On the Database connection details page, from the Connection's Actions (three dots) menu, select Add Tags or View Tags.
On the Database connection details page, you can select Add Tags above the Connection Information box, or click the Tags tab to view and edit tags.
See Managing Tags and Tag Namespaces to learn more about tagging.
Using the Connection API
You can use the following operations to manage Connection resources:
- CreateConnection
- GetConnection
- ListConnections
- UpdateConnection
- DeleteConnection
- ChangeConnectionCompartment
For information about using the API and signing requests, see REST APIs and Security Credentials. For more information about SDKs, see Software Development Kits and Command Line Interface.