Ora-00600 Internal Error Code Arguments 4042
Contents |
比特币 小额贷款 贷款 crm ORACLE 项目管理系统 thread android python java 本版文章帖子用户 ITPUB论坛-中国最专业的IT技术社区»论坛 › ≡ 大数据与数据库 ≡ › Oracle数据库管理 › ORA-00600: internal error code, arguments: [4042], [ ... 细数 “分布式计算系统”令你不爽的那些瞬间! oracle技术交流群,欢迎大家加入! 你知道吗?对数据中心的了解可以拿到精美大奖! 12 / 2 页下一页 返回列表 查看: 4468|回复: 19 收藏 | [性能调整] ORA-00600: ora 600 error oracle 11g internal error code, arguments: [4042], [136] [复制链接] microsoft_fly microsoft_fly 当前离线 积分101 IP卡 狗仔卡
Ora-600 Lookup Tool
论坛徽章:25 电梯直达 1# 发表于 2008-11-20 09:17 | 只看该作者 |倒序浏览 |阅读模式 linux as 4 oracle 9.2.0.4.0 SQL> create table scott.test(tid varchar2(10)); create
Ora 00600 Internal Error Code Arguments Rwoirw Check Ret Val
table scott.test(tid varchar2(10)) * ERROR at line 1: ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], [] 创建任何对象都出错! 部分跟踪日志: *** SESSION ID75.19119) 2008-11-19 11:14:02.090 *** 2008-11-19 11:14:02.090 ksedmp: internal
Ora-00600 Internal Error Code Solution
or fatal error ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], [] Current SQL statement for this session: insert into col$(obj#,name,intcol#,segcol#,type#,length,precision#,scale,null$,offset,fixedstorage,segcollength,deflength,default$,col#,property,charsetid,charsetform,spare1,spare2,spare3)values(:1,:2,:3,:4,:5,:6,decode(:7,0,null,:7),decode(:5,2,decode(:8,-127/*MAXSB1MINAL*/,null,:8),178,:8,179,:8,180,:8,181,:8,182,:8,183,:8,231,:8,null),:9,0,:10,:11,decode(:12,0,null,:12),:13,:14,:15,:16,:17,:18,:19,:20) ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ora 00600 internal error code arguments 4194 ---------------------------- ksedmp()+269 call ksedst()+0 0 ? 0 ? 0 ? 0 ? BFFF6A6C ? A16D886 ? ksfdmp()+14 call ksedmp()+0 3 ? BFFF6B78 ? 98585B4 ? AD58FA0 ? 3 ? A4B929C ? kgeriv()+188 call ksfdmp()+0 AD58FA0 ? 3 ? kgeasi()+108 call kgeriv()+0 AD58FA0 ? ADB286C ? FCA ? 1 ? BFFF6BB4 ? ktugusc()+787 call kgeasi()+0 AD58FA0 ? ADB286C ? FCA ? 2 ? 1 ? 4 ? 88 ? ktugti()+359 call ktugusc()+0 BFFF6C1C ? 12 ? 1 ? 0 ? 0 ? 0 ? 0 ? 0 ? ktsftcmove()+430 call kt
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB ora 00600 internal error code arguments kdsgrp1 Don Burleson Blog
ora-00600 internal error code arguments kcratr_nab_less_than_odr ORA-00600: internal error code, arguments string tips Oracle Error Tips by Stephanie F. oracle mosc The Oracle docs note this on the ORA-00600 error: Error: ORA 00600 Text: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s] ------------------------------------------------------------------------------- Cause: This is the generic http://www.itpub.net/thread-1089177-1-1.html internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. Action: Report as a bug - the first argument is the internal error number On the Oracle DBA Forums, a user needs help with ORA-00600, as well as understanding the accompanying arguments. The replier informed the user that because ORA-00600 is an internal error, http://www.dba-oracle.com/t_ora_00600_internal_error_code_arguments_string_%20string_string_string_string_string_string.htm the Oracle Corporation knows the arguments. Here are the notes which helped the user resolve ORA-00600: An ORA-00600 is an internal error, and only Oracle Corporation knows the agruments. ALWAYS open a TAR when you get a ora-600. I check MOSC, and you can see many of the "common" codes there. ****************************************** ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: timeouts file corruption failed data checks in memory hardware, memory, or I/O errors incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Support Services after gathering the following information: events that led up to the error the operations that were attempted that led to the error the conditions of the operating system and databases at the time of the error an[4146] while opening Database If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before http://www.dbasupport.com/forums/showthread.php?33007-ORA-00600-4146-while-opening-Database you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: ORA-00600 [4146] while opening Database Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-14-2003,10:26 internal error AM #1 xav View Profile View Forum Posts Junior Member Join Date Jan 2003 Location France Posts 5 ORA-00600 [4146] while opening Database Hello, We have these messages when we start our DB : PMON started DBWR started LGWR started Tue Jan 14 14:22:21 2003 alter database mount exclusive Successful mount of redo thread 1. Tue Jan 14 14:22:21 2003 Completed: alter database internal error code mount exclusive Tue Jan 14 14:22:21 2003 alter database open Beginning crash recovery of 1 threads Crash recovery completed successfully Tue Jan 14 14:22:23 2003 Thread 1 advanced to log sequence 214 Current log# 1 seq# 214 mem# 0: /ora733/oracle/adminoralog/log1ADMIN.dbf Thread 1 opened at log sequence 214 Current log# 1 seq# 214 mem# 0: /ora733/oracle/adminoralog/log1ADMIN.dbf Successful open of redo thread 1. Tue Jan 14 14:22:23 2003 SMON: enabling cache recovery SMON: enabling tx recovery Tue Jan 14 14:22:24 2003 Completed: alter database open Tue Jan 14 14:22:24 2003 Errors in file /ora733/oracle/adminoralog/rdbms/smon_28778.trc: ORA-00600: internal error code, arguments: [4146], [41], [38], [], [], [], [], [] We tried to suppress the rollback_segs from init.ora without effect. We tried to use _corrupted_rollback_segments without effect. Can you help us ? XD Reply With Quote 01-14-2003,10:43 AM #2 pando View Profile View Forum Posts Pando & Company Join Date Jun 2000 Location Madrid, Spain Posts 7,447 when you have corrupted rollback segment you best bet is call support because depending on situation the way of solving is different to start with I would make a cold backup of your current database Repl