Re: Oracle 8.1.7 on Redhat 7.1: how to listen on specific address ?

"Giorgos Tsiamitas" <gtsiam_at_gmx.net> writes:

> The HOST parameter in LISTENER.ORA does not specify what clients to listen
> to, but what servers to register with the listener. This means that when you
> specify HOST=localhost you actually tell to the listener to serve a database
> hosted in localhost.
>

Well, I didn't actually read much Oracle documentation, but the port number in   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521) tells me that this is a _bind_ address, which means this is the interface/port combination the listener will bind to, i.e. listen on for client connections.

Furthermore, I´ve been playing around with this stuff and tried 127.0.0.1 instead of localhost. netstat -l now gives me   tcp 0 0 localhost.localdom:1521 *:* LISTEN which is what I wanted.

> To restrict client connections to the listener, do the following:
>
> Create a PROTOCOL.ORA file in $ORACLE_HOME/network/admin
> and include these lines:
>
> tcp.validnode_checking=yes
> tcp.invited_nodes=(127.0.0.1, xx.xx.xx.xx)
>
> Replace xx.xx.xx.xx with as many client IPs you want to allow access to.
>
> Restart the listener.
>
> Clients not specified in tcp.invited_nodes list will get "ORA-12537:
> TNS:connection closed" on connection attempts.
>

OK, this is an interesting hint - although I got (one part of) my problem solved already. Still, I'm wondering what's going on at the higher ports.

Thanks a lot.

> ---
> Giorgos
>
>
> "Gunther Hermann" <ghermann_at_dclient103-30.hispeed.ch> wrote in message
> news:m3itie78n1.fsf_at_dclient103-30.hispeed.ch...
> >
> > Hi
> >
> > I just downloaded and installed Oracle 8.1.7 on Redhat 7.1.
> > Things worked fine so far, I got the database up and running.
> >
> > What I'd finally like to to is to bind all listening services
> > to localhost addresses only.
> >
> > Trying this, two questions/problems came up when calling netstat -l
> > with output
> > tcp 0 0 *:32771 *:* LISTEN
> > tcp 0 0 *:32772 *:* LISTEN
> > tcp 0 0 *:1521 *:* LISTEN
> > and lsof with output
> > oracle 783 oracle 9u IPv4 1525 TCP *:32771 (LISTEN)
> > oracle 785 oracle 9u IPv4 1530 TCP *:32772 (LISTEN)
> >
> > (i) what exactly are the services running on ports 32771/32772 and how
 can
> > I configure them to listen on 127.0.0.1 only ?
> > (ii) why does the tns listener (port 1521 if I'm not wrong) listen on
 _all_
> > addresses although my 'listener.ora' looks like
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> > )
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> > )
> > )
> > )
> > ??
> >
> > Thanks a lot
> > Gunther
Received on Sun Jun 03 2001 - 12:17:14 CDT