Home » RDBMS Server » Server Administration » An Unhandled Exception Occurred
An Unhandled Exception Occurred [message #258426] Sat, 11 August 2007 22:13 Go to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

I have a doubt.
I was browsing my oracle files... and at location:
C:\oracle\product\10.2.0\db_1\database


I found several files with names like this "core_cm3_pid_2916_tid_xE44_2007_8_11_3_3_55.log"with contents similar to this below:

An Unhandled Exception Occurred,
	Exception Number     : 0xc0000005
	Exception Address    : 0x60ab7e9c

What does it means?
I googled with no good enough answers.
I have a guess but I would like to read from you.
Thanks,

mson77

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258427 is a reply to message #258426] Sat, 11 August 2007 22:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I googled with no good enough answers.
Results 1 - 10 of about 82 for An Unhandled Exception Occurred, Exception Number : 0xc0000005 Oracle

http://www.webservertalk.com/archive149-2004-10-449265.html

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258429 is a reply to message #258427] Sat, 11 August 2007 22:40 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello anacedent,

Thank you for your very fast and kind attention.
Regarding google answers... I have read posts but with no explanation about.

What I guess is... every time that occurs an system error on oracle world... oracle generates this piece of log. More specifically I would say that this regards spfile/pfile/controlfile.

This is my poor conclusion... and I appreciate to read something from the gurus like you.

Very Thanks,


mson77

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258431 is a reply to message #258426] Sat, 11 August 2007 22:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I/we have ZERO idea what you may have done over preceeding hours/days.
For the particular URL I posted, the problem was due to OP changing initSID.ora values resulting in core dumps by Oracle.

I can honestly say that I have NEVER, EVER saw any similar files on ANY of the hundreds of systems where I installed Oracle.
I suspect that whatever happened, it was PEBKAC induced.

>"core_cm3_pid_2916_tid_xE44_2007_8_11_3_3_55.log"
I suspect that _3_3_55 is a timestamp when this file was made.
What does the OS timestamp indicate when the file was made?

What is content of this file?

What had you changed at or just before this time?

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258434 is a reply to message #258431] Sat, 11 August 2007 23:10 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello anacedent,

Attached is a view of "error_file_name" x "OS_file_timestamp".
Well... it should regard pid (maybe process_id)... and tid (task_id??).

Anyway... now I will try to pay more attention on errors and this folder contents too. I tried to cause an error (file like this) now... but I did not get the file as expected (as you can see on the image... the file name and the os timestamp is quite far in time). Well... I will try to observe this issue day by day... further.

Thank you,

mson77

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258436 is a reply to message #258426] Sat, 11 August 2007 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The gif was interesting.
My observation is that what I thought to be the timestamp portion always appeared to be "around" 2 hours before the OS timestamp;
so it could have been when the file was opened while the OS timestamp reflects when the file was closed.

Please post the contents of 1 of these logfiles.

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258440 is a reply to message #258436] Sat, 11 August 2007 23:35 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello anacedent,

Attached is one of these requested files.
I could zip and post several files... but it would be unnecessary because the format of the inside content is the same. The lines: One header (always the same), one describing exception number and the last exception address. The number and address change.
To ease... here is the content:
An Unhandled Exception Occurred,
	Exception Number     : 0xc0000005
	Exception Address    : 0x60ab7e9c

Regards,

mson77

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258443 is a reply to message #258426] Sat, 11 August 2007 23:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I guess I was not paying close enough attention to your earlier posts. The content is duly underwhelming at least for this reader

If you like looking for needles in a haystack, you might want to compare contents of the alert_sid.log file around the time(s) of these log files.
You may (or may not) find some correlation.

HTH & YMMV!

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258446 is a reply to message #258443] Sun, 12 August 2007 00:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,
I am also facing same problem.


All files generated in "$ORACLE_HOME/database folder.
Name of the Files
LIKE:
core_<sid>_XXXX_xxx_2007_Month_x_x_x_x.log


Files contents
An Unhandled Exception Occurred,
	Exception Number     : 0xc0000005
	Exception Address    : 0x608fe8a6


All files have only three lines and same Exception Number,Exception Address.

When its happen.

I noticed whenever i restart my Machine(OS) after rebooting when i check database folder then one "core" file is generated.

I have two DB on my system ( 1.ORCL, 2.OEM)
so two "core" files is generated.

May Be Problem with MY OS not with Oracle.

Suggestion:
We should check Event Viewer for more info about OS problem.

and i am getting this "core" files last 30 days and my database is going fine. nothing wrong. ( it is developer/testing DB) but same like production.


[Updated on: Sun, 12 August 2007 00:13]

Report message to a moderator

Re: An Unhandled Exception Occurred [message #258451 is a reply to message #258446] Sun, 12 August 2007 00:54 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

Taj is great.
Every file with name like that the expression posted by Taj... has the same internal content. All the files have the same information inside. I wrote before that the information changes but I was mistaken: It is always the same.

Also... the creation of these files are related with system power on/reboot. I powered on and reboot my server and it occurs as showed in the image attached. Also I found a message in the Windows Event Viewer with some Audit Trail message.

I guess anacedent did not experience this... because he does not use Windows.

Occurs 2 types of message shown by Event Viewer: This...
Audit trail: ACTION : 'STARTUP' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: AUTORIDADE NT\SYSTEM CLIENT TERMINAL: Not Available STATUS: 0 .

and this one.
Audit trail: ACTION : 'CONNECT' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: AUTORIDADE NT\SYSTEM CLIENT TERMINAL: SERVER2003R2 STATUS: 0 .

Regards,

mson77

Report message to a moderator

Previous Topic: ORA-01092..........
Next Topic: strange problem in running reports
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 20:30:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.