Re: External Procedures under Oracle 8i Release 1

Sybrand Bakker wrote:
>
> On Thu, 28 Sep 2000 15:28:52 -0400, Walter T Rejuney
> <BlueSax_at_Unforgetable.com> wrote:
>
> >After wading through a virtual sea of information on the Oracle support
> >site I have a couple questions on external procedures:
> >
> >1. Is it necessary/desireable to have a separate listener just for
> >external procedures?
> >
> No, it should be sufficient to configure an existing listener for
> external procedures
>
> >2. Is the value for "KEY=" arbirtary as long as it exactly matches
> >between the tnsnames.ora and the listener.ora entries?
> >
> The convention is that the KEY either equals the SID or EXTPROC0
>
> >3. I have seen a tnsnames.ora definition which includes the setting
> >"(PRESENTATION = R0)" - What does this mean? Is it necessary?
> >
> >
> Sqlnet in 8i supports both 'ordinary' and jdbc clients.
> The presentation=r0 line is referring to ordinary clients. I'm not
> sure what the default is.

Thanks. I had read in several articles in MetaLinks that Oracle was recommending a seperate listener under 8i and the articles specifically mentioned that this was a change from 8.0.

Right now I am dealing with intermittant ora-28575 errors. The wierd thing is that it works "most of the time". As I get deeper into the analysis I just keep running into so many different factors.

One thing I did notice along the way is that the version I am dealing with is 8.1.5.0.0. Since there is a 8.1.5.1.1 patch available I've made the strong recommendation that the database be upgraded to the latest patch so that we can at least eliminate any known bugs that have been resolved with the patches. Received on Sat Sep 30 2000 - 08:25:33 CDT