OraFAQ Forum: Server Administration » ORA 7445 exception encountered

Home » RDBMS Server » Server Administration » ORA 7445 exception encountered

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA 7445 exception encountered [message #223177]

Wed, 07 March 2007 21:06

kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore

Member

Hi All,

Today i got the error as ORA 7445 exception encountered: core dump [][][][][].

Kindly tell me how to overcome this problem.

what is the steps to be followed?

Thanks in advance

Magesh

Report message to a moderator

Re: ORA 7445 exception encountered [message #223178 is a reply to message #223177]

Wed, 07 March 2007 21:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

There should be a related entry in alert_sid.log and a reference to the dump file. post those contents

Report message to a moderator

Re: ORA 7445 exception encountered [message #223180 is a reply to message #223178]

Wed, 07 March 2007 21:22

kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore

Member

Hi,

I mesage from the bdump.

Wed Mar 7 14:59:43 2007
Errors in file /oradata/oradump/tmsprddb/bdump/tmsprddb_cjq0_254740.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []

I will also give you the part of the .trc message from the bdump down.

/oradata/oradump/tmsprddb/bdump/tmsprddb_cjq0_254740.trc
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /u01/app/oracle
System name: AIX
Node name: sin-aptmsprdndb
Release: 3
Version: 5
Machine: 00C991BC4C00
Instance name: tmsprddb
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 254740, image: oracle@sin-aptmsprdndb (CJQ0)

*** SESSION ID:(7.1) 2007-03-07 14:59:43.705
*** 2007-03-07 14:59:43.705
Exception signal: 11 0x101717200 (qerstInitStats+0018) 80050008
Registers:
iar: 0000000101717200, msr: a00000000000d0b2
lr: 0000000101717434, cr: 0000000022222228
r00: 0000000000000000, r01: 0fffffffffff0e70, r02: 00000001101f6ce8,
r03: 0700000072d0ebd8, r04: 0fffffffffff0ee0, r05: 00000002102fdd30,
r06: 0000000000000018, r07: 00000001102e4a30, r08: 0000000110002200,
r09: 00000001100b68c8, r10: 0000000000000000, r11: 0000000000000000,
r12: 000000010237d050, r13: 00000001102362f0, r14: 0000000000008000,
r15: 0000000000008000, r16: 000000010293a790, r17: 0000000000008000,
r18: 0000000110002200, r19: 0000000000000000, r20: 0fffffffffff1b60,
r21: 070000006ca7baa8, r22: 0000000000000001, r23: 0000000110005d80,
r24: 00000001102fe508, r25: 0000000000000330, r26: 0000000110362a88,
r27: 00000002102fdd30, r28: 0fffffffffff11f8, r29: 0fffffffffff0ee0,
r30: 0700000072d0ebd8, r31: 0fffffffffff0ee0,

I dont know the effect of this error to my database.

So, kindly tell me the possible ways to avoid this kind of error messages in future.

Thanks for the reply

Report message to a moderator

Re: ORA 7445 exception encountered [message #223182 is a reply to message #223180]

Wed, 07 March 2007 21:28

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> possible ways to avoid this kind of error messages in future.
If someone can do that, that would be really cool Smile

Fact is these are core dumps and could occur for many a reasons.
In this case, seems a slave process failed. If the case is reproducible , raise a TAR.

Report message to a moderator