RE: Multiple Listeners

<<The external procedures run under the authority of the user which started the listener that has the sid list entry for them.>>

This does not always seem to work. If you submit your external procedure using dbms_job, for example, it will still run as Oracle.

Or at least that is my experience.

John

> -----Original Message-----
> From: MacGregor, Ian A. [SMTP:ian_at_slac.stanford.edu]
> Sent: 17 July 2001 00:41
> To: Multiple recipients of list ORACLE-L
> Subject: 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

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