1 2 Previous Next 22 Replies Latest reply on Feb 27, 2013 7:01 PM by rukbat

ORA-00600: internal error code

Tiny_Oracle Jun 21, 2010 7:48 AM

Hello,

I couldn't start my database, this is the log:

Mon Jun 21 00:37:32 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile C:\ORACLE\CDS\PRODUCT\11.2.0\CLICK_DBHOME\DATABASE\SPFILECLICK11G.ORA
System parameters with non-default values:
processes = 150
memory_target = 1G
control_files = "C:\ORACLE\CLICK11G\ORADATA\CLICK11G\CONTROL01.CTL"
control_files = "C:\ORACLE\CLICK11G\RECOVERY_AREA\CLICK11G\CONTROL02.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "C:\Oracle\Click11g\recovery_area"
db_recovery_file_dest_size= 25G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=click11gXDB)"
audit_file_dest = "C:\ORACLE\CLICK11G\ADMIN\CLICK11G\ADUMP"
audit_trail = "DB"
db_name = "click11g"
open_cursors = 300
diagnostic_dest = "C:\ORACLE\CLICK11G"
Mon Jun 21 00:37:32 2010
PMON started with pid=2, OS id=736
Mon Jun 21 00:37:32 2010
VKTM started with pid=3, OS id=1484 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Jun 21 00:37:32 2010
GEN0 started with pid=4, OS id=2944
Mon Jun 21 00:37:32 2010
DIAG started with pid=5, OS id=1512
Mon Jun 21 00:37:32 2010
DBRM started with pid=6, OS id=2304
Mon Jun 21 00:37:33 2010
PSP0 started with pid=7, OS id=2892
Mon Jun 21 00:37:33 2010
DIA0 started with pid=8, OS id=2064
Mon Jun 21 00:37:33 2010
MMAN started with pid=9, OS id=3044
Mon Jun 21 00:37:33 2010
DBW0 started with pid=10, OS id=2340
Mon Jun 21 00:37:33 2010
LGWR started with pid=11, OS id=2668
Mon Jun 21 00:37:33 2010
CKPT started with pid=12, OS id=2844
Mon Jun 21 00:37:33 2010
SMON started with pid=13, OS id=2108
Mon Jun 21 00:37:33 2010
RECO started with pid=14, OS id=3052
Mon Jun 21 00:37:33 2010
MMON started with pid=15, OS id=2168
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jun 21 00:37:33 2010
MMNL started with pid=16, OS id=3056
starting up 1 shared server(s) ...
ORACLE_BASE from environment = C:\Oracle\Click11g
Mon Jun 21 00:37:33 2010
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 2405271053
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Mon Jun 21 00:37:38 2010
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Started redo scan
Completed redo scan
read 13627 KB redo, 0 data blocks need recovery
Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc (incident=51767):
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
Incident details in: c:\oracle\click11g\diag\rdbms\click11g\click11g\incident\incdir_51767\click11g_ora_1992_i51767.trc
Aborting crash recovery due to error 600
Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Trace dumping is performing id=[cdmp_20100621003740]

Where is the problem ?

I performed recovery using EM, but the database couldn't start.
I just want single package from this database, how could I restore this tablespace or get any type of export?

thanks very much

1. Re: ORA-00600: internal error code

618702 Jun 21, 2010 7:51 AM (in response to Tiny_Oracle)

Tiny_Oracle,

If you have metalink access it would be better for you to check the ORA-600 diagnostic tool in there.

read 13627 KB redo, 0 data blocks need recovery
Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc (incident=51767):
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
Incident details in: c:\oracle\click11g\diag\rdbms\click11g\click11g\incident\incdir_51767\click11g_ora_1992_i51767.trc
Aborting crash recovery due to error 600

I think you have had a bad restart of the database or something has corrupted lately, is that true? What is more in the alert.log file btw?

Ogan
Like Show 0 Likes(0)

Actions
2. Re: ORA-00600: internal error code

asifkabirdba Jun 21, 2010 7:51 AM (in response to 618702)

ORA - 00600 Error

Read the post.

Regards
Asif Kabir
Like Show 0 Likes(0)

Actions
3. Re: ORA-00600: internal error code

mbobak Jun 21, 2010 7:56 AM (in response to asifkabirdba)

Hm....different version of Oracle....different ORA-600....why is he supposed to read that post?

-Mark
Like Show 0 Likes(0)

Actions
4. Re: ORA-00600: internal error code

Tiny_Oracle Jun 21, 2010 8:01 AM (in response to 618702)

Thanks Ogan,

Yes that occures after hardware failure and I don't have SR at Oracle Support :(
There's no more at log file about this issue.

All what I want is to restore single important package, Can I perform cold backup or some thing like that ?

Regards
Like Show 0 Likes(0)

Actions
5. Re: ORA-00600: internal error code

618702 Jun 21, 2010 8:04 AM (in response to Tiny_Oracle)

Tiny_Oracle,

Ok then;

Create the pfile from the spfile and start the database with that pfile BUT first delete everything inside it other than controlfile paths. We have to eliminate possibilities that this may be caused by a parameter in the spfile.

Other than that i really shouldn't be guiding you when you have seen ORA-00600 error, no one has.

