Tuesday, March 1, 2011

ORA-00600: internal error code, arguments: [kccsbck_first], [1], [3978145973],

Ora-600  is a generic internal error number for Oracle program exceptions. This indicates that a process is encountered an exceptional or unexpected condition. Although it often suggests a bug, ORA-00600 can result from many other reasons: timeouts, limited system resources (e.g. memory and disk space), OS issues (e.g. caching and memory  management), server crashes, network failures, power failures, disk drive crashes, I/O errors, incorrectly  archived files and even driver issues. In many cases, ORA-00600 denotes an existing file corruption or a   data check failure in Oracle RDBMS.

Action ::  Report as a bug - the first argument is the internal error number.

Let's have an example  , We got ORA-600 , when we rebooted our server  and there more tha 4 instances running on this server .....

CASE : I 

C:\>set ORACLE_SID=rosen
C:\>sqlplus sys/XXXXX@rosen as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 29 12:28:00 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup

ORACLE instance started.
Total System Global Area   3423965184 bytes
Fixed Size                    2180544 bytes
Variable Size              2080377408 bytes
Database Buffers        1325400064 bytes
Redo Buffers                16007168 bytes

ORA-00600: internal error code, arguments: [kccsbck_first], [1], [3978145973],
[], [], [], [], [], [], [], [], []

Here , we checked  the meta-link and found the below description :

We receive this error because we are attempting to be the first  thread/instance to mount the database and cannot because it appears that at least one other thread has mounted the database already'.
However in this case the database was a standalone database on Windows.It  had only one oracle service running. So , we bounced the db once and it' works fine .

SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3423965184 bytes
Fixed Size                    2180544 bytes
Variable Size               2080377408 bytes
Database Buffers         1325400064 bytes
Redo Buffers                 16007168 bytes
Database mounted.

SQL> alter database open;
Database altered.

SQL> select name,open_mode from v$database;
NAME      OPEN_MODE
---------     ---------------
ROSEN     READ WRITE

Here is an another example of same above ora-600 issue  . This instance is running on same server and after rebooting , it's throwing the same above error  .

CASE :: II

C:\>sqlplus sys/XXXX@royalton as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 29 12:37:37 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.
Total System Global Area  3423965184 bytes
Fixed Size                      2180544 bytes
Variable Size                  1979714112 bytes
Database Buffers            1426063360 bytes
Redo Buffers                  16007168 bytes

ORA-00600: internal error code, arguments: [kccsbck_first], [1], [73515151],[], [], [], [], [], [], [], [], []

As in above case, I have started the database in mount and then alter it to the open mode but it doesnot work out. After some analysis of alert logfile and tracefile regsrding this issue , we have decided to flush the shared pool  component of the SGA . So, we have started the database in mount stage and then flush the shared pool and it works like a charm  .

SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.

C:\>set ORACLE_SID= royalton
C:\>sqlplus sys/xxxxxxxx@royalton  as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 29 12:28:00 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup mount
ORACLE instance started.
Total System Global Area 3423965184 bytes
Fixed Size                     2180544 bytes
Variable Size                 2080377408 bytes
Database Buffers            1325400064 bytes
Redo Buffers                  16007168 bytes
Database mounted.

SQL> alter system flush shared_pool;

SQL> alter database open
Database altered.

SQL> select name,open_mode from v$database;
NAME            OPEN_MODE
---------       -----------
ROYALTON        READ WRITE

Conclusion : Though this is not the solution but a workaround to solve this issue having above argument  . It is highly recommended to contact with Oracle Support for  Ora-600 errors  .


Enjoy    :-)


No comments: