巡检发现alert日志出现ORA-00600: 内部错误代码, 参数: [qkaffsindex3]错误,清各位老师帮忙看一下,谢谢!
Dump continued from file: /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_j005_3397.trc
ORA-00600: 内部错误代码, 参数: [qkaffsindex3], [], [], [], [], [], [], [], [], [], [], []
========= Dump for incident 28957 (ORA 600 [qkaffsindex3]) ========
*** 2021-11-21 06:01:42.447
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=173zm67sh2bu3) -----
/* SQL Analyze(315,1) */ INSERT INTO
TEMP_TASK_QUEUE(ID,PTYPE,PROCESSID,TASKNAME,TASKID,PROKEY,TITLE,USERID,CREATETIME,EMERGEMCYLEVEL,PUBLICTASK,TASKTYPE,SERVERCODE)
SELECT SEQ_TEMP_TASK_QUEUE.NEXTVAL ID,'M' PTYPE,M.OID PROCESSID,SMCC.NAME TASKNAME,M.OID TASKID,MODULE_CODE PROKEY,MSG_TITLE
TITLE,(
SELECT WM_CONCAT(U.ACCOUNT_NO) FROM SYS_MESSAGE_RECEIVER MR,SYS_USER U WHERE
MR.MSG_ID=M.OID AND U.USER_ID=MR.USER_ID
) USERID,M.CREATE_TIME CREATETIME,M.MSG_LEVEL EMERGEMCYLEVEL,'Y'
PUBLICTASK,'Y' TASKTYPE,'40050000000001' SERVERCODE
FROM SYS_MESSAGE M,SYS_MESSAGE_CONF_CODE SMCC
WHERE MSG_STATE=2 AND M.MODULE_CODE = SMCC.CODE AND SMCC.MODULE!='1'
AND NOT EXISTS(
SELECT 1 FROM TEMP_TASK_QUEUE Q WHERE
Q.PTYPE='M' AND Q.TASKID=M.OID
)
AND NOT EXISTS(
SELECT 1 FROM TEMP_TASK Q WHERE
Q.PTYPE='M' AND Q.TASKID=M.OID
)
