Re: [Q] Can SQL*NET listen on two addresses at onec?

From: Naren Chintala <naren_at_mink.att.com>
Date: 1996/06/04
Message-ID: <4p2fod$12s_at_nntpa.cb.att.com>#1/1

David J DeWolfe <sxdjd_at_orca.alaska.edu> wrote:
>Hi;
>
> If you hear of a way to listen on 2 addresses
> w/ 1 listener, I'd appreciate it if you'd let me know, as I was trying
> to do the same thing a few weeks back while configuring an fddi interface
>, in addition to the existing ethernet interface, on one of my hosts.
>

David,

It is POSSIBLE to listen on 2 addresses with 1 listener. We are running Oracle 7.2.2.3.0 on Solaris 2.5 (SPARC2000). Have a look at my configuration files. The LISTENER listens on two IP addresses on the same machine.

Email me if you have any questions.

Naren Chintala
AT&T
Middletown, NJ
naren_at_mink.att.com

---

Contents of /etc/hosts

---

IPaddress1 test1
IPaddress2 test2

---

Contents of the listener.ora

---

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS = 
          (PROTOCOL = TCP)
          (HOST = test1) 
          (PORT = 1525)
        )

        (ADDRESS = 
          (PROTOCOL = TCP)
          (HOST = test2) 
          (PORT = 1526)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
LOG_DIRECTORY_LISTENER = /var/opt/oracle LOG_FILE_LISTENER=LISTlog.log

TRACE_LEVEL_LISTENER = ADMIN
TRACE_DIRECTORY_LISTENER = /var/opt/oracle
TRACE_FILE_LISTENER=LISTtrace.log

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = temp)
      (ORACLE_HOME = /opt/oracle/product/7.2.2)

    )
  )

---

>
>Craig Harper <caharper_at_hooked.net> wrote:
>>I have need to listen to two address with the same listener. I have
>>tried modifing my listener.ora file to include the second listener
>>address but after reloading and then attempting to conect it failed. I
>>was hoping that someone might be able to shed some light on this.
>>
>>I am running SQL*NET 2.2.3, Oralce 7.2.3 on HP/UX 10.10. I have two
>>identical boxes connected and am running MCSERVICE GUARD (swith over
>>type software). Each box has an IP address (say .1 &.2) and MCSERVICE
>>GUARD has an IP address (say .3) (kind of like a virtual address) all
>>trafic is directed to the .3 address which handles mapping it to the box
>>that is currently running the instance and has all of the logical
>>volumes mounted etc. My problem is that I have an installed base of
>>users that are still pointing at the old IP address .1, but know the
>>listener is listening to .3. I would like to set the listener to listen
>>on both .1 and .3. One last thing I am running MTS.
>
>
Received on Tue Jun 04 1996 - 00:00:00 CEST