Database

How to Connect and Manage Oracle Database using DBVisualizer

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.

Install Oracle Database 19c on CentOS Linux 8

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.

dbvisualizer pro 10 full version download

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.

https://www.dbvis.com/download/

After install, run DBVisualizer. Then follow these steps to connect to your Oracle database.

  1. 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.
  2. Open DBVisualizer.
  3. Go to Tools | Connection Wizard
  4. Type the new connection name/alias
  5. Click Next and select Oracle Thin from the database driver list
  6. Enter the Oracle server details such as ip address, username, password, and service.
  7. Click Ping Server to make sure the connection is working properly
  8. Hit Finish
Give a new name for the connection
Select database driver
Enter Oracle Server details

Make sure the connection was successful and now you can start managing your Oracle database from DBVisualizer Pro.

Post Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.