应用范围
Oracle Server – 企业版,版本号:11.2.0.2及以后版本。
本文适于任何操作系统平台。
故障症状
执行DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE失败,报错:
情况(1):
ORA-15516: parallel preprocessing worker hit error
ORA-1458 invalid length inside variable character string
情况(2):
ORA-15518: parallel preprocessing encountered an unexpected error
ORA-6512: at "SYS.DBMS_WORKLOAD_REPLAY", line 2010
告警日志,报错内容:
ORA-7445 [kecppSeqEndCallProcessing()+1992]
故障原因
以上两种错误情况都是由于如下未发布的bug造成:
Bug 10327241: DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE RAISES ORA-15518
故障解决
应用补丁:10327241
此bug在Oracle 11.2.0.3以及12g中已修复。
参考资料
BUG:10177766 - DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE FAILS WITH ORA-1458
NOTE:10327241.8 - Bug 10327241 -DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE fails ORA-15518
相关故障
ORA-1458; ORA-15516; ORA-15518