Ogan
Like Show 0 Likes(0)

Actions
6. Re: ORA-00600: internal error code

Tiny_Oracle Jun 21, 2010 8:08 AM (in response to asifkabirdba)

Thanks asifkabirdba,

I made this:

SQL> conn sys/******* as sysdba
Connected.
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2182592 bytes
Variable Size 750780992 bytes
Database Buffers 310378496 bytes
Redo Buffers 5595136 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[107], [57549], [57552], [], [], [], [], [], [], []

SQL>

As I told you that happened after Hardware failure, when I fixed the server I got at first this error:
ORA-01033: ORACLE initialization or shutdown in progress

I let the database "Starting !" all the night but It couldn't start, then I performed the recovery and I'm here now !

Regards
Like Show 0 Likes(0)

Actions
7. Re: ORA-00600: internal error code

618702 Jun 21, 2010 8:13 AM (in response to Tiny_Oracle)

Tiny_Oracle,

Have you tried recover database and alter database open resetlog commands?

I have never seen this ORA-600 error before but i presume it can not complete the crash recovery. So you may should have to apply the latest archivelog to the database, if your database was in archive log mode.

Ogan
Like Show 0 Likes(0)

Actions
8. Re: ORA-00600: internal error code

Billy~Verreynne Jun 21, 2010 8:27 AM (in response to Tiny_Oracle)

Before trying any suggestion or attempting any kind of recovery... cold backup the entire database first!

ORA-600's are also best dealt with by logging a Service Request (SR) with Oracle Support - unless you find the exact same error with exact same symptoms and exact same o/s and versions listed on a Metalink/MoS support note that provides a workaround to use or patch to install.
Like Show 0 Likes(0)

Actions
9. Re: ORA-00600: internal error code

785714 Jul 17, 2010 10:23 PM (in response to Tiny_Oracle)

Have you found a fix yet? I have a similar error. My computer had a hard shutdown and checkdisk fixed some index files. Windows 2008 R2 x64 enterprise. Oracle 11.2.0.1 r2x64. Below is the error.

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 313159680 bytes
Fixed Size 2175328 bytes
Variable Size 255856288 bytes
Database Buffers 50331648 bytes
Redo Buffers 4796416 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[38], [50733], [50921], [], [], [], [], [], [], []

Edited by: user13370564 on Jul 17, 2010 3:22 PM
Like Show 0 Likes(0)

Actions
10. Re: ORA-00600: internal error code

668953 Oct 1, 2010 9:27 PM (in response to 785714)

i had a server crash (solaris 10) and the 11gR2 database on it has the same error now when i try to open database:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [5885], [2139], [2141], [], [], [], [], [], [], []

when i did a oracle support search, found:
Bug 10100975: DATABASE CRASH AND FAILS TO OPEN WITH ORA-600 [KCRATR_NAB_LESS_THAN_ODR]

and unfortunately, there is no workaround:
WORKAROUND:
-----------
None. Restore and recover PITR.
Like Show 0 Likes(0)

Actions
11. Re: ORA-00600: internal error code

askraks Oct 2, 2010 6:13 AM (in response to Tiny_Oracle)

Hi,

Yes i reviewd the bug and you need to do PITR.

One more why is , Bug is status 11 and you can with escalating the bug :) hope you may get better workaround soon :)

Kind Regards,
Rakesh Jayappa
Like Show 0 Likes(0)

Actions
12. Re: ORA-00600: internal error code

807900 Oct 25, 2010 8:59 AM (in response to askraks)

This is my first attempt to write oracle forums, so i hope i will not cause any trouble.

2 days ago i got a similar error due to abnormal shutdown.
(ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [789], [26030], [26155], [], [], [], [], [], [], [])
i spent whole day for log tracing and error fixing.
Unfortunately i didnt have chance of PITR. I didnt have a back up of my 11g database (my fault, i omit to set up recovery routine as always ).
After an extensive log tracing, i figured out that 11g is getting error after Completed redo scan. While trying to make recovery off data blocks.
Since db was a production system and since i had to wait metalink for a solution, there was no harm on trying some workarounds on copy db.
So i assumed that i can pretend my data and control files as cold back up.
Just in case once more i backed up my crashed db and than started the recovery process. This is what i did 2 days ago :

*>connect sys as sysdba*
*> startup mount*
*> alter database recover until cancel using backup controlfile; (i have ignored promtings).*
*> alter database recover continue default; (until it says “no such file or directory” or there are no more suggestions.)*
*> alter database recover cancel;*
*> alter database open resetlogs;*

And my database was alive .. In my case i havent lost any data but i do not guarantee that this method is data loss free (im just a rookie :) ).
This just brings my database back to life.
I hope this will also a workaround for you ...
Like Show 7 Likes(7)

Actions
13. Re: ORA-00600: internal error code

841747 Feb 22, 2011 12:38 PM (in response to 807900)

Many thanks its a good workaround and it worked for me.......
Like Show 0 Likes(0)

Actions
14. Re: ORA-00600: internal error code

841336 Apr 18, 2011 8:51 AM (in response to 807900)

wow! it works like a charm! thanks a lot for the sharing!!!
Like Show 0 Likes(0)

Actions