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] []

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)     
-------------------- -------- -------------------- ----------------------------

mark

------解决方案--------------------

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

-- 这样查看一下：

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 represe