Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IO Error:Connection reset, java.sql.SQLRecoverableException

400026Jan 10 2013 — edited Jan 10 2013
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,

Comments

Billy Verreynne

SQLCL is a client application. It does not have users and passwords to use.
SQLCL connects to database servers (db instances). The database typically requires a username and password for authentication. SQLCL may prompt for these credentials to supply to the database.
There are no default usernames and passwords to use in today's Oracle database. Most schemas are also locked by default when the database is created.
Ask your DBA for the details of the database and user schema to use.

User_21BG6

i have installed sqlcl-21.3.3.322.1724..but it is asked user name and password in command prompt..please give the solution

Mike Kutz

What database are you trying to connect to?

User_H3J7U

Use /nolog parameter.

thatJeffSmith-Oracle

If you don't know your username and/or password, you need to talk to the person responsible for your database. If you don't know who that is, we can't help you.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 7 2013
Added on Jan 10 2013
3 comments
6,569 views