Re: 8i and 9i on the same server

Re: "it is imposible migrate everything at one night" - It depends on the complications of the migration. I don't see a reason to tag this as impossible.

You do need to change listener.ora to have external procedures work with Oracle 9iR2, if you are running into ORA-28595. Read Note: 198523.1 on metalink

In short:

you have to specify:
(ENVS="EXTPROC_DLLS=<pathtodll>") or (ENVS="EXTPROC_DLLS=ANY")

.........

Anurag

"aaa" <leed_at_shell.cais.com> wrote in message news:b3h4dh0935_at_drn.newsguy.com...
> We have 8i and 9i on the same SUN computer (solaris 8). It worked correctly.
> A lot company also doing that. Especially when you doing production migration,
> it is imposible migrate everything at one night. I don't think you need change
> kernel parameter for ORACLE.
>
> In article <3E5BDD12.1465DD8A_at_exesolutions.com>, DA says...
> >
> >Salaam Yitbarek wrote:
> >
> >> OS: Solaris 7
> >> Hardware: Sun Enterprise 450
> >>
> >> Anyone out there able to have both 8i and 9i on the same machine and
> >> have external procedures working on 8i and 9i databases?
> >>
> >> Salaam
> >
> >It can be made to work but I would discourage it. Kernel parameters are
> >different and the setup is ripe for errors unless managed by someone
> >that can devote appropriate attention to it.
> >
> >Daniel Morgan
> >
>
Received on Tue Feb 25 2003 - 20:44:46 CST