Re: SQL*Net TCP adapter, listening on multiple ports

David Devejian wrote:
>
> I recently had a conversation with an Oracle rep that I would like to
> confirm. The rep claimed that a LISTENER would not listen to multiple
> ports on the same NIC. particularly, my LISTENER.ORA file looks in part
> like:
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS=
> (PROTOCOL= IPC)
> (KEY= FM1)
> )
> (ADDRESS=
> (PROTOCOL= TCP)
> (Host= jumbo)
> (Port= 1521)
> )
> (ADDRESS=
> (PROTOCOL= TCP)
> (Host= jumbo)
> (Port= 1526)
> )
> )
> Other miscellaneous parameters . . .
>
> The Oracle Rep said that listing these two ports with the same Host= but
> different Port= will not work. Can anyone confirm this?
>
> In a related note, he seemed to indicate that if I had two aliases for the
> same IP address, ie jumbo and jumbo2, I could use two ports, so long as the
> Host='s were different. This doesnt make much sense to me, but I thought
> Id ask around if anyone has any thoughts on this.
>
> thanks in advance,
> Dave
> djd_at_bank2000.com
>
> --
> The above mentioned opinions are mine alone.
> They do not necessarily represent those of
> my employer, or even reality.

David,

Works fine. Ask your Oracle Rep. the REASON why it shouldn't work.

Naren Chintala
naren_at_mink.att.com

<snip>
LISTENER =
  (ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = jumbo)
          (PORT = 1521)
        )
        (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = jumbo)
          (PORT = 1525)
        )

$ lsnrctl start
Starting /opt/oracle/product/7.2.3/bin/tnslsnr: please wait...

TNSLSNR for SVR4: Version 2.2.3.0.0 - Production System parameter file is /var/opt/oracle/listener.ora Log messages written to /var/opt/oracle/listlog.log Listening on:
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=jumbo)(PORT=1521))) Listening on:
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=jumbo)(PORT=1525)))

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=jumbo)(PORT=1521)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for SVR4: Version 2.2.3.0.0 -
Production
Start Date                10-OCT-96 07:12:46
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /var/opt/oracle/listener.ora
Listener Log File         /var/opt/oracle/listlog.log
Services Summary...
  TST          has 1 service handlers