Software⏱️ 3 min read📅 2026-06-11

How to Fix code 17002 Error – IO Error: The Network Adapter could not establish the connection : Vendor code 17002

Learn how to fix: IO Error: The Network Adapter could not establish the connection : Vendor code 17002.

Quick Answer: Try checking your system settings or restarting.

The IO Error: The Network Adapter could not establish the connection : Vendor code 17002 error is encountered when attempting to connect to an Oracle database using SQL Developer on Manjaro Linux. This error affects users who have installed and configured Oracle SQL on their system but are unable to establish a connection. The frustration lies in the fact that this error can be caused by various factors, including incorrect listener configuration, insufficient privileges, or network issues.

Resolving this issue requires careful analysis of the root causes and application of appropriate fixes. In this guide, we will walk through the steps to troubleshoot and resolve the IO Error: The Network Adapter could not establish the connection : Vendor code 17002 error.

💡 Why You Are Getting This Error

  • The primary reason for this error is an incorrect listener configuration. The listener is responsible for managing connections to the database, but if it is not properly configured, it can cause connectivity issues. Additionally, insufficient privileges or network issues can also contribute to this error.
  • An alternative reason for this error is a missing or invalid SID_LIST_LISTENER parameter in the listener.ora file.

🚀 How to Resolve This Issue

Checking and Correcting Listener Configuration

  1. Step 1: Step 1: Verify the listener configuration by checking the listener.ora file for any syntax errors or incorrect parameters.
  2. Step 2: Step 2: Check the TNS_ADMIN environment variable to ensure it is set correctly and points to the correct Oracle product directory.
  3. Step 3: Step 3: Restart the listener service using the lsnrctl start command to apply any changes made in step 1 or 2.
  4. Step 4: Step 4: Verify that the listener is running by executing the lsnrctl status command.
  5. Step 5: Step 5: Check the database connection string to ensure it points to the correct SID and port number.

Checking TNS_ADMIN Environment Variable

  1. Step 1: Step 1: Set the TNS_ADMIN environment variable to point to the correct Oracle product directory.
  2. Step 2: Step 2: Verify that the TNS_ADMIN environment variable is correctly set by executing the echo command.
  3. Step 3: Step 3: Restart the listener service using the lsnrctl start command to apply any changes made in step 1 or 2.

🎯 Final Words

Resolving the IO Error: The Network Adapter could not establish the connection : Vendor code 17002 error requires careful analysis of the root causes and application of appropriate fixes. By following the steps outlined in this guide, users can troubleshoot and resolve this issue, enabling them to connect successfully to their Oracle database using SQL Developer on Manjaro Linux.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions