- 浏览: 696099 次
- 性别:
- 来自: 福建
文章分类
最新评论
-
羽翼的心动:
同意2楼的说法,我们公司之前一个项目用过pageoffice, ...
poi导出excel文件工具类 -
贝塔ZQ:
poi实现导出excel文件,蛮麻烦的,用pageoffice ...
poi导出excel文件工具类 -
aishiqiang:
为什么我的项目配置好证书后,每次使用jenkinst自动构建包 ...
关于使用https协议,cas认证PKIX path building failed错误解决方法 -
zhongmin2012:
谢谢分享,正在想看
AST解析java源文件相关jar包 -
mybestroy1108:
感谢分享!受益良多!
Jboss7 JMS demo
前些天数据库服务器出现了一下错误:
SQL*Loader-961: 对表 table1 调用一次/加载完成时出错
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [8], [565129], [18021], [], [], [], []
SQL*Loader-2026: 加载因 SQL 加载程序无法继续而被终止
关于ORA-00600错误描述:
关于ORA-00607错误描述:
参考了网上的一些资料,通过以下操作解决ORA-00600和ORA-00607错误:
参考资料:
http://blog.sina.com.cn/s/blog_487f7b730100ovoh.html
http://blog.chinaunix.net/uid-23249684-id-3208290.html
SQL*Loader-961: 对表 table1 调用一次/加载完成时出错
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [8], [565129], [18021], [], [], [], []
SQL*Loader-2026: 加载因 SQL 加载程序无法继续而被终止
关于ORA-00600错误描述:
引用
ORA-00600: internal error code, arguments: [string], [string], [string], [string], [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. The first argument is the internal message number. This argument and the database version number are critical in identifying the root cause and the potential impact to your system.
Action: Visit My Oracle Support to access the ORA-00600 Lookup tool (reference Note 600.1) for more information regarding the specific ORA-00600 error encountered. An Incident has been created for this error in the Automatic Diagnostic Repository (ADR). When logging a service request, use the Incident Packaging Service (IPS) from the Support Workbench or the ADR Command Interpreter (ADRCI) to automatically package the relevant trace information (reference My Oracle Support Note 411.1). The following information should also be gathered to help determine the root cause:
- changes leading up to the error
- events or unusual circumstances leading up to the error
- operations attempted prior to the error
- conditions of the operating system and databases at the time of the error Note: 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.
Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. The first argument is the internal message number. This argument and the database version number are critical in identifying the root cause and the potential impact to your system.
Action: Visit My Oracle Support to access the ORA-00600 Lookup tool (reference Note 600.1) for more information regarding the specific ORA-00600 error encountered. An Incident has been created for this error in the Automatic Diagnostic Repository (ADR). When logging a service request, use the Incident Packaging Service (IPS) from the Support Workbench or the ADR Command Interpreter (ADRCI) to automatically package the relevant trace information (reference My Oracle Support Note 411.1). The following information should also be gathered to help determine the root cause:
- changes leading up to the error
- events or unusual circumstances leading up to the error
- operations attempted prior to the error
- conditions of the operating system and databases at the time of the error Note: 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.
关于ORA-00607错误描述:
引用
ORA-00607: Internal error occurred while making a change to a data block
Cause: An internal error or memory exception occurred while Oracle was applying redo to a data block.
Action: call Oracle Support
Cause: An internal error or memory exception occurred while Oracle was applying redo to a data block.
Action: call Oracle Support
参考了网上的一些资料,通过以下操作解决ORA-00600和ORA-00607错误:
sqlplus /nolog conn / as sysdba; #查看undo的表空间管理方式应该是auto show parameter undo; #修改undo的表空间管理方式为manual alter system set undo_management=manual scope=spfile; shutdown immediate; startup; #创建undo临时表空间 create undo tablespace undo2 datafile '/opt/oradata/tgt/undo2.dbf' size 200M; #修改undo表空间为undo2 alter system set undo_tablespace=undo2 scope=spfile; #将undo表空间管理模式修改为auto alter system set undo_management=auto scope=spfile; shutdown immediate; startup; 执行完以上操作后为发现ORA-00600错误,说明重建表空间问题解决,接下来将undo表空间改回undotbs1 drop tablespace undotbs1 including contents and datafiles; create undo tablespace undotbs1 datafile '/opt/oradata/tgt/undotbs1.dbf' size 500M; alter system set undo_management=manual scope=spfile; shutdown immediate; startup; alter system set undo_tablespace=undotbs1 scope=spfile; alter system set undo_management=auto scope=spfile; shutdown immediate; startup; #删除刚刚临时重建的undo2表空间 drop tablespace undo2 including contents and datafiles;
大致确定是由于块当中存在逻辑讹误导致的这个错误 {当Oracle进程在读取数据块时会做一系列逻辑检测,当发现块当中存在逻辑讹误就会触发该ORA-00600 [kddummy_blkchk]等内部错误;[kddummy_blkchk]内部函数 的功能大致与[kdBlkCheckError]相仿,它们都有3个参数argument: ORA-600 [kddummy_blkchk] [file#] [block#] [check code] ORA-600 [kdBlkCheckError] [file#] [block#] [check code] file#即问题块所在datafile的文件号,block#即问题块的块号,check code为发现逻辑讹误时的检测种类代码 } 我们也可以通过file#和block#查找到存在问题的对象:譬如这个case中的file#为121,block#为2275853,检查种类代码为18021: SELECT tablespace_name,segment_type,owner,segment_name FROM dba_extents WHERE file_id = 8 AND 565129 between block_id AND block_id+blocks-1; 查询结果如: TABLESPACE_NAME SEGMENT_TYPE OWNER SEGMENT_NAME ------------------------------ ------------------ ------------------------------ DATA01 TABLE USER1 TABLE1 该查询结果中的表需要重建,问题解决。
参考资料:
http://blog.sina.com.cn/s/blog_487f7b730100ovoh.html
http://blog.chinaunix.net/uid-23249684-id-3208290.html
发表评论
-
snaker工作流: java.lang.NoClassDefFoundError: de/odysseus/el/util/SimpleContext
2015-02-09 22:30 4272java.lang.NoClassDefFoundError: ... -
ClassCastException:DefaultAnnotationProcessor cannot be cast to AnnotationProce
2014-08-06 14:56 0java.lang.ClassCastException:o ... -
Mysql安装及主从备份配置方案操作说明
2014-07-04 16:49 1583Mysql安装及主从备份配置方案操作说明 ... -
win8 无法显示桌面,运行explorer.exe 提示 0xc0000018 错误 解决方法
2014-05-08 10:03 16795改注册表.这个就是DB03.EXE引起的. cmd打开注册表 ... -
linux 定时任务检查服务器是否正常
2014-02-28 22:21 4640通过curl命令判断url返回状态,以此来确定服务是否正常: ... -
tomcat server.xml设置Context指定webapp访问路径引起的context.xml无效
2014-02-12 10:57 4268通过tomcat的server.xml设置来部 ... -
根据国家统计局发布的“最新县及县以上行政区划代码”生成省地市区字典表
2012-06-12 10:27 5241国家统计局网站 表结构: 附件为根据国家统计局公布的最新 ... -
执行sh脚本错误:/bin/sh^M: bad interpreter: 没有那个文件或目录
2012-12-22 22:50 1815今天执行脚本时发现如下错误: /bin/sh^M: bad i ... -
设置iframe的高度
2012-03-29 10:55 10587为了使iframe不出现滚动条(使用浏览器自身的滚动条),需要 ... -
open flash chart #2032 :about ssl with IE
2011-11-16 09:43 1742这两天处理了个比较棘手的问题,IE浏览器下(IE7 ... -
jstl 使用与web.xml的版本关系
2011-11-02 12:52 2135不同web.xml文件对jstl引用的影响,若web.xml( ... -
svn+apache配置
2011-07-23 22:18 1810已安装apache服务器和svn。 接下来配置apache服务 ... -
win7下的诡异:登入plsql失败提示空消息
2011-04-13 09:26 1867登入plsql失败,并提示空消息,这个问题很诡 ... -
spring远程调用ejb3异常
2010-08-25 14:48 36002010-08-25 14:51:46 46 [org.jbo ... -
去掉iframe横向滚动条或竖条
2010-08-18 17:26 0主页面加IFRAME SCROLLING="YES& ... -
oracle update\insert 获得响应记录数
2010-07-22 15:24 2476DECLARE BEGIN update tablenam ... -
org.apache.jasper.JasperException
2010-03-22 15:21 5513org.apache.jasper.JasperExcepti ... -
如何避免超链接在点选时产生的“虚线外框”呢?
2012-12-22 22:53 1296如何避免超链接在点选时产生的“虚线外框”呢? 有很多办法实现。 ... -
路由器和猫
2009-11-20 13:37 0路由器是什么,路由器就是将一条宽带线分多条的工具,猫就 ... -
hibernate 大批量获取数据错误
2009-11-20 10:05 02009-11-20 04:35:53 53 [org.hib ...
相关推荐
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
ORACLE ORA-00132 ORA-00214
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...
oracle数据库ora-01152和ora-01110的解决办法
kettle连接oracle12C--报错ORA-28040 没有匹配的验证协议
ORA-00600 [16703].docx
oracle ORA-01033问题怎么解决 !! 能修复文件出错问题
oracle启动失败,ORA-00702报错,windows,linux系统下解决办法
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
Oracle_ORA-12518故障_处理,希望在此与大家分享,能够在实际的工作中提高解决问题的能力
oracle ORA-01033报错分析和解决方案跟踪文档
ora-03113错误
用oracle数据库新建连接时遇到ora-12505,此问题解决后又出现ora-12519错误,郁闷的半天,经过一番折腾问题解决,下面小编把我的两种解决方案分享给大家,仅供参考。 解决方案一: 今天工作时在新建连接的时候遇到...
ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
oracle网络配置(listener_ora-sqlnet_ora-tnsnames_ora).mht
ERwin连接oracle报ORA-01041内部错误,hostdef扩展名不存在解决办法,实验可解决问题。
win 8 升级 win 10 后,oracle 11g 无法启动及客户端连接,命令行sqlplus登录,startup 时报 ORA-00119 和 ORA-00132 的错误。 1. sqlplus /nolog 2. conn / as sysdba 3. startup 报错: ORA-00119 和 ORA-00132
关于WIN10系统使用oracle instant client 时候提示ORA-01019错误的解决方案,本方案是配置好环境变量后依然提示ORA-01019错误的解决方案,内附本人制作测试的全过程说明
每一个DBA在进行数据库管理的过程中不可避免的要遇到形形色色的错误(ORA- 1547 ,ORA-904,ORA-1578 ......)。有些错误由于频繁出现、原因复杂而被 Oracle DBA 们戏称之为\\\\\\\"经典的错误\\\\\\\"。其中ORA-3113 \\...