SQL Developer : closed connection error
981185Dec 21 2012 — edited Dec 21 2012Hi ,
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