Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

sql developer hangs on startup - what can I do?

At present I cannot run it (SQL Developer 4.1) because it hangs on "Restoring Editors" while starting. I suppose I've done it by exiting it before by killing sql developer process because it was hanged on fetching objects to Schema Browser so long... Maybe I would clean some temporary files but can't find any. Any ideas?

like image 379
rtbf Avatar asked Feb 27 '15 14:02

rtbf


People also ask

Why my SQL Developer is not opening?

It's possible that your Windows jdk path isn't recognizable or missing. You should have sqldeveloper. conf file that contains a reference to your JDK directory. Find your jdk path and make sure it's reflected in your sqldeveloper.

How do I stop SQL Developer from running?

To kill a session: In SQL Developer, click Tools, then Monitor Sessions. In the Select Connection dialog box, select a connection to SYSTEM (or another account with full DBA privileges) Right-click in the row for the session to be terminated, and select Kill Session.


2 Answers

Deleting files from c:\Users\MY_USER\AppData\Roaming\SQL Developer\SQL History and c:\Users\MY_USER\AppData\Roaming\SQL Developer\System... Really helped me to resolve the connection issues

like image 171
Lakh Avatar answered Sep 18 '22 14:09

Lakh


Basing on this thread https://community.oracle.com/thread/2564842 I've created own solution.

  1. Extract installation of current version SQL Developer (4.1.0.17.29)
  2. At "c:\Users\MY_USER\AppData\Roaming\SQL Developer\" I've changed directory name system4.1.0.17.29 to system4.1.0.17.28.
  3. After running newly extracted SQL Developer (4.1.0.17.29) I was prompted to let copy configuration from version 4.1.0.17.28 to 4.1.0.17.29 ;)
  4. Everything works great now. I suppose that running the same (broken) installation after decreasing version could also help.
like image 27
rtbf Avatar answered Sep 19 '22 14:09

rtbf