Re: How to configure a second listener ?

I hope you find this helpful

MULTIPLE LISTENERS ON A DATABASE

  LISTENER1 =

           (ADDRESS  =   ( PROTOCOL =  TCP ) ( HOST  = dan.us.oracle.com )
                         ( PORT = 1521 ) )

            SID_LIST_LISTENER1  =
                        (SID_DESC  =
                               ( SID_NAME  =  ORCL )
                        )

  LISTENER2 =
           (ADDRESS  =   ( PROTOCOL =  TCP ) ( HOST  = dan.us.oracle.com )
                         ( PORT = 1522 ) )

            SID_LIST_LISTENER2  =
                        (SID_DESC  =
                               ( SID_NAME  =  ORCL )
                        )

  If multiple listeners service a single database, a client will sequentially
  select a listener for its connection requests. This enables the listeners to
  share the burden of incoming connection requests. To allow multiple listeners
  to service a single database and enable the client to select a listener at   random, a different listener address must be configured for the same service
  name in the listener.ora file.

  The listener.ora file above is configured for the two listeners LISTENER1 and
  LISTENER2. The addresses of the two listeners are different in terms of the
  port numbers to which they listen. LISTENER1 listens to the port number 1521,
  and LISTENER2 listens to the port number 1522. However, the SID information for
  both the listeners is the same.

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

Shi yousong <yousong_at_bigpond.com> wrote in message news:380FD69C.3A8BAE71_at_bigpond.com...
>
> Hi ,
>
> I have 2 Oracle8 server running on Solaris 2.7, and want to start a
> second listener for special purpose, such as replication. My questions
> are:
>
> 1. Is it a good design for the 2 server using a dedicated NIC to do the
> replication ?
> 2. How to configure the second listener on both server which is bind
> onto a private IP address ? If the port 1522 should be used for the
> second listener ?
> 3. Any special consideration for the TCP/IP setting on the Solaris OS ?
>
> Thanks in advance.
>
> Sam
>
Received on Fri Oct 22 1999 - 00:23:00 CDT