RE: Multiple Listeners

From: Alan Aschenbrenner <alan.aschenbrenner_at_ihs.com>
Date: Mon, 16 Jul 2001 14:31:42 -0700
Message-ID: <F001.0034B8CE.20010716142723@fatcity.com>

Edward,

Yes, you can setup multiple listeners. Here is an example:

LISTENERDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521))
      )

)
)

LISTENERDB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1522))
      )

)
)

SID_LIST_LISTENERDB1 =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = DBAME1)
(ORACLE_HOME = /path/to/oracle/home)
    )
  )

SID_LIST_LISTENERDB2 =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = DBAME2)
(ORACLE_HOME = /path/to/oracle/home)
    )
  )

After you have set this up, you can start the listeners individually:

lsnrctl start listenerdb1
lsnrctl start listenerdb2

Hope that helps...

Alan

Alan Aschenbrenner
Oracle DBA
IHS Group
alan.aschenbrenner_at_ihs.com
(303)-858-6394

-----Original Message-----
Carr
Sent: Monday, July 16, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L

Hello All,

I am currently running Oracle 816 64bit on a Solaris 8 box. I have three
databases on the system with one LISTENER for all of them. Is it possible
to configure multiple listeners, one for each database? We have tried in
the past with no success... If there is a document on the web somebody could
point me to, that would be great! I have searched for one but must not be
searching correctly.

TIA,

Edward W. Carr
UNIX Systems Administrator
Qwest Communications
Broadband Services Inc.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alan Aschenbrenner
  INET: alan.aschenbrenner_at_ihs.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jul 16 2001 - 16:31:42 CDT