Database Management tools

I like to use Oracle SQL Developer to connect to my databases. It is an open-source product directly from Oracle. As of this writing version 23.1 is available. Although I do use Linux distros, my primary operating system is Windows.

There is no install file. You just download the package from oracle.com. You may need to sign up for a free account to download it. On Windows, I unzip it and generally save it on the C drive in a folder called Oracle where I will keep all of my Oracle related files in. On Windows I use the Windows 64-bit with JDK 11 included version. It is really easy to install on Oracle Linux. I haven’t tried it on other Linux distros but it would probably work on Fedora or Debian also.

I like to use SQL Developer because I find it easier to visually see inside the database. You can also get a plugin to connect to MySQL. Since I use both Oracle databases and MySQL databases, it is very handy to be able to open up both in the same management system. There is obdc connection required. You will need either a connection string or a tnsname.ora file save in your Oracle folder.