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.
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:
Post a Comment