ERROR:
During startup we got the following error. The version of the database is; 10.2.0.5.
SQL> startup
ORACLE instance started.
Total System Global Area 3372220416 bytes
Fixed Size 2071640 bytes
Variable Size 1291846568 bytes
Database Buffers 2046820352 bytes
Redo Buffers 31481856 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcbtema_10], [1], [], [], [], [],[], []
SQL>
Also we noticed the following entires in alertlog;
arguments etiketine sahip kayıtlar gösteriliyor. Tüm kayıtları göster
arguments etiketine sahip kayıtlar gösteriliyor. Tüm kayıtları göster
12 Temmuz 2014 Cumartesi
16 Mayıs 2013 Perşembe
[EN] ORA-00600: internal error code, arguments: [kcfrbd_3], [239], [3652081], [1], [2949120], [2949120], [], []
ERROR:
SQL> alter table INFRA.TBL_XXX drop partition PART_25;
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcfrbd_3], [239], [3652081], [1], [2949120], [2949120], [], []
SOLUTION:
If the datafile with number 239 belong to the active UNDO tablespace, then try to reduce the size of this datafile. And then increase to its original size if you like. If you can not reduce the size of this datafile; then create a new UNDO tablespace, switch to this new UNDO tbalespace and then drop the old one.
This should fix the problem.
If not; as a workaround you can first move and then drop the partition.
SQL> alter table INFRA.TBL_XXX drop partition PART_25;
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcfrbd_3], [239], [3652081], [1], [2949120], [2949120], [], []
SOLUTION:
If the datafile with number 239 belong to the active UNDO tablespace, then try to reduce the size of this datafile. And then increase to its original size if you like. If you can not reduce the size of this datafile; then create a new UNDO tablespace, switch to this new UNDO tbalespace and then drop the old one.
This should fix the problem.
If not; as a workaround you can first move and then drop the partition.
[EN] ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
ERROR:
SQL> alter table INFRA.TABLEXXX split partition PART15 at (7030081) into (partition PART16 tablespace TBS_XXX, partition PART15);
ERROR at line 1:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
SOLUTION:
alter session set events '14525 trace name context forever, level 1';
SQL> alter table INFRA.TABLEXXX split partition PART15 at (7030081) into (partition PART16 tablespace TBS_XXX, partition PART15);
SQL> alter table INFRA.TABLEXXX split partition PART15 at (7030081) into (partition PART16 tablespace TBS_XXX, partition PART15);
ERROR at line 1:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
SOLUTION:
alter session set events '14525 trace name context forever, level 1';
SQL> alter table INFRA.TABLEXXX split partition PART15 at (7030081) into (partition PART16 tablespace TBS_XXX, partition PART15);
Kaydol:
Kayıtlar (Atom)