ORA-600(qerrmOStart2)错误.doc

ORA-600(qerrmOStart2)错误 客户 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/rdbms/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 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.trcUse 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 2012Sweep [inc][194913]: completedSweep [inc][194914]: completedSweep [inc2][194913]: completed 虽然这个操作在MOS没有相关描述，但是根据错误信息分析，这个ORA-600只是标识作用，真正的错误是随后参数中的ORA-1740错误。而这个错误信息更像是一个语句分析的错误。 $ more /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trcDump file /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trcOracle Database 11g Enterprise Edition Release .0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsORACLE_HOME = /oracle/product/11.2.0/dbhome_1System name: SunOSNode name: orcl2Release: 5.10Version: Generic_147440