Testing connectivity of a database connection

You can test the connectivity of a database connection before you start or create a migration. You can get information about the connection and fix any configuration issues before running the migration.

You can diagnose issues with a database connection such as:

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

To test the connectivity of a database connection use either of the following methods:

• From the action menu (three dots), select Test connection.

• Select the database connection, which opens the Database connection details page and in the Actions menu select the Test connection button.

Note: If you are connecting to an AWS database, make sure that your VPC security group is configured to allow connections from the IP address listed in the connection details.

The Test connection dialog is displayed.

The Test connection dialog displays the following details:

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