[工作记录]ORA-03113/ORA-07445

Trace file /opt/oracle/diag/rdbms/business/BUSINESS4/trace/BUSINESS4_ora_1300.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11gR1/db
System name: Linux
Node name: DC-CLUSTER-04
Release: 2.6.16.60-0.21-smp
Version: #1 SMP Tue May 6 12:41:02 UTC 2008
Machine: x86_64
Instance name: BUSINESS4
Redo thread mounted by this instance: 4
Oracle process number: 55
Unix process pid: 1300, image: oracle@DC-CLUSTER-04

*** 2010-06-25 13:23:48.466
*** SESSION ID:(99.2262) 2010-06-25 13:23:48.466
*** CLIENT ID:() 2010-06-25 13:23:48.466
*** SERVICE NAME:(BUSINESS.DMC) 2010-06-25 13:23:48.466
*** MODULE NAME:(PL/SQL Developer) 2010-06-25 13:23:48.466
*** ACTION NAME:(SQL Window - declare reportDate ) 2010-06-25 13:23:48.466

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x160] [PC:0xF5A5C9, kkecdn()+6169]
DDE: Problem Key 'ORA 7445 [kkecdn()+6169]' was flood controlled (0x2) (incident: 24456)
ORA-07445: exception encountered [kkecdn()+6169] [SIGSEGV] [ADDR:0x160] [PC:0xF5A5C9] [Address not mapped to object] []
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL

可以尝试的解决方法
http://dbaspot.com/ora-7445-exception-encountered-core-dump-s-s.html
ORA-07445 : What can cause this error
Bug in Oracle Code
Change in reference libraries [ If you have recently applied OS patches, it may be wise to relink the binaries ]
Code changes in application that causes invalid/null value conditions where a valid value is expected
Software issues like incorrect Libaries due to invalid environment variables primarily related to PATH and LD_LIBRARY_PATH

安装OS补丁后，可以重新链接下库文件。
如果重新启动OS并重新链接过库文件后，问题依然存在，最好去metalink上查下

目前可以重现该问题的语句
declare
reportDate date:=date '2010-6-25';
begin
update dho_character_timer set state=0 where state=1;
commit;
insert into dho_character_timer
select b.collserver,
a.login_username,
a.char_name,
sum(b.playedtime),
reportDate-1,
1
from (select char_index,
account_index,
login_username,
char_name
from business.dho_game_character
where colltime>=reportDate and colltime join (select t.*,
(t.log_out-t.log_in)*24*60*60 as playedtime
from (select collserver,
account_id,
char_id,
log_action,
log_time log_out,
lag(log_time,1)over(partition by account_id,char_id order by log_time) as log_in
from business.dho_log_loginchar
where log_time>=reportDate-2 and log_time where log_action=4 and log_out>=reportDate-1 and log_in is not null)b
on a.account_index=b.account_id and a.char_index=b.char_id
group by b.collserver,a.login_username,a.char_name;
commit;
end;[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23590362/viewspace-1034654/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23590362/viewspace-1034654/