Roxanne25
asked on
SQL Developer - "Connection Closed" on All Connections
Hello,
I have tried researching this but nothing has turned to be fruitful when looking on the web. I had been using SQL Developer with 2 oracle connections just fine but after I installed the Oracle 11g client, I cannot get SQL Developer to work now no matter what version of the tool and/or JAVA I use.
When I go to the connections in SQL Developer it connects but then when I try to run any queries it says "connection closed".
I know the connections are still functioning and nothing has been changed on the database. I can connect via sql plus and via a linked server in SQL Server.
I have tried using different versions of SQL Developer and trying different JDKs. I have tried putting different things in my .conf file and installing the SQL Developer patch. Does anybody have any ideas or experience with why my connections suddenly don't work anymore?
Thanks.
I have tried researching this but nothing has turned to be fruitful when looking on the web. I had been using SQL Developer with 2 oracle connections just fine but after I installed the Oracle 11g client, I cannot get SQL Developer to work now no matter what version of the tool and/or JAVA I use.
When I go to the connections in SQL Developer it connects but then when I try to run any queries it says "connection closed".
I know the connections are still functioning and nothing has been changed on the database. I can connect via sql plus and via a linked server in SQL Server.
I have tried using different versions of SQL Developer and trying different JDKs. I have tried putting different things in my .conf file and installing the SQL Developer patch. Does anybody have any ideas or experience with why my connections suddenly don't work anymore?
Thanks.
ASKER
Hi thanks for the reply.
2. Did not work.
1. I am not sure about this as we have 64 bit machines and I do not see a SQL Developer with the JDK that is for anything but 32 bit. So, correct me if I'm wrong, but it will not install the 32 bit version on a 64 bit machine?
2. Did not work.
1. I am not sure about this as we have 64 bit machines and I do not see a SQL Developer with the JDK that is for anything but 32 bit. So, correct me if I'm wrong, but it will not install the 32 bit version on a 64 bit machine?
- did u run sql developer on the 64bit server or your machine that is also on 64bit?
ASKER
my local machine.
- i downloading and running the following version on my Windows 7 64bit: sql developer 32bit with java sdk. have you tried this?
ASKER
I'll give it a whirl and see how it goes.
ASKER
Nope same issue, "closed connection"
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you for the link!!!
I was able to solve the problem by using the suggestion in that blog post to change my connection method to TNS instead of basic.
I was able to solve the problem by using the suggestion in that blog post to change my connection method to TNS instead of basic.
- no problem. great that able to help :)
ASKER
Yea I'm glad too, this problem has been bugging me for over a week! :)
Thanks again.
Thanks again.
1: download sql developer that comes with its own java
2: create a new connection and try to connect using the new connection instead of existing one you have.