Re: 2 sids, 2 external procedure listeners

the Oracle 9i Application Server 1.0.2.1 installation guide includes a recommendation that the listener process for the external procedure be run as a user other than oracle, and that this user should NOT have write authority on the database files.

it's not clear whether it is the listener process that is the security issue, or whether it is another process spawned by the listener (to handle "extproc").

i too, would find it helpful if the documentation went into a little more detail, or showed an example.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:teu2tbt6ct2f20_at_beta-news.demon.nl...
>
> "John Dunn" <JLDunn_at_ukgateway.net> wrote in message
> news:3aef05c8$0$15030$cc9e4d1f_at_news.dial.pipex.com...
> > Anyone got any experience of the following :
> >
> > We have 2 SIDS. We want to configure the external procedure listener for
 1
> > SID to run as a unix user other than oracle, with the external procedure
> > listener for the other SID still running as the oracle user?
> >
> > John
> >
> >
> >
> >
>
> I am afraid this is not possible. The external procedure listener is
 nothing
> more than a service provided by the listener, and the listener should run
> under the owner of the oracle executables, hence under the user oracle.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
>
Received on Wed May 02 2001 - 00:07:00 CDT