ora-600 qostobkglcrt2:objn

原创

于 2015-12-11 20:26:39 发布 · 798 阅读

0 ·

CC 4.0 BY-SA版权

博客讲述了在删除物化视图后，遇到ora-600 qostobkglcrt2:objn错误的情况。数据库发送了告警，触发了默认的事故dump。当前SQL会话的详细信息和PL/SQL堆栈被记录下来，为问题排查提供线索。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

物化视图被删导致ora-600 qostobkglcrt2:objn 报错

收到数据库告警内容：

告警定位信息:*.*.*.*_xxxxx_Internal error (ORA 600 [qostobkglcrt2:objn]) detected in /opt/oradiag/db/

登陆数据库查看alert 日志：

ORA-00600: internal error code, arguments: [qostobkglcrt2:objn], [2805471], [], [], [], [], [], [], [], [], [], []
Incident details in: XXXXXX_j000_20254_i137097.trc
Fri Dec 11 20:00:11 2015
Sweep [inc][137097]: completed
Sweep [inc][137096]: completed
Sweep [inc2][137096]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file XXXXXX_j000_20254.trc:
ORA-12012: error on auto execute of job "XXXX"."XXXXXX"
ORA-23401: materialized view "XX"."XXXXXX" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line