IO Error:Connection reset, java.sql.SQLRecoverableException
400026Jan 10 2013 — edited Jan 10 2013Problem:
An error occurred while establishing the connection:
Long Message: IO Error: Connection reset
Details: Type: java.sql.SQLRecoverableException Error Code: 17002 SQL State: 08006
While connection from one of the tool like DbVisualizer Free 8.0.10 facing the issue.
Database Server: Oracle 10g R2 10.2.0.5 Linux 64bit
Client: Oracle 11g R2 11.2.0.1 Windows 64 client.
TNS Port: 1521
Facing the issue from SQLPLUS client 11.2.0.1 and not able to connect to the database.
DB server and Client are different locations.
Local from my desktop to DB server are able to connect with same client. TNSPING response as below:
C:\Program Files\DbVisualizer-8.0.10\jre\lib\security>tnsping bldb
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 10-JAN-2
013 18:26:33
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
D:\app\nmadmin\product\11.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 180.179.103.23)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SER
VICE_NAME = BLDB)))
OK (110 msec)
I have enabled the trace log from client side. If required, i will share the log details.
Please let us know to resolve the issue.
Regards,