SQL Developer won't show the connections Tab
SQL Developer won't show the connections Tab
So SQL Developer won't show the connections tab no matter what I do.
I've tried going through the "view" tab and clicking into the "connections" and I've also tried clicking the new button. I've also tried an uninstall/reinstall, but nothing.
It's probably something simple, but I'm fairly new to it, can anyone direct me or provide any advice?
Any help is really appreciated :)
Is there any way to do it without a reset? I can't back up the rest of my files at the moment
– Dale Long
Jan 17 '17 at 16:46
But it will only reset your windows, it won't close your opened files.
– Renato Afonso
Jan 17 '17 at 16:51
I have no clue. Just a suggestion. Maybe try Oracle support/community forum?
– OldProgrammer
Jan 17 '17 at 16:52
find the connections.xml file and delete it - it's probably been corrupted - only do this if the Reset Windows to Factory Settings doesn't fix it first. BTW, this is not MSFT Windows/format/re-install, it's the WINDOWS menu in SQLDev, it has a Reset item which refreshes the desktop layout of SQLDev
– thatjeffsmith
Jan 17 '17 at 18:15
4 Answers
4
1.) Save your current SQL connection xml file located in windows 7/8/10: C:Users"youruseraccount"AppDataRoamingSQL DevelopersystemXXXXXo.jdeveloper.db.connection.xxxxxx
2.)Now delete your SQL Developer Folder and sqldeveloper folder located in: C:Users"youruseraccount"AppDataRoaming
3.)Now delete the main sqldeveloper folder containing the actual SQL developer application files.This would be located wherever you initially unzipped the SQLDeveloper download.
4.)Download the latest version of SQL Developer and unzip wherever you like.
5.)Launch SQL developer and specify your JDK location.
6.)Copy your connections xml file to your roaming SQL Developer directory here: C:Users"youruseraccount"AppDataRoamingSQL DevelopersystemXXXXXX)o.jdeveloper.db.connection.xxxxxx
7.)Launch SQL Developer and your DBA view should now be available after selecting view -> DBA
You don't even have to re-install - I did steps 1, 2, and 3, then simply re-launched sqldeveloper; the folders you deleted will be re-created; then just place your o.jdeveloper.db.connection.xxxx in the correct location. And re-launch sqldeveloper again.
– manyways
Apr 24 at 17:47
I had the similar issue with SQL Developer 4.2, one fine day all the connections pane on left vanished, tried couple options unsuccessfully.
Remedy is
1) Installation of newer version of SQL Developer to the folder of your choice with newer java JDK
2) Import the preference from previous version. DID the TRICK... Good Luck
You can go to the upper tab "WINDOW" and then click "Reset Windows to factory settings".
Search for the file - windowinglayoutDefault.xml and delete it, and restart SQL Developer.
This file should be present inside a system folder at
windowuserPathAppDataRoamingSQL Developer
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
try Windows > Reset Windows to Factory Settings
– OldProgrammer
Jan 17 '17 at 16:36