Forum Stats

  • 3,827,374 Users
  • 2,260,765 Discussions
  • 7,897,221 Comments

Discussions

IO Error:Connection reset, java.sql.SQLRecoverableException

400026
400026 Member Posts: 1
edited Jan 10, 2013 7:14PM in General 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,
Tagged:

Answers

  • 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
    sb92075 Member Posts: 42,196 Blue Diamond
    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
    Osama_Mustafa Member Posts: 6,086 Gold Trophy
    Post more information about your setup please
This discussion has been closed.