问题描述
客户11.2.0.2 RAC for Solaris 10出现ORA-600错误。
错误信息为：
Fri May 11 14:22:45 2012 Errors IN file /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_25552.trc (incident=194913): ORA-00600: 内部错误代码, 参数: [qerrmOStart2], [1740], [ORA-01740: 标识符中缺失双引号 ], [], [], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trc Fri May 11 14:23:29 2012 Fri May 11 14:23:29 2012 Dumping diagnostic DATA IN directory=[cdmp_20120511142329], requested BY (instance=2, osid=25552), summary=[incident=194913].USE ADRCI OR Support Workbench t o package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Exception [TYPE: SIGSEGV, Stack Overflow] [ADDR:0x8] [PC:0x10611C144, qerrmOdcl()+36] [flags: 0x0, COUNT: 1] Errors IN file /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_25552.trc (incident=194914): ORA-07445: 出现异常错误: 核心转储 [qerrmOdcl()+36] [SIGSEGV] [ADDR:0x8] [PC:0x10611C144] [Stack Overflow] [] ORA-00600: 内部错误代码, 参数: [qerrmOStart2], [1740], [ORA-01740: 标识符中缺失双引号 ], [], [], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194914/orcl2_ora_25552_i194914.trc USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Fri May 11 14:23:30 2012 Sweep [inc][194913]: completed Sweep [inc][194914]: completed Sweep [inc2][194913]: completed复制
专家解答
虽然这个操作在MOS没有相关描述，但是根据错误信息分析，这个ORA-600只是标识作用，真正的错误是随后参数中的ORA-1740错误。而这个错误信息更像是一个语句分析的错误。
$ more /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trc
Dump file /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trc
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
WITH the Partitioning, REAL Application Clusters, OLAP, DATA Mining
AND REAL Application Testing options
ORACLE_HOME = /oracle/product/11.2.0/dbhome_1
System name: SunOS
Node name: orcl2
Release: 5.10
Version: Generic_147440-02
Machine: sun4u
Instance name: orcl2
Redo thread mounted BY this instance: 2
Oracle process NUMBER: 364
Unix process pid: 25552, image: oracle@orcl2
*** 2012-05-11 14:22:45.579
*** SESSION ID:(1590.33807) 2012-05-11 14:22:45.579
*** CLIENT ID:() 2012-05-11 14:22:45.579
*** SERVICE NAME:(orcl) 2012-05-11 14:22:45.579
*** MODULE NAME:(PL/SQL Developer) 2012-05-11 14:22:45.579
*** ACTION NAME:(SQL Window - NEW) 2012-05-11 14:22:45.579
Dump continued FROM file: /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_25552.trc
ORA-00600: 内部错误代码, 参数: [qerrmOStart2], [1740], [ORA-01740: 标识符中缺失双引号
], [], [], [], [], [], [], [], [], []
========= Dump FOR incident 194913 (ORA 600 [qerrmOStart2]) ========
*** 2012-05-11 14:22:45.606
dbkedDefDump(): Starting incident DEFAULT dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=2z1m6fp3p7qjd) -----
SELECT o_no,
c_state,
d_state,
D_CONTENT,
O_TIME,
o_id,
O_NAME,
l_name,
l_order
FROM
(SELECT b.o_no,a.c_state,'' d_state, a.D_CONTENT,a.O_TIME,a.o_id,a.O_NAME,
l_name,l_order,
ROW_NUMBER() OVER(PARTITION BY a.O_ID ORDER BY a.O_TIME DESC) RN
FROM T_O_D@DB_A A, T_B_O@DB_A B,t_b_o_l@db_a c
WHERE A.O_ID = B.O_ID
AND a.o_id = c.o_id
AND A.O_TIME >= TRUNC(SYSDATE - 1)
AND A.O_TIME < TRUNC(SYSDATE)
AND NOT EXISTS (SELECT 1
FROM T_B_O_E@DB_A O
WHERE O.O_ID = A.O
AND O.O_TIME >= TRUNC(SYSDATE - 1)
AND O.O_TIME < TRUNC(SYSDATE))
UNION ALL
SELECT b.o_no,a.c_state, 'TK',a.s_remark,a.O_TIME,a.o_id,a.O_NAME,
l_name,l_order,
ROW_NUMBER() OVER(PARTITION BY a.O_ID ORDER BY a.O_TIME DESC) RN
FROM T_B_O_E@DB_A A, T_B_O@DB_A B,t_b_o_l@db_a c
WHERE A.O_ID = B.O_ID
AND a.o_id = c.o_id
AND A.O_TIME >= TRUNC(SYSDATE - 1)
AND A.O_TIME < TRUNC(SYSDATE)
AND b.r_time >= TRUNC(SYSDATE - 1)
AND b.r_time < TRUNC(SYSDATE)
AND b.p_state = '2'
AND a.e_type = '14'
UNION ALL
SELECT b.o_no,a.c_state,'TD', a.s_remark,a.O_TIME,a.o_id,a.O_NAME,
l_name,l_order,
ROW_NUMBER() OVER(PARTITION BY a.O_ID ORDER BY a.O_TIME DESC) RN
FROM T_B_O_E@DB_A A, T_B_O@DB_A B,t_b_o_l@db_a c
WHERE A.O_ID = B.O_ID
AND a.o_id = c.o_id
AND A.O_TIME >= TRUNC(SYSDATE - 1)
AND A.O_TIME < TRUNC(SYSDATE)
AND b.c_tag = '1'
AND a.e_type = '04'
UNION ALL
SELECT to_char(P_ID), STATE, DECODE(STATE, '1', 'S', '2', 'ZDTD'), NULL,
U_TIME, NULL, NULL, NULL, NULL, 1
FROM T_B_B_I@DB_A A
WHERE STATE IN ('1', '2')
AND SCODE = 'EMAL'
AND U_TIME >= TRUNC(SYSDATE - 1)
AND U_TIME < TRUNC(SYSDATE))
WHERE rn = 1
----- Call Stack Trace -----
calling CALL entry argument VALUES IN hex
location TYPE point (? means dubious VALUE)
-------------------- -------- -------------------- ----------------------------
ksedst1()+96 CALL skdstdst() FFFFFFFF7FFEEED0 ?
1006B0C80 ? 000000000 ?
00000000A ? 000000001 ?
10BD95B00 ?
ksedst()+60 CALL ksedst1() 000000000 ? 000000001 ?
00010C212 ? 00010C000 ?
10C20A000 ? 00010C20A ?
dbkedDefDump()+2032 CALL ksedst() 000000000 ? 10B25B000 ?
10B25B2B0 ? 10C212000 ?
00010B000 ? 00010C212 ?
dbgexPhaseII()+1800 PTR_CALL dbkedDefDump() 000000003 ? 000000002 ?
10A6EC2C8 ? 0000014B0 ?
10C20A000 ? 000000003 ?
dbgexProcessError() CALL dbgexPhaseII() 10C3B4650 ?
+1248 FFFFFFFF7BE3A578 ?
FFFFFFFF7FFF3C28 ?
0018E0000 ? 10A6E35B8 ?
000001C00 ?
dbgePostErrorKGE()+ CALL dbgeExecuteForError 10AE0C3FD ?
1320 () FFFFFFFFFEC0B62D ?
001050000 ?
FFFFFFFF7FFF63D8 ?
001060000 ? 000000028 ?
dbkePostKGE_kgsf()+ CALL dbgePostErrorKGE() 10C20AC90 ? 000000000 ?
44 FFFFFFFF7BE3A578 ?
000000000 ? 000000258 ?
00010C000 ?
kgerinv_internal()+ CALL kgeadse() 10C20AC90 ?
72 FFFFFFFF7BC22F20 ?
000000258 ? 000002868 ?
10A6E4000 ? 00010A6E4 ?
kgerinv()+40 CALL kgerinv_internal() 10C20AC90 ? 004EA2360 ?
10BC2F628 ? 000000258 ?
000000000 ? 000000002 ?
kgesinv()+20 CALL kgerinv() 10C20AC90 ?
FFFFFFFF7BC22F20 ?
10BC2F628 ? 000000002 ?
FFFFFFFF7FFF7840 ?
000001400 ?
ksesin()+92 CALL kgesinv() 10C20AC90 ?
FFFFFFFF7BC22F20 ?
10BC2F628 ? 000000002 ?
FFFFFFFF7FFF7840 ?
00010C212 ?
OCIKSIN()+412 CALL ksesin() 10BC2F628 ? 10C212000 ?
00010C000 ? 00010C000 ?
00010C20A ? 00010C212 ?
qerrmOStart()+516 CALL OCIKSIN() FFFFFFFFFFFFFFFF ?
0000006CC ? 10BC2F628 ?
00010BA9D ? 10BA9D890 ?
FFFFFFFF7FFF786C ?
qerrmStart()+1528 CALL qerrmOStart() 10E603CD58 ?
FFFFFFFF7BC68170 ?
000000000 ?
FFFFFFFF7DF91088 ?
000106000 ?
FFFFFFFF7BC67F2C ?
selexe0()+976 PTR_CALL qerrmStart() FFFFFFFF7BC68170 ?
000000003 ? 10E603CD58 ?
FFFFFFFF7BC75250 ?
000000001 ?
FFFFFFFF7DFBE5C8 ?
opiexe()+11664 CALL selexe0() FFFFFFFF7BC367C8 ?
10C21FAE0 ?
FFFFFFFF7BC41C90 ?
000000000 ? 10E60B2EE0 ?
10C21F000 ?
kpoal8()+2368 CALL opiexe() 000000049 ? 000000003 ?
FFFFFFFF7FFF9E8C ?
000000000 ? 000000000 ?
0BFFFFFFF ?
opiodr()+1428 PTR_CALL kpoal8() 00000005E ? 00000001C ?
FFFFFFFF7FFFD348 ?
00010C000 ? 10C20A000 ?
000001648 ?
ttcpip()+1056 PTR_CALL opiodr() 00010A795 ? 00000001C ?
103EAD460 ? 00010A400 ?
000001400 ? 10C20A000 ?
opitsk()+1528 CALL ttcpip() 000000000 ? 10A6C7694 ?
10C20AC90 ?
FFFFFFFF7FFFD348 ?
FFFFFFFF7FFFBD90 ?
10C221848 ?
opiino()+1000 CALL opitsk() 10A6C7694 ? 10C226C98 ?
10C221654 ? 10C21F958 ?
000000000 ? 10C20A950 ?
opiodr()+1428 PTR_CALL opiino() 00010C000 ? 10C2216D0 ?
10C2216D0 ? 000380000 ?
0000000EB ?
FFFFFFFF7FFFECA0 ?
opidrv()+1100 CALL opiodr() 10C221000 ? 000000004 ?
1035DD740 ? 00010C000 ?
000001400 ? 10C20A000 ?
sou2o()+92 CALL opidrv() 00000003C ? 000000004 ?复制显然这是PL/DEVELOPER执行或解析语句的时候引发的问题，本质上是一个普通的编译错误，但是Oracle将其作为内部ORA-600错误报了出来。
对于这个错误可以简单的忽略。
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
相关阅读
【纯干货】Oracle 19C RU 19.27 发布，如何快速升级和安装？
Lucifer三思而后行
638次阅读
2025-04-18 14:18:38
Oracle RAC 一键安装翻车？手把手教你如何排错！
Lucifer三思而后行
618次阅读
2025-04-15 17:24:06
XTTS跨版本迁移升级方案（11g to 19c RAC for Linux）
zwtian
514次阅读
2025-04-08 09:12:48
Oracle数据库一键巡检并生成HTML结果，免费脚本速来下载!
陈举超
510次阅读
2025-04-20 10:07:02
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
475次阅读
2025-04-22 00:20:37
Oracle 19c RAC更换IP实战，运维必看！
szrsu
452次阅读
2025-04-08 23:57:08
【活动】分享你的压箱底干货文档，三篇解锁进阶奖励！
墨天轮编辑部
451次阅读
2025-04-17 17:02:24
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
448次阅读
2025-04-22 00:13:51
一页概览：Oracle GoldenGate
甲骨文云技术
447次阅读
2025-04-30 12:17:56
火焰图--分析复杂SQL执行计划的利器
听见风的声音
393次阅读
2025-04-17 09:30:30
TA的专栏
Java中间件
收录0篇内容
热门文章
一次Connection reset by peer的问题排查
2021-12-07 34163浏览
Java8-Stream: no instance(s) of type variable(s) R exist so that void conforms to R
2021-02-19 32423浏览
nginx: [emerg] "user" directive is not allowed here in /etc/nginx/conf.d/nginx.conf:1
2022-02-15 24315浏览
ORA-00904: "POLTYP": invalid identifier
2019-06-19 12940浏览
PageHelper排坑，处理排序失败: net.sf.jsqlparser.JSQLParserException
2022-05-19 12823浏览
