RE: Multiple Listeners

If you are using external procedures, the listener for them should be different as well. The external procedures run under the authority of the user which started the listener that has the sid list entry for them. If you place the entry in the main listener and that listener is initialized by oracle, the external procedures run with the authority of the oracle OS user. Having a different listener which can be started by a less privileged account allows the external procedures to run with less authority.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Monday, July 16, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L

Mladen,

    I can think of numerous reasons to have multiple listeners. For example, imagine a server with several databases where you sometimes wanted to restrict outside access on just one database. Meanwhile still allowing local users on that server to access that particular database. In this case restricted mode wouldn't work, and downing the listener would restrict remote access to all the databases. With multiple listeners you could shutdown the listener for just that database. Outside users would then be unable to connect, but local users would still be able to work. The other databases would continue as usual...

   Another example, Veritas Cluster, is the reason I use multiple listeners. You need to be able to failover the listener for just one database, not all of them!

Alan

-----Original Message-----
Sent: Monday, July 16, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L

It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from
having 3 listeners?

> -----Original Message-----
> From: Edward W. Carr [mailto:ecarr_at_qwest.com]
> Sent: Monday, July 16, 2001 5:42 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Multiple Listeners
>
>
> 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: Gogala, Mladen
  INET: MGogala_at_oxhp.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).
--
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

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).