IO Error: Connection Reset by Peer, Authentication Lapse 0

Issue

The connection setup tests are failing with the following error:

java.sql.SQLRecoverableException: IO Error: Connection reset by peer, Authentication lapse 0 ms.

Environment

Oracle connectors

Resolution

To resolve the error, follow the steps below:

1. If you are using a Fivetran-configured VPN or Reverse SSH, submit a Support ticket and inform us, and we can help complete the configuration.
2. Review the credentials entered in the connection setup form and ensure they are correct
3. Test connection between the SSH host and database server:
   1. Log into the SSH host and (if running a flavor of Linux) run the following command(s):
      • $ nc -v <Host IP address> 1521
      • $ telnet <Host IP address> 1521
   2. If there is a failure, check the network configuration between the SSH host and database server. Ensure a successful connection can be established and then retry the Fivetran setup tests.
4. If there is a successful connection between the SSH host and database server but the issue persists, submit a Support request and provide the following information:
   • The provider for the SSH host (for example, AWS or GCP)
   • The provider for the database (for example, AWS or GCP)
   • If they are in the same network (for example, VPC)
   • The firewall settings for each
   • Screenshot confirming successful connection between SSH host and the database server
   • Failed login attempts in SQL Developer
   • Oracle Version

Cause

There are two potential causes:

• A route may need to be configured on the Fivetran side if you are using a Fivetran configured VPN or Reverse SSH
• There may be connection issues between SSH host and the database server