How it is correct bind LISTENER to only localhost???
OS: Linux Fedore 8 ORACLE: 10.2.0 XE have: 2 external interfaces and 1 local as localhost Problem: to hide 1521 port of LISTENER from external interfaces and bind to localhost interface. I try change listener.ora as follows: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) (ADDRESS = (PROTOCOL = TCP)(HOST = *localhost*)(PORT = 1521)) ) ) I received that wanted, but the web interface was down and not started longer. I was returned all back. How it correctly to change host listener to localhost and save web interface standard means without iptables etc., at least by means of the same hosts.deny or ...., better if it is be oracle means??? sorry for my english)
Hi, Assuming that you're using a static IP (192.168.0.1), in order to bind your listener to using localhost: Step 1: Make the following changes in your listener.ora: (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)(IP=FIRST)) Step 2: Reload listener, where listener_name will be the name of your listener lsnrctl reload listener_name Step 3: Telnet listener to check if its functional telnet 192.168.0.1 1521 Step 4: Review the IP address binding behaviour of the listener netstat -tnlp | egrep 'Proto|tns' For step 4, you will have an output stating that the listener is listening to a local address (192.168.0.1) on port 1521. Hope this helps. Regards, Naveed.
Thanks a lot, it have helped me.