Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

3

主题
1#
发表于 2013-12-17 15:17:46 | 查看: 5243| 回复: 2
生产系统不定期的出现下面这个错误,虽然不是经常出现,但只要一出现,必定是core dump [kpnfch()+207] ,所以总感觉哪里有问题,尤其每次都是[kpnfch()+207,这不得不让人怀疑,但是打开incident文件以及detail文件,一大堆的dump文件完全不知道要怎么读?可否有大神给点提示或方法?如何读懂Oracle Dump File?谢谢。

PS:附件无法上传
附件上传完成!成功 0 个,失败 1 个:
tracefile.zip: 内部服务器错误

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x70] [PC:0x6B6A537, kpnfch()+207] [flags: 0x0, count: 1] Errors in file /u01/app/oracle/diag/rdbms/shpndbetl/shpndbetl0/trace/shpndbetl0_ora_17953.trc  (incident=16977):
ORA-07445: exception encountered: core dump [kpnfch()+207] [SIGSEGV] [ADDR:0x70] [PC:0x6B6A537] [Address not mapped to object] [] Incident details in: /u01/app/oracle/diag/rdbms/shpndbetl/shpndbetl0/incident/incdir_16977/shpndbetl0_ora_17953_i16977.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/shpndbetl/shpndbetl0/incident/incdir_16977/shpndbetl0_ora_17953_i16977.trc:
ORA-03113: end-of-file on communication channel
ORA-07445: exception encountered: core dump [kpnfch()+207] [SIGSEGV] [ADDR:0x70] [PC:0x6B6A537] [Address not mapped to object] [] Errors in file /u01/app/oracle/diag/rdbms/shpndbetl/shpndbetl0/incident/incdir_16977/shpndbetl0_ora_17953_i16977.trc:
ORA-03113: end-of-file on communication channel
ORA-07445: exception encountered: core dump [kpnfch()+207] [SIGSEGV] [ADDR:0x70] [PC:0x6B6A537] [Address not mapped to object] []
2#
发表于 2013-12-17 15:40:47
你的帖子甚至没有版本信息

回复 只看该作者 道具 举报

3#
发表于 2013-12-17 16:37:25
Liu Maclean(刘相兵 发表于 2013-12-17 15:40
你的帖子甚至没有版本信息

Sorry刘大,现补上。

DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
SHPNDBET      4128421739 shpndbetl0          1 11.2.0.2.0  NO  shpn0e101

CPUs           SGA Size       Buffer Cache        Shared Pool    ASH Buffer Size
---- ------------------ ------------------ ------------------ ------------------
  64     97,865M (100%)    36,864M (37.7%)      2,048M (2.1%)      102.4M (0.1%)

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-19 11:59 , Processed in 0.047177 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569