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 |
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 #418147 is a reply to message #416738] |
Thu, 13 August 2009 03:18 |
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.
|
|
|
Goto Forum:
Current Time: Tue Dec 03 17:14:08 CST 2024
|