How to connect to Oracle from Your Windows Host to a VirtualBox Guest

I am sure that anyone who wants to work on a database or a data warehouse would like to have a database that they don’t care about, even if it crashes at hand. Setting up a database and getting lost in configurations will also cause a huge waste of time. Instead of dealing with them, you can download the virtual machine with the Oracle database already installed and put it directly into the application.

For this purpose, Oracle offers a virtual machine open to everyone. In this virtual machine, Oracle Database and Oracle Data Integrator (ODI) applications are installed. You can easily access and download from the following link:

Link: https://www.oracle.com/middleware/technologies/data-integrator/odi-demo-downloads.html

To use this virtual machine, you can also download the free version of Oracle Virtualbox from the following link:

Link: https://www.virtualbox.org

After you set up the virtual machine, you query the ip address of the virtual machine to access the database on the virtual machine from your Windows computer, like me:

If you want to connect to the database at this address with Toad as follows, you will probably encounter an error like this:

Connection failed. ORA-12170: TNS: Connect timeout occured

This indicates that the database at the specified address cannot be accessed. There are many different methods on the internet. However, the simple method I prefer is to add a second Network Adapter to the virtual machine via Virtualbox. We select and save the connection method of this second Network Adapter as Host-Only Adapter. In this way, we provide direct communication of our Windows computer to our virtual machine.

Then, when we restart the virtual machine, a new IP address is defined as below. By entering this ip address toad we will see that it is connected successfully.

Mehmet Emin Paça

I am a Datawarehouse & Reporting expert having 4+ years experience in Oracle Business Intelligence 12c, Oracle Data Integrator 12c and Tableau. Also PL / SQL is my favorite language which I code it as my daily routine. Previously , I worked as a Senior Java Software Developer having 5 years experience. I am pleased to share my knowledge and experience so I am here

Leave a Reply

Do NOT follow this link or you will be banned from the site!
Visit Us On FacebookVisit Us On LinkedinVisit Us On Twitter