Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle shutting down due to ORA-00600:[4142], [1835348594]. need help

user8999602Nov 29 2010 — edited Nov 29 2010
hi,

i have Oracle 11G on linux enterprise rhel 5

i was runing a delete statement on a table and stopped it because it was taking too much time. after that i saw that the oracle instance was down.
i starteed it up and after some minutes it is going down again.
i even restarted the server and after reboot again down.


in the logs files it is show the following msg:
<attr name='IMPACT' value='POSSIBLE ROLLBACK SEGMENT CORRUPTION'/>
Errors in file /oracle/app/oracle/diag/rdbms/xxx/xxx/trace/xxx_smon_14333.trc (incident=74606):
ORA-00600: internal error code, arguments: [4142], [1835348594], [], [], [], [], [], [], [], [], [], []




and in the trace file
Trace file /oracle/app/oracle/diag/rdbms/xxx/xxx/trace/xxx_smon_14333.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/app/oracle/product/11.1.0/db_1
System name: Linux
Node name: xxx
Release: 2.6.18-128.el5
Version: #1 SMP Wed Jan 21 08:45:05 EST 2009
Machine: x86_64
Instance name: xxx
Redo thread mounted by this instance: 1
Oracle process number: 13
Unix process pid: 14333, image: oracle@xxx (SMON)


*** 2010-11-29 18:35:05.955
*** SESSION ID:(323.1) 2010-11-29 18:35:05.955
*** CLIENT ID:() 2010-11-29 18:35:05.955
*** SERVICE NAME:(SYS$BACKGROUND) 2010-11-29 18:35:05.955
*** MODULE NAME:() 2010-11-29 18:35:05.955
*** ACTION NAME:() 2010-11-29 18:35:05.955

Incident 74601 created, dump file: /oracle/app/oracle/diag/rdbms/xxx/xxx/incident/incdir_74601/xxx_smon_14333_i74601.trc
ORA-00600: internal error code, arguments: [25027], [2], [458753], [], [], [], [], [], [], [], [], []

Parallel Transaction recovery caught exception 12801
Parallel Transaction recovery caught error 600
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
KTUNDO: cannot find ts$ entry
SGAFRCWT: 4194304
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2010
Added on Nov 29 2010
3 comments
1,895 views