Home » RDBMS Server » Server Administration » ORA 7445 exception encountered
ORA 7445 exception encountered [message #223177] Wed, 07 March 2007 21:06 Go to next message
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
Re: ORA 7445 exception encountered [message #223178 is a reply to message #223177] Wed, 07 March 2007 21:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: ORA 7445 exception encountered [message #223180 is a reply to message #223178] Wed, 07 March 2007 21:22 Go to previous messageGo to next message
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
Re: ORA 7445 exception encountered [message #223182 is a reply to message #223180] Wed, 07 March 2007 21:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: ORA 7445 exception encountered [message #223183 is a reply to message #223182] Wed, 07 March 2007 21:33 Go to previous messageGo to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Thanks for your valued reply.

Magesh
Re: ORA 7445 exception encountered [message #223214 is a reply to message #223177] Thu, 08 March 2007 00:44 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
In these type of errors(Error code without error description),we usualy raise TAR with Oracle support.They will request you to attach the trace file.
Re: ORA 7445 exception encountered [message #223218 is a reply to message #223214] Thu, 08 March 2007 00:48 Go to previous message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Thanks for your reply Mr.Krishnan
Previous Topic: Archive log not able to write.....query
Next Topic: conn / as sysdba
Goto Forum:
  


Current Time: Sun Dec 04 22:30:40 CST 2016

Total time taken to generate the page: 0.10858 seconds