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.

Symptoms:

Related To:
  • Internal Error May Occur (ORA-600)
  • ORA-1008
  • ORA-600 [qcsfbdnp:1]
  • Merge SQL (MERGE .. USING)
  • MERGE

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