oracle实例进程经常被终止，实例名称是dataexch，到bdump目录下找到alert_dataexch.log，里面内容是
- XML code
Thu Aug 18 09:46:21 2011Thread 1 advanced to log sequence 7963 Current log# 3 seq# 7963 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DATAEXCH\REDO03.LOGThu Aug 18 09:51:59 2011Errors 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] []
- XML code
Dump file e:\oracle\product\10.2.0\admin\dataexch\udump\dataexch_ora_47872.trcThu Aug 18 09:51:59 2011ORACLE V10.2.0.1.0 - Production vsnsta=0vsnsql=14 vsnxtr=3Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsWindows Server 2003 Version V5.2 Service Pack 2CPU : 4 - type 586, 1 Physical CoresProcess Affinity : 0x00000000Memory (Avail/Total): Ph:2786M/4085M, Ph+PgF:4188M/5966M, VA:1135M/2047MInstance name: dataexchRedo thread mounted by this instance: 1Oracle process number: 86Windows 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.296ksedmp: internal or fatal errorORA-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) -------------------- -------- -------------------- ----------------------------
------解决方案--------------------
- C/C++ code
mark
------解决方案--------------------
- SQL code
-- 估计是日志无法归档!-- 这样查看一下：sys@TBWORA> show parameter 'recover';NAME TYPE VALUE------------------------------------ ---------------------- ------------------------------db_recovery_file_dest string D:\oracle\product\10.2.0/flash _recovery_areadb_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.