IO Error:Connection reset, java.sql.SQLRecoverableException

400026

Problem:

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:
\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,

Unknown

Moderator Action:
... moved from the JDBC forum.
Not a Java question, just some network problems and one of the tools that fails to work just happens to be written in Java it seems.

sb92075

shaileshpurani wrote:
Problem:

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.

I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

SHOW us what happens when sqlplus fails to connect.

Osama_Mustafa

Post more information about your setup please