ORA-00600: internal error code, arguments: [4146], ... [message #56905] |
Mon, 05 May 2003 05:51 |
Stelios Vlassopoulos
Messages: 2 Registered: May 2003
|
Junior Member |
|
|
ORACLE7 Server Release 7.0.16.4.1 - Production
System name: UNIX_SV
Node name: ncr4300
Release: 4.0
Version: 3.0
Machine: 3446
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [[4146]], [[2103]], [[2073]], [[]], [[]], [[]], [[]], [[]]
----- System Info Dump -----
Resource Current Maximum
---------------------------------------------
RLIMIT_CORE 0x 2000000 0x 2000000
RLIMIT_CPU 0x7fffffff 0x7fffffff
RLIMIT_DATA 0x7fffffff 0x7fffffff
RLIMIT_FSIZE 0x7fffffff 0x7fffffff
RLIMIT_NOFILE 0x 400 0x 400
RLIMIT_STACK 0x7fffffff 0x7fffffff
RLIMIT_VMEM 0x7fffffff 0x7fffffff
---------------------------------------------
----- System Config Dump -----
Resource Current
---------------------------------------------
_SC_ARG_MAX 0x 8000
_SC_CHILD_MAX 0x 190
_SC_CLK_TCK 0x 64
_SC_NGROUPS_MAX 0x 10
_SC_OPEN_MAX 0x 400
_SC_PASS_MAX 0x 8
_SC_PAGESIZE 0x 1000
_SC_JOB_CONTROL 0x 1
_SC_SAVED_IDS 0x 1
_SC_VERSION 0x 30961
_SC_XOPEN_VERSION 0x 4
_SC_LOGNAME_MAX 0x 20
_SC_NPROC_CONF 0xffffffff
_SC_NPROC_ONLN 0xffffffff
---------------------------------------------
etc.
sql command that causes the error:
select rowid,company,cd_use,cd_rs
from d_ledg
It fetches 1090 records and message appears after rowid
'00002934.0006.001D'
|
|
|
Re: ORA-00600: internal error code, arguments: [4146], ... [message #56906 is a reply to message #56905] |
Mon, 05 May 2003 05:56 |
Uwe
Messages: 260 Registered: February 2003 Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
This is what Oracle Metalink said to your specific problem:
Oracle is scanning the cache for undo records. If a block's SCN is found to be invalid, ORA-00600 [[4147]] is logged. The ORA-600[[4147]] basically indicates some kind of corruption with the UNDO (rollback segment)block,
most probably due to a lost write to the rollback segment. The main approach is to identify the file containing the bad RBS block
and treat the problem as if this file is corrupt.
Recover the RBS datafiles from earlier HOT / COLD backup
regards
Uwe
|
|
|
|
Re: ORA-00600: internal error code, arguments: [4146], ... [message #56908 is a reply to message #56905] |
Mon, 05 May 2003 05:59 |
Uwe
Messages: 260 Registered: February 2003 Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
Sorry I posted the wrong message before:
This is what Oracle Metalink said to your specific problem:
ERROR:
ORA-600 [[4146]][[a]][[b]][[c]][[d]][[e]]
VERSIONS:
V7, V8
DESCRIPTION:
You have a corrupt rollback segment. This is usually caused by hardware
errors, specifically a lost write to the rollback segment. The rollback
segment does not contain sufficient undo to rollback a transaction.
ARGUMENTS:
[[ARG#1]] Sequence# expected
[[ARG#2]] Sequence# in block header.
FUNCTIONALITY:
Rollback
IMPACT:
Rollback segment corruption.
SUGGESTIONS:
This kind of corruption can be caused by a lost write - Get your
OS/hardware checked.
regards
Uwe
|
|
|
|
|