This discussion is archived
3 Replies Latest reply: Dec 21, 2012 3:22 AM by Osama_Mustafa RSS

SQL Developer : closed connection error

981185 Newbie
Currently Being Moderated
Hi ,

I am getting the following error when trying to query after connecting to a database.
I am using the SQL developer installed in my local machine and connecting to a database in a remote server.
I am connecting using the BASIC model in sql developer ( Tried both SID and Service_name method).

even the simple queries like - "select 1 from dual;" are giving the following errors

Error starting at line 1 in command:
select 1 from dual
Error at Command Line:1 Column:0
Error report:
SQL Error: Closed Connection

Also -> Closed connectio vendor code 17008

I have 2 databases in that remote server . I am able to connect to both databases. But when trying to query 1 database is giving this above given error.
The other one gives result properly.
The version of both the databases are 11.2.0.2 and version of my SQL developer is Oracle SQL Developer 2.1.1.64

Can anyone advice / help to solve this issue ?


Regards
Binoy

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points