My Oracle Support Banner

java.sql.SQLException Error Code: 17002 and IO exception: Got minus one from a read call When Establishing Connection Using Oracle JDBC Driver (Doc ID 763837.1)

Last updated on MARCH 23, 2020

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


Trying to establish a connection from DbVisualizer using JDBC Thin against an Oracle Server fails with:

An error occurred while establishing the connection.
Type: java.sql.SQLException Error Code: 17002
Io exception: Got minus one from a read call

The same error is obtained from other JDBC applications, not only DBVisualizer.

Listener.log shows the following errors:

26-JAN-2009 16:35:34 * (CONNECT_DATA=(SID=<SID>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTO =tcp)(HOST=<IP>)(PORT=<PORT>)) * establish * <SID> * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.