ORA-600(qerrmOStart2)错误

1、.ORA-600(qerrmOStart2)错误客户11.2.0.2 RAC for Solaris 10出现ORA-600错误。错误信息为：Fri May 11 14:22:45 2012Errors 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/r

2、dbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trcFri May 11 14:23:29 2012Fri May 11 14:23:29 2012Dumping diagnostic data in directory=cdmp_20120511142329, requested by (instance=2, osid=25552), summary=incident=194913.Use ADRCI or Support Workbench to package the incident.See Note 4

3、11.1 at My Oracle Support for error and packaging details.Exception type: SIGSEGV, Stack Overflow ADDR:0x8 PC:0x10611C144, qerrmOdcl()+36 flags: 0x0, count: 1Errors in file /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_25552.trc (incident=194914):ORA-07445: 出现异常错误: 核心转储qerrmOdcl()+36 SIGSEGV ADDR:0x

4、8 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.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Sup

5、port for error and packaging details.Fri May 11 14:23:30 2012Sweep inc194913: completedSweep inc194914: completedSweep inc2194913: completed虽然这个操作在MOS没有相关描述，但是根据错误信息分析，这个ORA-600只是标识作用，真正的错误是随后参数中的ORA-1740错误。而这个错误信息更像是一个语句分析的错误。$ more /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_255

6、52_i194913.trcDump file /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trcOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsORACLE_HOME = /or

7、acle/product/11.2.0/dbhome_1System name: SunOSNode name: orcl2Release: 5.10Version: Generic_147440-02Machine: sun4uInstance name: orcl2Redo thread mounted by this instance: 2Oracle process number: 364Unix process pid: 25552, image: oracleorcl2* 2012-05-11 14:22:45.579* SESSION ID:(1590.33807) 2012-0

8、5-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.579Dump continued from file: /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_25552.trcORA-006

9、00: 内部错误代码, 参数: qerrmOStart2, 1740, ORA-01740: 标识符中缺失双引号, , , , , , , , , = Dump for incident 194913 (ORA 600 qerrmOStart2) =* 2012-05-11 14:22:45.606dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)- Current SQL Statement for this session (sql_id=2z1m6fp3p7qjd) -select

10、o_no,c_state,d_state,D_CONTENT,O_TIME,o_id,O_NAME,l_name,l_orderfrom(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) RNFROM T_O_DDB_A A, T_B_ODB_A B,t_b_o_ldb_a cWHERE A.O_ID = B.O_IDAND a.o

11、_id = c.o_idAND A.O_TIME >= TRUNC(SYSDATE - 1)AND A.O_TIME < TRUNC(SYSDATE)AND NOT EXISTS (SELECT 1FROM T_B_O_EDB_A OWHERE O.O_ID = A.OAND O.O_TIME >= TRUNC(SYSDATE - 1)AND O.O_TIME < TRUNC(SYSDATE)UNION ALLSELECT b.o_no,a.c_state, 'TK',a.s_remark,a.O_TIME,a.o_id,a.O_NAME,l_name,

12、l_order,ROW_NUMBER() OVER(PARTITION BY a.O_ID ORDER BY a.O_TIME DESC) RNFROM T_B_O_EDB_A A, T_B_ODB_A B,t_b_o_ldb_a cWHERE A.O_ID = B.O_IDAND a.o_id = c.o_idAND 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

13、.p_state = '2'AND a.e_type = '14'UNION ALLSELECT 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) RNFROM T_B_O_EDB_A A, T_B_ODB_A B,t_b_o_ldb_a cWHERE A.O_ID = B.O_IDAND a.o_id = c.o_idAND

14、A.O_TIME >= TRUNC(SYSDATE - 1)AND A.O_TIME < TRUNC(SYSDATE)AND b.c_tag = '1'AND a.e_type = '04'UNION ALLSELECT to_char(P_ID), STATE, DECODE(STATE, '1', 'S', '2', 'ZDTD'), NULL,U_TIME, NULL, NULL, NULL, NULL, 1FROM T_B_B_IDB_A AWHERE STATE IN (

15、9;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 ? 000

16、000000 ?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 ? 000

17、000002 ?10A6EC2C8 ? 0000014B0 ?10C20A000 ? 000000003 ?dbgexProcessError() CALL dbgexPhaseII() 10C3B4650 ?+1248 FFFFFFFF7BE3A578 ?FFFFFFFF7FFF3C28 ?0018E0000 ? 10A6E35B8 ?000001C00 ?dbgePostErrorKGE()+ CALL dbgeExecuteForError 10AE0C3FD ?1320 () FFFFFFFFFEC0B62D ?001050000 ?FFFFFFFF7FFF63D8 ?00106000

18、0 ? 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 ? 0

19、04EA2360 ?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()

20、 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 ?FFFFFFFF

21、7BC67F2C ?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