Virtualbox HDP 2.5 sandbox - How to add extra host only network?

[#1]

I was wondering how I can add an extra host only adapter to the HDP 2.5 virtualbox sandbox. I want to test replicating an Oracle database running on my laptop into the sandbox. I use Attunity or Oracle Golden Gate for replication. But I need to access the cluster through host only network.

[#2 · Accepted solution]

Never mind. Got it figured out. I only needed to configure the host only adapter as the first adapter and the NAT adapter as the second. Setting the details in VB manager of the host-only adapter to 192.168.100.100 subnetmask 255.255.255.0 and DHCP server on (serveraddres) 192.168.100.100 subnetmask 255.255.255.0 and lowest address to 192.168.100.101 and highest to 192.168.100.254.

[#3]

@Robbert Naastepad thanks for following up with the solution!