ORA-07445: Exception found: Memory Dump

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
User avatar
madmax
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 293
Joined: Wed, 13 Dec 2006 5:02 pm
Location: São Paulo
Contact:
________________________________
Douglas - Madmax.

Environment Information: Windows
* Oracle version: 10g
* Operating system: Windows

Dear colleagues

99] I have a bank that is giving this error in the alert

Select all

ORA-07445: exceção encontrada: dump de memória
and is generating several .TrC does anyone know that bug ray and this and how can I solve?

Thanks.
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

Select all

 
 
    Error: ORA-07445 exception encountered: core dump 
    Cause : An operating system exception occurred which should result in the creation of a core file. This is an internal error. 
    Action : Contact Oracle Customer Support. 
 
Common precipitators of the ORA-07445 include: 
 
    * High volume user transactions  
    * Software bugs (i.e. Bug 4098853).  See note 342443.1 on MOSC. 
    * Too-small RAM regions (shared_pool_size, java pool, large_pool_size), and a too-small application memory stack (e.g. PL/SQL array too small)        
    * Too small undo and temp segments       
    * Program errors (addressing outside of RAM region), e.g. S0C4.       
    * Improper NLS parameter settings        
    * Hardware errors       
    * Oracle block corruption 
 
      and a host of other related issues.  
 
Oracle DBA's use alert mechanisms to send an e-mail to the DBA when ORA-07445 errors occur, e-mailing the associated core dump file.  MOSC now offers an ORA-7445 search tool, as described in MOSC note Note:208922.1, and you can supply details from the Oracle trace file to see the exact cause.  
 
Other common causes of the ORA-07445 include: 
 
    * High-volume, high RAM usage can cause ORA-07445        
    * The shared pool is too small to hold the fixed structures        
    * Improper SCSI disk configuration 
 
In sum, the ORA-07445 has a multitude of causes and contact with Oracle technical support is always required. 
[url=http://www.dba-oracle.com/t_ora_07445_e ... ntered.htm]fonte
User avatar
madmax
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 293
Joined: Wed, 13 Dec 2006 5:02 pm
Location: São Paulo
Contact:
________________________________
Douglas - Madmax.

Hello Victor.

From what I understand this error and good, the ideal and enter with Oracle's support to solve?

or have a cake recipe for this?

Thanks.
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

So friend ..

of a [url=http://stephensorablog.blogspot.com/200 ... error.html]googada before ..


now tighten too much .. Boot Metalink in action soon .. is paying not? Hahaha
diegopedrao
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 164
Joined: Fri, 22 Aug 2008 12:28 pm
Location: SP

cara checks the Alert of OS, can also tell you something.

What speaks in .TrC files?

ATT,

Diego Monteiro
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest