Sriram Sanka

Databases | Cloud | Infrastructure | Security |

ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []


Today, we were encountered with this internal error on One of our test environment.

On Our Database ,we have 2 temporary table-spaces with a Temporary table space group.
While we are performing Data pump Import (IMPDP) into another machine , The job was failed multiple times with following error on screen ….
Screen Error :

Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name “DW01” prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.

When I verified for the cause, on alert log,  found an Internal error only after Temporary tablespace creation ..

Alert log Content :

CREATE TEMPORARY TABLESPACE “TEMP_TWO” TEMPFILE ‘/u01/app/oracle/oracle/product/10.2.0/oradata/*****/temp02.dbf’SIZE 844103680 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M TABLESPACE GROUP TBS_GROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576

ORA-1119 signalled during CREATE TEMPORARY TABLESPACE “TEMP_TWO” TEMPFILE ‘/u01/app/oracle/oracle/product/10.2.0/oradata/********/temp02.dbf’ SIZE 844103680 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M TABLESPACE GROUP TBS_GROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 …

Sun Feb 17 13:18:26 PST 2013

Thread 1 advanced to log sequence 47 (LGWR switch)

Current log# 2 seq# 47 mem# 0: /u01/app/oracle/*****/*****/redo02.log

Sun Feb 17 13:18:32 PST 2013
Errors in file /u01/app/oracle/******/admin/******/bdump/*****_dw01_24538.trc:

ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []

Creating the temp tablespaces manually before IMPDP process will avoid such errors.

For More info please read metalink document ID 1259393.1

Published by

Sriram Sanka
Hi there, This is SCP Ranga Rao Sanka working as (A product Manager/Principal DBA)., I have a broad range of Experience in Administration and Implementation in the areas of Database, Cloud, and Other Servers. I am one of the moderators at ORAFAQ. The primary purpose of this blog is to share knowledge. All the code snippets, URLs, and everything in this blog are from My experience, My Learnings from different websites & forums. so please test the posts on your testing Environment first. The experiences, Test cases, views, and opinions, etc., expressed on this website are my own and do not reflect the views or opinions of my employer. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content. Product and company names mentioned on this website may be the trademarks of their respective owners. I am not responsible for any kind of Damage or any legal activities.

2 responses to “ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []”

  1. Rochell Avatar
    Rochell

    WOW just what I was looking for. Came here by searching
    for Rude magic video “Rude”

    Like

    Reply
  2. helpful site

    Effective for Uncertain Conditions

    I really like your writing style, excellent info, thank you for putting up :D.

    Like

    Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.