ERROR METHOD:-1
Startup database fails with ORA-600 [4000], ORA-600 [4137].
Steps to open the database:
§
setting _ALLOW_RESETLOGS_CORRUPTION=TRUE
in init<SID>.ora.
§
startup mount;
§
recover database until cancel;
<--cancel
<--cancel
§
alter database open resetlogs;
But, it failed with the following error:
ORA-00600: internal error code, arguments:
[4000], [9], [], [], [], [], [], []
Oracle Note:47456.1:
DESCRIPTION:
This has the potential to be a very serious
error.
It means that Oracle has tried to find an
undo segment number in the
dictionary cache and failed.
ARGUMENTS:
Arg [a] Undo segment number
FUNCTIONALITY:
KERNEL TRANSACTION UNDO
IMPACT:
INSTANCE FAILURE - Instance will not restart
STATEMENT FAILURE
An exerpt from the trace file:
ORA-00600:
internal error code, arguments: [4000], [9], [], [], [], [], [], []
Current
SQL statement for this session:
select
ctime, mtime, stime from obj$ where obj# = :1
...
Block
header dump: 0x0080003e
Object id on Block? Y
seg/obj: 0x12
csc: 0x570.b8368d16 itc: 1 flg: -
typ: 1 - DATA
fsl: 0
fnx: 0x0 ver: 0x01
...
Itl
Xid Uba Flag
Lck Scn/Fsc
Looks like a problem regarding obj$ and
its undo...If undo requirement is bypassed, there will be no requirement for
undo. In order to do that, bumping SNC further needed.
csc shows the the SCN of
last block cleanout. We guessed it may be used a target bumping SCN as
below:
§
0x570.b8368d16 => 0x570b8368d16 =>
Decimal: 5981685058838 => divide by 1024/1024/1024 = 5571
Bump SCN as below and restart:
§
Setting _MINIMUM_GIGA_SCN = 5571 in
init<SID>.ora
§
startup mount;
§
recover database until cancel;
<--cancel
<--cancel
§
alter database open resetlogs;
ORA-600 [4000] disappeared. But now, the
following error appeared:
ORA-00600: internal error code, arguments:
[4137], [], [], [], [], [],
[], []
Oracle Note:47456.1:
DESCRIPTION:
While backing out an undo record (i.e. at the
time of rollback) we found a
transaction id mis-match indicating either a
corruption in the rollback
segment or corruption in an object which the
rollback segment is trying to
apply undo records on.
This would indicate a corrupted rollback
segment.
FUNCTIONALITY:
Kernel Transaction Undo Recovery
IMPACT:
POSSIBLE PHYSICAL CORRUPTION in Rollback
segments
Restart the database:
§
Setting _CORRUPTED_ROLLBACK_SEGMENTS in
init<SID>.ora
§
startup mount;
§
recover database until cancel;
<--cancel
<--cancel
§
alter database open resetlogs;
The database is opened.
Since it's opened in inconsistent
state, a full export and then import into a new database is required to get rid
of the inconsistency in Oracle dictionary. But, the customer data will not be
consistent after the import. It should be reviewed by the customer.
Oracle Note:47456.1
ERROR METHOD:-2
ORA-00600: internal error code, arguments: [keltnfy-ldmInit],
[46], [1], [], [], [], [], []
After a long time I have an error of ora-00600.
One of my Database is Oracle 10.2.0.1.0
Cause:
In log we were receiving these errors.
Oracle Server was not resolving HOSTNAME.
Mon Jan 7 14:58:48 2008Errors in file /usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_2462.trc:ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []USER: terminating instance due to error 600
Solution:
added an entry for localhost in /etc/hosts.
open /etc/hosts file
vi /etc/hosts
:0:1 localhost.localdomain localhost
alter this to ....
127.0.0.1 localhost.localdomain localhost
or
ip_of_your_DBbox localhost.localdomain localhost
after that now check
-bash-3.1$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 7 15:05:56 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> select count(*) from tab;
COUNT(*)
----------
3535
One of my Database is Oracle 10.2.0.1.0
Cause:
In log we were receiving these errors.
Oracle Server was not resolving HOSTNAME.
Mon Jan 7 14:58:48 2008Errors in file /usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_2462.trc:ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []USER: terminating instance due to error 600
Solution:
added an entry for localhost in /etc/hosts.
open /etc/hosts file
vi /etc/hosts
:0:1 localhost.localdomain localhost
alter this to ....
127.0.0.1 localhost.localdomain localhost
or
ip_of_your_DBbox localhost.localdomain localhost
after that now check
-bash-3.1$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 7 15:05:56 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> select count(*) from tab;
COUNT(*)
----------
3535
No comments:
Post a Comment