Sunday, October 23, 2011

Getting ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] when running Gather DB Statistics

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:


Problem Description: Getting ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] when running Gather DB Statistics


Errors in file /orasys/admin/udump/addev_ora_730.trc:
ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] [Address not mapped to object]
[0x000000040] [] []



Stack Trace: drurnew draccbi drexumcx drexostatscoll spefcpfa spefmccallstd peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main start


Explanation:


Bug 5587976


Solution:




the core dump while gathering statistics is caused by one of your interim patches (see also the ORA-60 errors) applied and is fixed by patch 5160122, available as one-off on top of 10.2.0.4.
To resolve the problem execute below action plan:

1. upgrade to 10.2.0.5, apply patch 8202632, since 10.2.0.5 includes the fix for bug 5160122
or
2. upgrade to 10.2.0.4, apply patch 6810189 and on top of 10.2.0.4 apply one-off patch 5160122


3.
Patch is available for solaris on 10.2.0.3.
Download and apply the patch for bug 5587976



please relink the oracle executable and check whether this
fixes the problem.

-- Be sure to shutdown all databases and listeners in this $ORACLE_HOME
-- Then as software owner relink:

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ioracle

For more information on this please see:

Note 131321.1 : How to Relink Oracle Database Software on UNIX

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: