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.

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

Comment

*

沪ICP备14014813号

沪公网安备 31010802001379号