ORA-00600[qcsfbdnp:1]错误解析

ORA-00600[qcsfbdnp:1]错误解析 ，该错误主要对应  bug 13496884  ORA-600 [qcsfbdnp:1] from Merge Statement with Bind  Variables

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions BELOW 12.1
Versions confirmed as being affected	11.2.0.3 11.2.0.2
Platforms affected	Generic (all / most platforms affected)

Fixed:

The fix for 13496884 is first included in

12.1.0.1 (Base Release) 11.2.0.4 (Server Patch Set) 11.2.0.3.6 Database Patch Set Update 11.2.0.3 Bundle Patch 16 for Exadata Database 11.2.0.3 Patch 18 on Windows Platforms

Interim patches may be available for earlier versions – click here to check.

Description

A MERGE statement containing bind variable references sometimes fails
reporting an ORA-600 [qcsfbdnp:1] or ORA-1008 errors.
 
Note:
 The fix replaces the fix from bug:10087130
 

qcsfbdnp 其中QCS代表 Query Compile Semantic Analysis，即查询编译时的语义分析。由于这个语义分析过程无法绕过，所以该问题主要通过打补丁来解决， 可选的几个补丁方案：

This problem has been investigated and resolved in:
Bug:13496884 – ORA-600 [QCSFBDNP:1]

Bug:13496884 is fixed in 12.1 and 11.2.0.4.

SOLUTION

To implement a solution for Bug:13496884, please consider any of below alternatives:

• Upgrade to RDBMS 11.2.0.4 or higher in which Bug:13496884 is fixed.

OR

• Install 11.2.0.3.6 Database Patch Set Update or later.
• For Windows platform bug is fixed starting with 11.2.0.3 Patch 18

OR

• Check for the availability of one-off Patch:13496884 for your platform on My Oracle Support