专注收集记录技术开发学习笔记、技术难点、解决方案
网站信息搜索 >> 请输入关键词:
您当前的位置: 首页 > Oracle技术

Oracle出现错误,报:ORA-07445: 出现错误错误: 核心转储

发布时间:2010-05-20 14:01:29 文章来源:www.iduyao.cn 采编人员:星星草
Oracle出现异常,报:ORA-07445: 出现异常错误: 核心转储
oracle实例进程经常被终止,实例名称是dataexch,到bdump目录下找到alert_dataexch.log,里面内容是
XML code

Thu Aug 18 09:46:21 2011
Thread 1 advanced to log sequence 7963
  Current log# 3 seq# 7963 mem# 0: E:ORACLEPRODUCT10.2.0ORADATADATAEXCHREDO03.LOG
Thu Aug 18 09:51:59 2011
Errors in file e:oracleproduct10.2.0admindataexchudumpdataexch_ora_47872.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_qerhjWalkHashBucket+103] [PC:0x174C497] [ADDR:0xE58] [UNABLE_TO_READ] []


,找到e:oracleproduct10.2.0admindataexchudumpdataexch_ora_47872.trc文件,打开内容如下:
XML code

Dump file e:oracleproduct10.2.0admindataexchudumpdataexch_ora_47872.trc
Thu Aug 18 09:51:59 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU                 : 4 - type 586, 1 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:2786M/4085M, Ph+PgF:4188M/5966M, VA:1135M/2047M
Instance name: dataexch

Redo thread mounted by this instance: 1

Oracle process number: 86

Windows thread id: 47872, image: ORACLE.EXE (SHAD)


*** SERVICE NAME:(SYS$USERS) 2011-08-18 09:51:59.296
*** SESSION ID:(46.6525) 2011-08-18 09:51:59.296
*** 2011-08-18 09:51:59.296
ksedmp: internal or fatal error
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_qerhjWalkHashBucket+103] [PC:0x174C497] [ADDR:0xE58] [UNABLE_TO_READ] []
Current SQL statement for this session:
select d.tablespace_name,d.space total,d.realspace - nvl(f.free_space, 0) used  from (select tablespace_name,round(sum(decode(maxbytes, 0, bytes, maxbytes)) / (1024 * 1024), 2) space , round(sum(bytes) / (1024 * 1024), 2) realspace  from sys.dba_data_files group by tablespace_name) d, (select tablespace_name,round(sum(bytes) / (1024 * 1024), 2) free_space  from sys.dba_free_space group by tablespace_name) f  where d.tablespace_name = f.tablespace_name(+) and d.tablespace_name in (select tablespace_name from sys.user_ts_quotas)
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------

报ORA-07445: 出现异常错误: 核心转储,大家看一下是什么原因。

------解决方案--------------------
C/C++ code
mark

------解决方案--------------------
SQL code
-- 估计是日志无法归档!

-- 这样查看一下:

sys@TBWORA> show parameter 'recover';

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest                string                 D:oracleproduct10.2.0/flash
                                                            _recovery_area
db_recovery_file_dest_size           big integer            2G


-- 查看到上面的db_recovery_file_dest目录和 db_recovery_file_dest_size  大小,
-- 先去看一下  D 盘( db_recovery_file_dest 所在的盘符)还有多少可用空间,如果很多的话,可以将
db_recovery_file_dest_size 参数设置大一点:

-- 例如:

sys@TBWORA> alter system set db_recovery_file_dest_size=10G scope=both;

系统已更改。

-- 再重启一下(也许不需要重启),应该不会报错啦!

------解决方案--------------------
ORA-07445: exception encountered: core dump [string] [string] [string] [string] [string] [string] 
Cause: An OS exception occurred which should result in the creation of a core file. This is an internal error.
Action: Contact your customer support representative.
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。

其他相似内容:

热门推荐: