Awr Report Generates&n…

哎，又是一个BUG，11.2.0.3版本还有.......

 

运行awrrpt.sql生成AWR报告出错

'>SELECT ATTRIBUTE9 FROM SCCMES.SCC_WIP_PARAMS WHEREOrganization_Id = :1 AND WIP_ENTITY_ID = :2 AND Attribute_Category= :3
ERROR:
ORA-06502: PL/SQL: numeric or value error: character string buffertoo small
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 919
ORA-06512: at line 1

Report written to awrrpt_2_1830_1831.html
SQL> exit

 

参考：

Awr Report Generates Ora-06512 & Ora-06502 With Buffer TooSmall (Îĵµ ID 1303342.1) תµ½µ×²¿ 

--------------------------------------------------------------------------------

ÐÞ¸Äʱ¼ä:2012-8-16ÀàÐÍ:PROBLEM    
 

In this Document

 Symptoms
 Cause
 Solution
 References

--------------------------------------------------------------------------------

Applies to:
Oracle Server - Enterprise Edition - Version 10.2.0.4 andlater
Information in this document applies to any platform.

Symptoms

AWR report fails with following errors:

ORA-06502: PL/SQL: numeric or value error: character stringbuffer too small
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 313
Current SQL statement for this session:
select output from table(dbms_workload_repository.awr_report_html(:dbid,
:inst_num,
:bid, :eid,
:rpt_options ))
----- PL/SQL Call Stack -----
object line object
handle number name
c0000004c892e3c0 313 package bodySYS.DBMS_WORKLOAD_REPOSITORY
c0000004b52d33c0 1 anonymous block
----- Call Stack Trace -----

kkxures kkxmpsexe kgmexwi kgmexec evapls evaopn2 qerocnFetchqerocFetch

Cause

Symptoms are similar to following bug:

Bug 7833620: ORA-06502 WHEN RUNNING AWRRPT.SQL

The base bug is Bug 6458801 which was determined to be thecause:
Note:6458801.8 Bug 6458801 - REPLACE on a CLOB can corruptmultibyte data
 
Solution

1. Apply patch 6458801.

2. The bug is fixed in following versions:

?11.2.0.1 (Base Release)
?11.1.0.7 (Server Patch Set)
?10.2.0.5 (Server Patch Set)