ORACLE 11.2.0.3建立AWR FOR HTML报ORA-06502
11.2.0.3建立html的awr报告时候报ORA-06502,但是建立text文本格式是正常的,
详细信息如下:
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
原因由于ORACLE的BUG引起,打上补丁13527323解决.
METALINK的原文:
In case of multibyte characters in SQL text, sometime AWR report
generation fails with error ORA-6502. Also sending more than
4000 bytes of single varchar data to JDBC api's causes
truncation of data.
Rediscovery Notes:
If html AWR report generation fails with ORA-6502 or generating
AWR report using JDBC api's causes truncation of data then this bug
as probably been rediscovered.
Workaround
None
11.2.0.3建立html的awr报告时候报ORA-06502,但是建立text文本格式是正常的,
详细信息如下:
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
原因由于ORACLE的BUG引起,打上补丁13527323解决.
METALINK的原文:
In case of multibyte characters in SQL text, sometime AWR report
generation fails with error ORA-6502. Also sending more than
4000 bytes of single varchar data to JDBC api's causes
truncation of data.
Rediscovery Notes:
If html AWR report generation fails with ORA-6502 or generating
AWR report using JDBC api's causes truncation of data then this bug
as probably been rediscovered.
Workaround
None
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/86358/viewspace-740206/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/86358/viewspace-740206/