Oracle Database Discussions

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