Oracle SQL Developer: the questions people actually ask

q dark How do I turn on dark mode?

There is no single switch — the editor colours and the application chrome are set in two different places, which is why answers to this question so often disagree. The full walkthrough is here, including community themes and how to undo it.

q memory It runs out of memory on large result sets

Oracle SQL Developer is a Java application and starts with a modest heap. Exporting a few million rows, or opening a very large script, can exhaust it. The fix is to raise the ceiling in the configuration file rather than anything in the interface.

Edit sqldeveloper/bin/sqldeveloper.conf in your install folder and raise the maximum heap, for example AddVMOption -Xmx2048M. Keep it comfortably below your physical RAM, and restart afterwards. If you are exporting very large data sets regularly, SQLcl or a spool file is a better tool than a GUI grid.

q slow Why is startup so slow?

• The first launch is always slow. Oracle SQL Developer unpacks and indexes its extensions once. Later starts are much faster, so judge the speed on the second run, not the first.
• Extensions you do not use. Tools → Preferences → Extensions lets you disable modules such as migration or modelling; each one you turn off is startup work you skip.
• The install folder location. Running from a network share or a synced cloud folder adds latency to every file the application touches. Install locally.
• Unreachable saved connections. Connections that time out on startup make the application look frozen when it is really waiting on the network.

q connect My connection fails and I do not understand the error

Oracle’s error codes are precise once you know what they mean, and the Test button in the connection dialog tells you which one you have before you save anything. The four you will meet most:

• ORA-12541, TNS no listener — nothing is accepting connections on that host and port. The database is not running, or the port is wrong.
• ORA-12514 — host and port are right, so you reached the listener, but it does not know the service you asked for. Usually a service-name-versus-SID mix-up.
• ORA-01017, invalid username/password — you reached the database and it rejected your credentials. Oracle passwords are case-sensitive.
• ORA-28000, account is locked — the user exists but is locked; a DBA has to unlock it.

The service-name-versus-SID distinction causes more failed first connections than anything else, and the getting-started guide walks through which one your database wants.

q account Do I need an Oracle account to download it?

No. Oracle SQL Developer downloads with no account, no sign-in and no licence click-through — we verified that against Oracle’s own servers rather than taking anyone’s word for it. Other Oracle downloads, including Oracle Database itself, do require an account, which is where the confusion comes from. The full check and method are here.

q updates How do I update to a new release?

There is no updater, because there is no installer. Download the new build, unzip it to a new folder, and delete the old one. Your connections and preferences live outside the application folder, so a new version offers to import them from the previous version the first time it starts.

That separation is why it is safe to keep two versions side by side while you check that a new release behaves. Nothing is registered system-wide, so they do not interfere with each other.

q shortcuts Which keyboard shortcuts actually matter?

• Ctrl+Enter — run the single statement your cursor is in, into a browsable result grid.
• F5 — run the whole worksheet as a script, with plain text output. The difference between this and Ctrl+Enter catches out nearly every newcomer.
• Ctrl+Shift+F — format the SQL in the worksheet.
• Alt+F10 — open a new SQL worksheet against the selected connection.
• Ctrl+Space — completion insight for table and column names.

All of them are remappable under Tools → Preferences → Shortcut Keys, which is worth knowing if you are coming from another editor and your fingers disagree with the defaults.

q more Still stuck?

The platform guides cover install-time problems in more depth than this page does: Windows, macOS and Linux each have their own troubleshooting section for the failures specific to that system.