ORA-00600 internal error code, arguments: [num], [?], [?], [?], [?], [?] Cause: This is a catchall internal error message for Oracle program exceptions. It indicates that a process has met a low-level, unexpected condition. Various causes of this message include: time-outs
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 the Oracle Server. Action: Report this error to customer support 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 database at the time ofthe error
any unusual circumstances that occurred before receiving theORA-00600 message
contents of any trace files generated by the error
the relevant portions of the Alert fileNote: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
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 the Oracle Server. Action: Report this error to customer support 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 database at the time ofthe error
any unusual circumstances that occurred before receiving theORA-00600 message
contents of any trace files generated by the error
the relevant portions of the Alert fileNote: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
解决方案 »
- PL/sql 里对日期字段2012-2-3 这样的怎样查询出只显示年份的?因为有好多不同年份的
- 如何查看oracle表空间建立时的语句?
- 关于Oracle存储过程的SQL语句拼接符
- 问一个sql语句如何写?
- 无聊,没事做散分。5:30结贴
- 进不了SQL PLUS了
- 大批量导入数据出现的问题,请指教哦!
- 启动oracle 时,出现ora-01033错误,oracle initialization or shutdown in progress 错误;再用sqlplus 连接时,输入用户名和密码,出现
- oracle时间加减的函数??
- 隐式游标的问题?
- 能否把Oracle中建立的表结构转到Powerdesigner中去呢
- 初级问题,每月执行次,请高高手指点
产生原因:这种错误通常为ORACLE的内部错误,只对OSS和ORACLE开发有用。ORA-600的错误经常伴随跟踪文件的状态转储(系统状态和进程状态),系统状态存储将包括ORACLE RDBMS持有的当前对象的信息,进程状态转储则将显示特殊进程持有的对象,当进程符合了某错误条件时,经常是由于一些信息取自它持有的一个块,如果我们知道这些错误进程持有的块,就容易跟踪问题的来源。 解决方法:一般来说出现这个错误我们本身是无法解决的,只有从提高系统本身各方面来解决这个内部问题,如增加硬件设备,调整系统性能,使用OPS(当然OPS从某种意义上说并不是一种好的解决方式)等。ORA-600错误的第一个变量用于标记代码中错误的位置(代码中的每个部分的第一变量都不一样),从第二个到第五个变量显示附加信息,告诉OSS代码在哪里出现了错误。 一个报错例子如下: ORA-00600: internal error code, arguments: [1237], [], [], [], [], [], [], [] 相应的英文如下: Cause:This is a catchall internal error message for Oracle program exceptions.It indicates that a process has met a low-level,unexpected condition.Various causes of this message include: Time-outs(超时) File corruption(文件太老) Failed data checks in memory(内存检索失败) Hardware,memory,or I/O errors(硬件、内存或者磁盘错误) Incorrectly restored files(错误的重建文件)
ORA-03113:end-of-file on communication channel 产生原因:通讯不正常结束,从而导致通讯通道终止 解决方法:1>.检查是否有服进程不正常死机,可从alert.log得知 2>.检查sql*Net Driver是否连接到ORACLE可执行程序 3>.检查服务器网络是否正常,如网络不通或不稳定等 4>.检查同一个网上是否有两个同样名字的节点 5>.检查同一个网上是否有重复的IP地址