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.
[amazon asin=1847196268&template=iframe image&chan=default] [amazon asin=0071484744&template=iframe image&chan=default] [amazon asin=0137142838&template=iframe image&chan=default]
1 Comments.