Is there a way to configure the XE installation on Windows to use only ports on the local interface, and not external interfaces? I would like to run it for development without being able to connect to my instance.
I tried changing the listener.ora and tnsnames.ora file by changing the HOST = entries to localhost. My hosts file has the following line:
127.0.0.1 localhost
When I did this and restarted the services, apex stops working (it does not listen on port 8080) and I cannot connect to the database using JDBC. I get the following error in JDBC:
Exception in thread "main" java.sql.SQLException: Listener refused the connection
with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect
descriptor
The Connection descriptor used by the client was:
localhost:1521:XE
I should note that both peaks and JDBC work fine if I change the "HOST = records" to my hostname and restart the services.
source
share