ORA-00600 [kwqitnmphe:ltbagi] Errors even after the fix for Bug 17831758 and Bug 18536720 is in place (Doc ID 2002540.1)

简介: ORA-00600 [kwqitnmphe:ltbagi] Errors even after the fix for Bug 17831758 and Bug 18536720 is in place (Doc ID 2002540.1)
  1. Do the following to purge the data in the queue table and IOTs

connect / as sysdba

DECLARE
po dbms_aqadm.aq$_purge_options_t;
BEGIN
po.block := FALSE;
DBMS_AQADM.PURGE_QUEUE_TABLE(
queue_table => 'SYS.SYS$SERVICE_METRICS_TAB',
purge_condition => NULL,
purge_options => po);
END;
/

The data in this queue table is transitory, so although it is lost it will soon be replaced.

  1. Apply the fixes for bug 17831758, bug 18536720 and bug 16204151 and ensure that post-install steps are followed.

All bugs will be resolved in 12.2 when it is available.

相关文章
|
关系型数据库 Shell Oracle
RMAN-01009: syntax error: found "dot" 解决办法
RMAN-01009: syntax error: found "dot" 解决方法   今天调试一个RMAN 的备份脚本,这个脚本以前也用过很多次,并没有什么问题,今天执行时,就是过不去。
1406 0
|
2月前
|
JavaScript
Error loading saved preferences: ~/.vuerc may be corrupted or have syntax errors. Please fix/delete
Error loading saved preferences: ~/.vuerc may be corrupted or have syntax errors. Please fix/delete
|
4月前
【Bug】ERROR ResizeObserver loop completed with undelivered notifications.
【Bug】ERROR ResizeObserver loop completed with undelivered notifications.
【异常】svn: E200009: Commit failed (details follow)/both sides of the move must be committed together的解决办法
svn: E200009: Commit failed (details follow)/both sides of the move must be committed together的解决办法
596 0
|
Oracle 关系型数据库 数据库
Oracle 11.2.0.1 BUG 8730312 kewastUnPackStats(): bad magic 1 (0xXXXXXXXXX, 0)
一个客户反应Oracle数据库非常慢,客户端经常连接不上,我登录上去后查看awr报告
110 0
|
Java C语言 C++
JNI ERROR (app bug): local reference table overflow (max=512)
JNI ERROR (app bug): local reference table overflow (max=512)
303 0
JNI ERROR (app bug): local reference table overflow (max=512)
SAP QM 执行事务代码QA11 报错- Selected set code does not exist, or data entered is incomplete-
SAP QM 执行事务代码QA11 报错- Selected set code does not exist, or data entered is incomplete-
SAP QM 执行事务代码QA11 报错- Selected set code does not exist, or data entered is incomplete-
|
iOS开发
Xcode报错:Failed to find a suitable device for the type SimDeviceType解决方法
Xcode报错:Failed to find a suitable device for the type SimDeviceType解决方法
200 0
[swscaler] Warning: data is not aligned! This can lead to a speedloss 的解决方法【FFmpeg】
[swscaler] Warning: data is not aligned! This can lead to a speedloss 的解决方法【FFmpeg】
720 0
[swscaler] Warning: data is not aligned! This can lead to a speedloss 的解决方法【FFmpeg】