Troubleshoot connectivity issues

Learn about some common issues you may encounter with connections and how to address them.

Related Topics

Troubleshoot connectivity issues with Oracle Database

Learn to troubleshoot connectivity issues in OCI GoldenGate for on-premises databases or third-party cloud databases.

Connectivity issues are among the most common errors encountered in OCI GoldenGate. If you experience an issue connecting to your on-premises database or a database running in a third-party cloud, the following tips may help you troubleshoot:

  1. Ensure you review the instructions to Create a connection to Oracle Database.
  2. In the Network connectivity section, if you selected Dedicated endpoint for Traffic routing method:
    1. For Real-Application Cluster (RAC) databases using Single Client Access Name (SCAN), you must select Redirect for Session mode, and then enter the SCAN listener FQDN.
    2. For non-RAC databases, you can enter any FQDN (fully qualified database name). It doesn't have to be the name of a database. It does, however, have to be unique within the Compartment and in a valid format. For example, somehost.example.com.
    3. You must refer to the FQDN entered in the Database connection string field, for example, somehost.example.com:1521/myservicenameexample
    If you enter an IP address, OCI GoldenGate converts it to an FQDN. For example, if you enter 10.0.1.43, OCI GoldenGate converts it to ip-10-0-1-43.ociggsvc.oraclevcn.com and ensures that it's resolvable within the selected subnet.

    Note:

    If you don't refer to the FQDN provided in the Database connection string, then OCI GoldenGate won't be able to connect to the database, and you could encounter the following error messages:
    • Error - OGG-08110 Login failed. OCI Error ORA (status = 12170-ORA-12170: TNS:Connect timeout occurred)
    • Error - OGG-08110 Login failed. OCI Error ORA (status = 12154-ORA-12154: TNS:could not resolve the connect identifier specified
  3. You can connect to databases outside of Oracle Cloud Infrastructure (OCI) using a private network connection.
    1. Ensure that you select Dedicated endpoint, which allows connectivity from OCI GoldenGate to the database node's private IP.
    2. (Oracle Databases only) Select the appropriate Session mode. Choose Direct to use the local listener running on a single database node, or Redirect to use the SCAN listener used in RAC deployments.
    3. Select a subnet that has access to the FQDN that you provided (optional for RAC databases). OCI GoldenGate creates a reverse connection private endpoint in that subnet to access your database.

      Note:

      If you're trying to connect to an on-premises database or a database running in a third-party cloud, you must ensure that you configure OCI Networking to enable access from the subnet you provided into the network where the database resides. OCI offers different ways to achieve this, including FastConnect or IPSec VPN.
    4. You must create security rules that allow ingress from the subnet provided for port 1521, or whatever port you're trying to access. If you don't create this security rule, then OCI blocks traffic to this port.
  4. After creating the connection, review its details. Observe the Ingress IPs field. It may contain one or more IP addresses. The connection to the database from 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 into the database node's private IP.
    • If you selected Shared endpoint for Routing method, the connection from OCI GoldenGate originates from the Ingress IPs listed in the Assigned deployments table section.
    • If you selected Dedicated endpoint for Routing method, the connection from OCI GoldenGate originates from the Ingress IPs listed in the Connection information section.

Troubleshoot issues with Data Transforms connections

Learn how to address connectivity issues with connections in OCI GoldenGate Data Transforms.

If you encounter Test connection errors when you attempt to create a connection in the OCI GoldenGate Data Transforms deployment console, then ensure that you create and assign a Generic connection type to the Data Transforms deployment for each connection you use in OCI GoldenGate Data Transforms.

Learn more about Supported connection types for Data Transforms.