Answer:
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"
Question:
Shi yousong <[email protected]> wrote in message
news:[email protected]...
>
> 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
>