Can you give me an example where this is so. One of my external procedures is used to
send a page should something go awry. I ran a job to send the page; the sender of
the page was the user who started the extproc listener and not "oracle".
Just to be perfectly clear, I am speaking of the operating system user and not of the
database user.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, July 17, 2001 3:01 AM
To: Multiple recipients of list ORACLE-L
<<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:[EMAIL PROTECTED]]
> 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
> [EMAIL PROTECTED]
>
> -----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:[EMAIL PROTECTED]]
> > 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
