SQL Developer Vendor Code 17002


When connect to an 11i E-Business Suite database using SQL Developer, the following error appears:

An error was encountered performing the requested operation:

IO Error: Connection reset

Vendor code 17002

Sometimes, the error reads:

An error was encountered performing the requested operation:

IO Error: Got minus one from a read call

Vendor code 17002

Issuing the tnsping command against the instance returns the following:

C:>tnsping vis3

TNS Ping Utility for 32-bit Windows: Version - Production on 02-MAY-2012 10:21:29

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=oel5vis3.localdomain)
TNS-12537: TNS:connection closed

Pinging the instance on the database node completed successfully.

The problem started occurring after applying ATG RUP7.


AutConfig was run as part of applying ATG RUP 7 patches. This regenerated the sqlnet.ora, which included the following two lines:

tcp.validnode_checking = yes

This blocked all SQL connections to the server. Since this instance is a test environment, the above lines in sqlnet.ora were commented off and the listener bounced.


  1. How To Fix Oracle Xe Error Code 17002 in Windows - pingback on January 20, 2015 at 1:26 PM

Leave a Comment

NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Trackbacks and Pingbacks: