ORA-07445: exception encountered: core dump

Asked By Nancy Mohammed 0 points N/A Posted on - 07/16/2011

Hi,

The error is: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]

I am getting this error in alert log while trying to open one of our oracle production db running on windows server.

I am able to mount it without any problem but once I try to open it, it just hangs and the smon trace file grows very big 500mb+ until I terminate the session.

I want to know the reasons of this error and how can I solve it?

Thanks.

• Status: Open
• Question Views: 2466
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by superior77

Go To Solution

Best Answer

Best Answer

Answered By superior77 0 points N/A #80399

ORA-07445: exception encountered: core dump

Hi there,

I have read your query and want to share with you that ORA-07445 is a generic error, OS dependent, all the times requires logging a service request (SR) with Oracle Technical support on MOSC.  In general, we can say that "exception" is a un-trapped error, Its same like dividing a number by zero. The error note will be like this

Error: ORA-07445 exception encountered: core dump is an operating system exception error occurrence which is going to be resulting in the creation of a core file and hence therefore is a internal error & to resolve this problem you need to be consulting oracle customer support center online helpdesk.

About superior77

Questions
0

Answers
10

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 07/17/2011
• Question Category: Oracle Database

Answered By Windy Miles 0 points N/A #80401

ORA-07445: exception encountered: core dump

Good day,

Try this one, it might help you:

From the default version, export your feature classes to a personal geo database.

You will then re-import it and version it again. Make sure your settings are correct and add also security privileges.

Download a technical paper from the link to help you convert the data columns:

From the server create this: DISABLE_SPATIAL_CACHE=TRUE, this will then results to a performance hit. Just try one of those, that will really help you.

About Windy Miles

Questions
0

Answers
10

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 07/18/2011
• Question Category: Oracle Database