哎,又是一个BUG,11.2.0.3版本还有.......
运行awrrpt.sql生成AWR报告出错
'>SELECT ATTRIBUTE9 FROM SCCMES.SCC_WIP_PARAMS WHERE Organization_Id = :1 AND WIP_ENTITY_ID = :2 AND Attribute_Category = :3
ERROR:
ORA-06502: PL/SQL: numeric or value error: character string buffer too 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 Too Small (Îĵµ ID 1303342.1) תµ½µ×²¿
--------------------------------------------------------------------------------
ÐÞ¸Äʱ¼ä:2012-8-16ÀàÐÍ:PROBLEM
In this Document
--------------------------------------------------------------------------------
Applies to:
Oracle Server - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
Symptoms
AWR report fails with following errors:
ORA-06502: PL/SQL: numeric or value error: character string buffer 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 body SYS.DBMS_WORKLOAD_REPOSITORY
c0000004b52d33c0 1 anonymous block
----- Call Stack Trace -----
kkxures kkxmpsexe kgmexwi kgmexec evapls evaopn2 qerocnFetch qerocFetch
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 the cause:
Note:6458801.8 Bug 6458801 - REPLACE on a CLOB can corrupt multibyte 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)