Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed Oracle 11g Enterprise Edition on my Windows 7 Pro. My problem is that I cannot log into database from other host (local network).

When I connect to database using Oracle SQLdeveloper everything is ok as long as I specify 'localhost' in connection configuration. However, when I change it to '' which is my host IP address I get 'The Network Adapter could not establish the connection'. I get the same error when logging in from other host in local network.

What is the problem?

share|improve this question
Are you running Windows (or any other) Firewall? – kmarsh Jun 17 '10 at 19:47
No, firewall is disabled. – Kylo Jun 17 '10 at 20:32

Is it a firewall issue? Disable (temporarily) the firewall and test.

If it is not a firewall issue then the database listener needs to be configured to run on the proper interface. It is quite likely the default listener is running on the loopback ( interface and not the external interface ( Do a search for listener.ora and see what that configuration file contains. Tweak it there to listen on the correct interface.

share|improve this answer

I wouldn't be remotely surprised if the problem was the zero as third octet, try it was any other number then come back to us.

share|improve this answer
I tried but nothing changed. Why do you think it would be such thing? – Kylo Jun 17 '10 at 20:34

When you use or localhost, the PC 'knows' that you are talking about it, and it doesn't have to do any lookups. When you use, the PC probably sends that off to a router or proxy or something where it will come back to the PC.

My guess is that it isn't coming back.

Do a TELNET 1521 and see if you get a connection. If you don't, then it isn't an Oracle database problem, but a networking one. In which case, you should describe your network setup in more detail (is this a home setup, a corporate LAN, DHCP/static IP...)

share|improve this answer
Telnet doesn't work. Now I installed this Oracle 11g on VirtualBox with WinXP guest and everything works just fine. I can access it from outside :-) – Kylo Jun 18 '10 at 21:47

Are you using DHCP? You'll need to install the Microsoft Loopback Adapter if so.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.