Admittedly it’s been a while since I’ve used VirtualBox to host a database. I’ve been using a bunch of different cloud services.
I like to program on my main machine(host) and connect to the VM as if it were just a database server. I expected to have quite a few issues given how long it’s been since I did it this way. But really the only issue I had was making the connection from the Host to the VM.
This is how I configured my VM using VirtualBox 4.3.26 for Windows hosts.
If any of the steps need a better explanation, leave me a comment and I’ll clarify.
Steps
- Download the Database App Development VM from Oracle’s Pre-Built Developer VMs. Others should also work if you have a favorite.
- Import the .ova file into VirtualBox
- Add network adapter
- Configure Adapter
- Start the VM
- Enable network adapter inside the VM
- Open a Terminal inside the VM
- Test the connection on your host machine.
I’m using Oracle SQL Developer 4.0.3 (4.0.3.16.84)
If all goes well you should have a good connection.
Any questions please leave a comment.
Can we use Virtual Machine instead of virtual box where database is created and can we connect to the local mechine from SQL developer as mentioned in the course?
Your feed back will be appreciated
Thanks & Regards
Vamshi
These instructions are specifically for Oracle VirtualBox https://www.virtualbox.org/
Also, there have been a few new versions of Oracle VirtualBox released since I wrote this. If you try this with the latest version, please let me know if this post is still accurate.
Great post, thanks for share
Hi,
I am trying to add the network adapter. I am getting an error like this “Nonexistent host networking interface, name ” (VERR_INTERNAL_ERROR).”
When I select Attached to as Host-only Adapter , I don’t have any options to chose an adapter from the list. Can you help me out here?
This may help https://www.virtualbox.org/ticket/11183
This post has helped me a lot. I’ve tied this with the latest version of Oracle VirtualBox (5.2.12/May 2018) and it works. Thank you very much!
thanks a lot!
I can not connect to both network adapters. One is connected but the other one has the inscription “Connecting”.
Hmmm… I’m not sure.
A lot has changed since this post was published (see my other comment.)
Very helpful… saved me a lot of time!
when i try to connect it says Failure – Test failed: IO Error: The Network Adapter could not establish the connection
Have you checked that the port mapping is correct and that there’s not a local firewall issue?
Pluggable database is really necessary to get connected? I have had setup without pluggable DB and even successul connected to EM Express still can get connected through SQLDeveloper with:
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
Any thoughts?
The specific VM I used in the examples was pluggable, but that’s not required. Usually when I get that error, I check the port mapping and local firewall to make sure I can get to the VM.
Thanks for this
A lot has changed since this post was published. I have not needed to configure Host access in a while.
Lately I’ve been using Vagrant. Check out my recent post for another way to do it. https://learncodeshare.net/2019/01/29/how-to-build-an-oracle-database-developer-toolbox/
Thanks for sharing this post,
is very helpful article.