Query Errors ‘ORA-12850: Could Not Allocate Slaves On All Specified Instances‘ (Doc ID 2388821.1)

转载于 2022-01-04 22:05:32 发布

· 747 阅读

0 ·

版权

原文链接：https://support.oracle.com/epmos/faces/DocContentDisplay?id=2388821.1

文章标签：

#dba

Oracle MOS 文档专栏收录该内容

12 篇文章

订阅专栏

当执行查询时遇到ORA-12850错误，表明无法在所有指定实例上分配奴隶。此问题与内部bug有关，该bug已被标记为另一个bug的重复。解决方案包括更新到12.2.0.1版本或应用补丁19768896。作为临时解决办法，可以使用optimizer_features_enable设置为'11.2.0.4'。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

In this Document

APPLIES TO:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

SYMPTOMS

Query hangs with following error:

ORA-12850: Could Not Allocate Slaves On All Specified Instance

Query works with optimizer_features_enable string 11.2.0.4

CAUSE

Internal bug was filed but closed as duplicate to another bug:

Bug 26680874 SQL MONITORING QUERY RAISES ORA-12850 >>>>>>> Unpublished bug closed as duplicate to following
Bug 19768896 : ALWAYS ALLOW INDEX WHEN COMPARING TIMESTAMP TO DATE COLUMN

SOLUTION

1.Bug is fixed in 12.2.0.1
2.Apply Patch 19768896
3.Workaround is to use optimizer_features_enable(‘11.2.0.4’):

/*+ optimizer_features_enable('11.2.0.4') */