Home » RDBMS Server » Performance Tuning » ORA-600 and ORA-7445 error in Oracle 10g R2 (Oracle 10g R2 ,OS - 2003 Server, RAM 4GB, Front End-JAVA)
ORA-600 and ORA-7445 error in Oracle 10g R2 [message #416725] Tue, 04 August 2009 01:59 Go to next message
suvin_prathab
Messages: 4
Registered: February 2009
Location: India
Junior Member

hi all,
we are using Oracle 10g r2.
os is windows 2003 server,
ram is 4 gb.
front end is java .


we got a below mentioned errors.

i got the ORA-00600: internal error code, arguments: qerghFetch:inc], [, ], [, ], [, ], [,
and ORA-07445: exception encountered: core dump ACCESS_VIOLATION unable_to_trans_pc PC:0x61F04AC9 ADDR:0xC UNABLE_TO_READ] [
and Error 0 in kwqmnpartition(), aborting txn errors.

for aug 3 11.42.47 we got a ora 600 error after that through front end (java) users can't able to connect the database.the not able to executed the query session disconnected error.
what is reason for theis error . how it will rectifiy.?
pls advice.Below i attached the alret log message .

Sun Aug 02 04:04:24 2009
Error 0 in kwqmnpartition(), aborting txn
Sun Aug 02 05:48:10 2009
Error 0 in kwqmnpartition(), aborting txn
Sun Aug 02 05:49:10 2009
Error 0 in kwqmnpartition(), aborting txn
Sun Aug 02 07:38:49 2009
Thread 1 advanced to log sequence 1732
Current log# 3 seq# 1732 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sun Aug 02 07:44:14 2009
Error 0 in kwqmnpartition(), aborting txn
Sun Aug 02 07:45:14 2009
Error 0 in kwqmnpartition(), aborting txn
Sun Aug 02 22:00:26 2009
Thread 1 advanced to log sequence 1733
Current log# 1 seq# 1733 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Mon Aug 03 07:08:15 2009
Thread 1 advanced to log sequence 1734
Current log# 2 seq# 1734 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Mon Aug 03 09:28:23 2009
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 09:30:27 2009
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 11:42:47 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_6012.trc:
ORA-00600: internal error code, arguments: qerghFetch:inc], [, ], [, ], [, ], [

Mon Aug 03 13:20:00 2009
Thread 1 advanced to log sequence 1735
Current log# 3 seq# 1735 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Mon Aug 03 16:07:07 2009
Errors in file e:\oracle\product\10.2.0\em_2\rdbms\trace\orcl_ora_4756.trc:
ORA-07445: exception encountered: core dump ACCESS_VIOLATION unable_to_trans_pc PC:0x61F04AC9 ADDR:0xC UNABLE_TO_READ] [


Mon Aug 03 16:07:11 2009
Process m000 died, see its trace file
Mon Aug 03 16:07:11 2009
ksvcreate: Process(m000) creation failed
Mon Aug 03 16:08:37 2009
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 16:10:40 2009
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 17:25:05 2009
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 17:27:11 2009
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 17:32:19 2009
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 17:33:24 2009
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 18:52:08 2009
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 18:54:09 2009
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 19:05:33 2009
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Mon Aug 03 19:09:02 2009
Errors in file e:\oracle\product\10.2.0\em_2\rdbms\trace\orcl_ora_5132.trc:
ORA-07445: exception encountered: core dump ACCESS_VIOLATION unable_to_trans_pc PC:0x7C34126B ADDR:0x0 UNABLE_TO_WRITE] [


Mon Aug 03 19:10:27 2009
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn
Error 0 in kwqmnpartition(), aborting txn

[EDITED by LF: specified product version after topics have being merged]

[Updated on: Tue, 04 August 2009 02:22] by Moderator

Report message to a moderator

Re: ORA-600 and ORA-7445 error in Oracle 10g R2 [message #416736 is a reply to message #416725] Tue, 04 August 2009 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: ORA-600 and ORA-7445 error in Oracle 10g R2 [message #416738 is a reply to message #416736] Tue, 04 August 2009 02:39 Go to previous messageGo to next message
suvin_prathab
Messages: 4
Registered: February 2009
Location: India
Junior Member

my metalink id is not working .. so only im askin here..
Re: ORA-600 and ORA-7445 error in Oracle 10g R2 [message #416739 is a reply to message #416738] Tue, 04 August 2009 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
suvin_prathab wrote on Tue, 04 August 2009 09:39
my metalink id is not working .. so only im askin here..

How is it not working?

Regards
Michel

Re: ORA-600 and ORA-7445 error in Oracle 10g R2 [message #418147 is a reply to message #416738] Thu, 13 August 2009 03:18 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
my metalink id is not working
Shame - metalink has quitea lot of information about ORA-600 errors like that one.

As @Michel said - how is it not working. If you've got Oracle support, you can raise SR's be phone as well as on the internet.
Previous Topic: Performance issue in Plsql
Next Topic: Impact of table partitioning on DML/Index creation Time (merged)
Goto Forum:
  


Current Time: Tue Dec 03 17:14:08 CST 2024