Windows – How to have oracle database accessible remotely

databaseip addressoracleremotewindows

I can connect to my oracle database using localhost:1521. However, connecting to the IP address does not work.

I'm trying to do this because I am trying to connect to my database using another machine, but even the same machine cannot connect to itself using it's own IP Address.

Note: Oracle Database 11g and Windows 7.

Best Answer

You need to enable the instance listener to be listening on an IP address, not just localhost. Go to the Net Services Administration page on the Oracle Enterprise Manager web interface. Edit the listener (LISTENER_localhost) and add a listener and select to use the IP address of the instance. Keep port 1521 as per default. You will be asked if you want to restart the service. Please do so. Then you should be able to connect from your host (or any other machine for that matter).