DBVisualizer is a free, rich features database manager. It is available for Windows, Mac, and Linux operating systems. You can use this program to connect and manage local and remote database servers. It supports many database types including Oracle, MySQL, PostgreSQL and many more. In this article, I am going to show you how to connect and manage the Oracle database using DBVisualizer.
First, you will need to download and install the latest DBVisualizer for your OS. Get your free copy here and then install it. If you are running Mac, you can read my tutorial to install DBVisualizer on Mac. But in this article, I am using the Windows version.
First, you may want to download the latest version of DBVisualizer from this below link. Install it as usual by double-clicking the setup/executable file.
After install, run DBVisualizer. Then follow these steps to connect to your Oracle database.
- Install and configure Oracle Instant Client on your Windows 10. You can read this post if you need a guide on how to do it.
- Open DBVisualizer.
- Go to Tools | Connection Wizard
- Type the new connection name/alias
- Click Next and select Oracle Thin from the database driver list
- Enter the Oracle server details such as ip address, username, password, and service.
- Click Ping Server to make sure the connection is working properly
- Hit Finish
Make sure the connection was successful and now you can start managing your Oracle database from DBVisualizer Pro.