生成AWR时出错, ERROR: ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SYS.DBMS_WORKLOAD_REPOSITORY"

生成AWR报表时，出现 如下错误

ERROR: ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SYS.DBMS_WORKLOAD_REPOSITORY", line 919 ORA-06512: 在 line 1

数据库版本为WIN64，11.2.0.3

在oracle support中查询如下，确认为bug

在之前的MOS中也提到这个bug,出现版本为Oracle 10.2.0.4，修复版本为Oracle 11.2.0.1。

在Oracle 11.2.0.3.0中这个bug再次出现，MOS也给出解决方法：

Bug 13527323 - ORA-6502 generating HTML AWR report using awrrpt.sql in Multibyte characterset database [ID 13527323.8]

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
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

12.1 (Future Release) 11.2.0.3.3 Patch Set Update 11.2.0.3 Bundle Patch 7 for Exadata Database 11.2.0.3 Patch 7 on Windows Platforms

下载11.2.0.3 Patch 7 on Windows Platforms 利用Opatch打补丁。步骤如下:

 

 

1.关闭ORACLE所有服务
在服务中停止掉

2.报如下错误 Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following files are active :
D:\app\Administrator\product\11.2.0\dbhome_1\bin\oci.dll。

将服务中的Distributed Transaction Coordinator
关闭掉

3 再次apply

D:\14095820>D:\app\Administrator\product\11.2.0\dbhome_1\OPatch\opatch apply

 

4  apply成功后，运行如下SQL

> cd %ORACLE_HOME%\Bundle\Patch7
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catwinbundle.sql
SQL> QUIT

5 最后再运行如下SQL.

> cd %ORACLE_HOME%\rdbms\admin
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql