Oracle出现异常，报：ORA-07445: 出现异常错误: 核心转储

[paodan]

oracle实例进程经常被终止，实例名称是dataexch，到bdump目录下找到alert_dataexch.log，里面内容是

Thu Aug 18 09:46:21 2011
Thread 1 advanced to log sequence 7963
  Current log# 3 seq# 7963 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DATAEXCH\REDO03.LOG
Thu Aug 18 09:51:59 2011
Errors in file e:\oracle\product\10.2.0\admin\dataexch\udump\dataexch_ora_47872.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_qerhjWalkHashBucket+103] [PC:0x174C497] [ADDR:0xE58] [UNABLE_TO_READ] []

，找到e:\oracle\product\10.2.0\admin\dataexch\udump\dataexch_ora_47872.trc文件，打开内容如下：

Dump file e:\oracle\product\10.2.0\admin\dataexch\udump\dataexch_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: 出现异常错误: 核心转储，大家看一下是什么原因。

[paodan]

顶，期待高手啊

[凌梦轩]

mark

[paodan]

没人啊

[paodan]

自己顶一下

[luoyoumou]

-- 估计是日志无法归档!

-- 这样查看一下：

sys@TBWORA> show parameter 'recover';

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest                string                 D:\oracle\product\10.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.

[paodan]

是表空间占满了，查看表空间的使用率，
SELECT a.tablespace_name "表空间名",total 表空间大小,free 表空间剩余大小,
(total-free) 表空间使用大小,
ROUND((total-free)/total,4)*100 "使用率 %"
FROM (SELECT tablespace_name,SUM(bytes) free FROM DBA_FREE_SPACE
GROUP BY tablespace_name ) a,
(SELECT tablespace_name,SUM(bytes) total FROM DBA_DATA_FILES
GROUP BY tablespace_name) b
WHERE a.tablespace_name=b.tablespace_name
表空间占用99.7%，增大表空间后解决。
另：该服务器上有瑞星杀毒软件，禁用杀毒软件。

[huangshy85]

我也遇到同样的问题，但是我的表空间并没有满。
Alter log如下：
Thu Dec 08 14:39:09 2011
Errors in file t:\oracle\bdump\xxxdb_j001_1024.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kpnfch+224] [PC:0xF986B4] [ADDR:0x84] [UNABLE_TO_READ] []

help me.....