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:

General information:

• 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.

• Updated: The date and time when the Connection was updated.

• 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.

Technology information:

• 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.

• Initial load database username

• Replication database username

Network security groups

On the Database connection details page, you can find the Network security groups that can be associated, with this database connection.

Note:

• 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. __COMMENT_2__

1. Select Add network security groups to open the Add network security groups panel.

2. Select a network security group from the compartment and click Add network security groups.

3. You can add up-to five unique network security groups by clicking on Another network security group.

You can view the following details associated with the Network security groups Resource:

• 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, 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.