ORA-07445 Error Resolution

Today found a pair of core files in the Cdump directory in the database.

View alert log found all the

  
..... Wed Oct 09:58:51  
Restarting dead background process CJQ0 Wed Oct-09:58:52 CJQ0 with  
pi d=43, OS id=5247   
Exception [TYPE:SIGSEGV, Address not mapped to object] [addr:0x130000001e] [Pc:0x6e678e4, Kslgetl () + Errors in  
file/home/oracle/diag/rdbms/orarpt/orarpt/trace/orarpt_cjq0_5247.trc  (incident=276255):  
ora-07445:exception Encountered:core Dump [Kslgetl () +40] [SIGSEGV] [addr:0x130000001e] [pc:0x6e678e4] [address Not mapped to object] []  
Wed Oct 09:58:59  
Sweep incident[276255]: Completed

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Then look at the corresponding trace file

Oracle@linux-35:~/diag/rdbms/orarpt/orarpt/trace> More/home/oracle/diag/rdbms/orarpt/orarpt/trace/orarpt_ CJQ0_5247.TRC Trace file/home/oracle/diag/rdbms/orarpt/orarpt/trace/orarpt_cjq0_5247.trc Oracle Database 11g ENTERPR Ise Edition release 11.1.0.6.0-64bit Production with the partitioning option Oracle_home =/home/oracle/product/11.1.0 /db_1 System name:linux Node name:linux-35 release:2.6.16.21-0.8-smp Version: #1 SMP Mon June 3 18:25:39 UTC 2006 machine:x86_64 Instance name:orarpt Redo thread mounted by this instance:1 Oracl E process number:43 Unix process pid:5247, image:oracle@linux-35 (CJQ0) * * * 2011-10-12 09:58:55.533 * * SES SION ID: (1197.56623) 2011-10-12 09:58:55.533 CLIENT ID: () 2011-10-12 09:58:55.533 * * * SERVICE NAME: (sys$background  
       
2011-10-12 09:58:55.533 * * * * MODULE Name: () 2011-10-12 09:58:55.533 ACTION Name: () 2011-10-12 09:58:55.533 Exception [TYPE:SIGSEGV, Address Not mapped to object] [addr:0x130000001e] [Pc:0x6e678e4, Exception [TYPE:SIGSEGV, Address not map ped to object] [ADDR : 0x130000001e] [Pc:0x6e678e4, Kslgetl () +40] Dde:problem Key ' ORA 7445 [Kslgetl () +40] ' was flood controlled (0x6) (incid ent:276255) ora-07445:exception Encountered:core dump [Kslgetl () +40] [SIGSEGV] [addr:0x130000001e] [pc:0x6e678e4] [Ad  
Dress not mapped to objec T] [] ssexhd:crashing the process ... Background_core_dump = PARTIAL

The feeling should be a problem with the job process, and colleagues also reflect that starting from number 11th job is not working properly.

The Internet to check the data, also did not find the relevant reasons, most of them are Oracle bugs. But only to restart the database to try, reboot after the discovery of the job process is normal, all jobs can be performed normally.

The specific reason is unknown, first here to make a record, follow-up have relevant answers to write.

This article is from "Richard's notes-accumulate micro Cheng" blog, please be sure to keep this source http://zxf261.blog.51cto.com/701797/722310