Skip to Main Content

SQL Developer

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!

SQL Developer : closed connection error

981185Dec 21 2012 — edited Dec 21 2012
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

Comments

Fran
welcome to OTN forums.

Please search before post:
9648502
2305368
2201373

When the issue will be solved, remember mark this question as answered to keep clean that forum.
900442
you may try and use fully qualified host names instead of the simple host name when trying to establish a connection from sql developer.

Regards,
Raj K.
Osama_Mustafa
Refer to
SQL Developer Shows "Connection Closed" Error When Running a Query [ID 1297692.1]
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 18 2013
Added on Dec 21 2012
3 comments
3,882 views