ORA-06512 – Database SOS

标题：ORACLE 11.2.0.3 生成awr html文件报SYS.DBMS_WORKLOAD_REPOSITORY异常

在想分析数据库性能的关键时刻,突然发现awr不能正常的工作,那就和你上了战场突然发现枪没有子弹一样的郁闷,今天就遇到了11.2.0.3在win的环境中awr生成html不能正常工作.通过查询mos发现该问题出现在各种平台中(win,linux,aix等),提醒大家注意该问题.
数据库版本

SQL> SELECT * FROM V$VERSION;
BANNER
-------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for 32-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

awr报错(html)

SQL> @?/rdbms/admin/awrrpt.sql
ORA-06502: PL/SQL: 数字或值错误 :  字符串缓冲区太小
ORA-06512: 在 "SYS.DBMS_WORKLOAD_REPOSITORY", line 919
ORA-06512: 在 line 1

设置errorstack

SQL> alter session set events '6502 trace name errorstack level 12';
会话已更改。

分析错误

----- Error Stack Dump -----
ORA-06502: PL/SQL: 数字或值错误 :  字符串缓冲区太小
----- Current SQL Statement for this session (sql_id=572fbaj0fdw2b) -----
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
94348684       919  package body SYS.DBMS_WORKLOAD_REPOSITORY
983BAD54         1  anonymous block
----- Call Stack Trace -----
_skdstdst()+121      CALLrel  _kgdsdst()           19D99520 2
_ksedst1()+93        CALLrel  _skdstdst()          19D99520 0 1 485816 4863B2
                                                   485816
_ksedst()+49         CALLrel  _ksedst1()           0 1
_dbkedDefDump()+368  CALLrel  _ksedst()            0
6
_ksedmp()+44         CALLrel  _dbkedDefDump()      C 0
_dbkdaKsdActDriver(  CALLreg  00000000             C
)+4209
…………

通过查询mos发现Bug 13575143一致，可以确定是该bug,但是通过进一步测试证明不光是awrrpt会出现该错误,awr的相关报告中,只要是展示html结果的都有可能出现类此错误(比如awrrpti.sql/awrddrpt.sql/awrddrpi.sql等等).同时这里通过进一步分析发现其实该bug的起源是Bug 6458801(REPLACE on a CLOB can corrupt multibyte data ID 6458801.8),不过该bug说明已经在11.2.0.1中修复,其实通过这里的分析发现并没有真正的在11.2.0.3中修复该bug,针对该问题没有官方没有提供较好解决方法,只能是用过WORKAROUND来临时解决

They are able to generate the AWR report in the .txt format

Fri Dec 30 12:22:36 2011 Errors in file /oracle9/app/admin/ykcdb/udump/ykcdb_ora_5390564.trc: ORA-19583: conversation terminated due to error ORA-27206: requested file not found in media management catalog ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 625

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning option JServer Release 9.2.0.7.0 - Production ORACLE_HOME = /oracle9/app/product/9.2.0 System name: AIX Node name: OFFON2 Release: 3 Version: 5 Machine: 000A36B8D600 Instance name: ykcdb Redo thread mounted by this instance: 1 Oracle process number: 79 Unix process pid: 5390564, image: oracle@OFFON2 (TNS V1-V3) *** 2011-12-30 12:22:36.051 *** SESSION ID:(32.62184) 2011-12-30 12:22:36.023 FATAL ERROR IN TWO-TASK SERVER: error = 12152 *** 2011-12-30 12:22:36.051 ksedmp: internal or fatal error ORA-19583: conversation terminated due to error ORA-27206: requested file not found in media management catalog ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 625 ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp+0148 bl ksedst 1025AE55C ? opitsk+0968 bl ksedmp 20289E71C ? opiino+0798 bl opitsk 000000000 ? 000000000 ? opiodr+08c8 bl _ptrgl opidrv+032c bl opiodr 3C00000018 ? 4101C7F40 ? FFFFFFFFFFFF810 ? 0A03547C8 ? sou2o+0028 bl opidrv 3C0C000000 ? 4A039C2D0

标签归档：ORA-06512