Re: ORA-12850 running ash_wait_chains against 19c database

i went as low as 11.2.0.4 to no avail. just looked at 10053 trace and about the only thing i noticed was "mesg=kxfxcp: slave join failed".

On Thu, Jul 11, 2019 at 8:51 AM Andy Klock <andyklock_at_gmail.com> wrote:

> > Chris Stephens <cstephens16_at_gmail.com> writes:
>
> > we recently installed 19c GI/RDBMS as a 3 node RAC cluster.
> >
> ...
> > I did some googling and some searching on support.oracle.com to no
> avail.
> > I've got an SR open but was wondering if anyone else has hit this and/or
> > has a solution to prevent the ORA-12850.
> >
> > Thanks in advance for any help!
>
>
> I have not, but I'm also not on 19c. The assumption is that the CBO has
> chosen a plan that requires more slaves than you have available. Perhaps
> an adaptive plan or something? For a quick and dirty test, try downgrading
> the optimizer for the
> session and see what happens.
>
> Something like,
>
> alter session set optimizer_features_enable = '12.1.0.2'; -- or even
> lower if you've left the adaptive features enabled
>
> Andy K
>

--
http://www.freelists.org/webpage/oracle-l