生成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也给出解决方法:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
下载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