Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


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.


Related Links

just explain me in realtime scenario :-)
IMPORT only tables
help tracing a sid...
How to rebuild a spacial index?
what are FIXED SIZE and VARIABLE SIZE
Locking in oracle session
Recreating SYSAUX tablespace
book recommendation
general
ORA-000604
Update Blob column failed
Hot Backup
ORA-01991:INVALID password file.
sql query tuning
buffer cache size in 9i database
Many little datafiles or one big datafile?