SQL Developer

MrWright4hire

Here is my scenario. I have an offline computer with VM workstation on it. I have Windows Server 2012 installed on it and configure it to be able to utilize the internet on an offline computer.
Now I've installed SQL Developer on Win2012, when I try to connect I get an error message that says " The Network Adapter could not establish the connection". Can anyone help me with this. Very nerve wrecking.

Dashrender

@MrWright4hire said in SQL Developer:

Here is my scenario. I have an offline computer with VM workstation on it. I have Windows Server 2012 installed on it and configure it to be able to utilize the internet on an offline computer.

How do you accomplish that? If the host computer is not on the internet, how does the guest VM get to the internet?

MrWright4hire

@Dashrender
Both physical computer and VM has two different IP address. I have the router blocking the physical IP, but VM while using the NIC with a different IP can utilize the internet.

Dashrender

So in the 2012 VM, you can ping, but when you try to use the SQL dev install it fails with " The Network Adapter could not establish the connection"?

MrWright4hire

@Dashrender
That's correct.

Dashrender

OK, you're out of my wheelhouse.

MrWright4hire

@Dashrender
I haven't installed a DB as of yet. I thought I could connect to Oracle DB online. Think I may need to d/l Oracle DB?

Dashrender

I'm confused - what exactly are you trying to do? can you provide a screen shot?

dafyre

For testing purposes, disable the windows Firewall to make sure it's not something like that.

MrWright4hire

I figured it out. I created another NIC, configured it as a NAT and opened up the port that I needed. @Dashrender thank you for coming to my rescue and offering some suggestions. I really do appreciate it.

MrWright4hire

@dafyre that was the first thing I did. However, thank you all the same for your suggestion.

travisdh1

Does

nslookup google.com

return an IP address?

What virtualization software are you using? Might have to switch settings for the virtual machine's network.

MrWright4hire

@travisdh1 I'm using VM station Workstation 10.

travisdh1

@MrWright4hire It's been like 10 years since I used VMware workstation, so I doubt I'll be much help on that end.

Does an nslookup return a valid ip address from within the vm?

MrWright4hire

@travisdh1 I'll check right now.
Indeed it does.

travisdh1

@MrWright4hire said in SQL Developer:

@travisdh1 I'll check right now.
Indeed it does.

It's most likely a firewall blocking you somewhere then. Seems the server can access the internet.

Dashrender

@MrWright4hire said in SQL Developer:

I figured it out. I created another NIC, configured it as a NAT and opened up the port that I needed.

So your VM now has two NICs? One configured as NAT to what? the VM host?

scottalanmiller

@MrWright4hire said in SQL Developer:

@travisdh1 I'll check right now.
Indeed it does.

Any update?