SQL Developer Vendor Code 17002

Problem:

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 9.0.1.4.1 - Production on 02-MAY-2012 10:21:29

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

Used parameter files:
C:OracleDevSuiteHomenetworkadminsqlnet.ora

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

Pinging the instance on the database node completed successfully.

The problem started occurring after applying ATG RUP7.

Solution:

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
tcp.invited_nodes=(OEL5VIS3.localdomain)

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: