Ora-00600 Internal Error Code Kdsgrp1
Contents |
modifies around 30000 records. Statement executed successfully on a single record, but when I execute to update all records it is going to fail ora 00600 internal error code arguments with following error message: ORA-00600: internal error code, arguments: [kdsgrp1], [], [],
My Oracle Support
[], [], [], [], [], [], [], [], [] Solution: Open and view the alert log file when error occurred Get the trace file name from alert log file and open it Search the keyword "Plan Table" in trace file Here you found details of the query causing problem Identify the tables from above query and execute the following: Analyze table
[13013], [5001], [517], [4260059], [139], [4260059], [3], [] in the alert log and sometimes, the database stops working ... Workaround SQL> Select object_name,object_type,owner from dba_objects where data_object_id=517; OBJECT_NAME--------------------------------------------------------------------------------OBJECT_TYPE OWNER------------------- ------------------------------COL_USAGE$TABLE SYSSQL> analyze table SYS.COL_USAGE$ validate structure online;Table analyzed.SQL> analyze table SYS.COL_USAGE$ validate structure cascade online;analyze table SYS.COL_USAGE$ validate structure cascade online*ERROR at line 1:ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], http://rana-abdulwahid.blogspot.com/2014/08/ora-00600-internal-error-code-arguments.html [], [], [],[]SQL> select index_name from dba_indexes where table_name='COL_USAGE$';INDEX_NAME------------------------------I_COL_USAGE$SQL> Set long 1000000SQL> Select dbms_metadata.get_ddl('INDEX','I_COL_USAGE$','SYS') from dual;DBMS_METADATA.GET_DDL('INDEX',--------------------------------------------------------------------------------CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" ("OBJ#", "INTCOL#") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) http://oracleonlinux-n.blogspot.com/2015/01/ora-00600-internal-error-code-arguments.html TABLESPACE "SYSTEM"SQL> drop index "SYS"."I_COL_USAGE$";Index dropped.SQL> CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" ("OBJ#", "INTCOL#") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM";Index created.SQL> analyze table SYS.COL_USAGE$ validate structure cascade online; Table analyzed. --------------------------------------------------------------------------------------------------------------- Oracle Doc ID : 816784.1 Posted by shareefpkd at 9:21 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ▼ 2015 (2) ► February (1) ▼ January (1) ORA-00600: internal error code, arguments: [13013]... ► 2014 (1) ► September (1) ► 2013 (5) ► May (2) ► February (1) ► January (2) ► 2012 (3) ► November (2) ► March (1) About Me shareefpkd View my complete profile Watermark template. Powered by Blogger.
[kdsgrp1], [], [], [], [], [], [], [] I usually solve http://myexperiencesoracle.blogspot.com/2015/09/ora-00600-internal-error-code-arguments.html it recreatingthe index or indexes of the affected table http://www.freelists.org/post/oracle-l/Intermittent-ORA-600-kdsgrp1,3 To know and generate the sentences to rebuild the index/indexes from the affected table use this sentence select 'alter index ' ||owner|| '.' ||index_name|| ' rebuild;' from dba_indexes where table_name='affected table name'; For example, to rebuild all internal error indexes from a table named test01 and owner Gorka, the steps will be.... 1.- SQL> select 'alter index ' ||owner|| '.' ||index_name|| ' rebuild;' from dba_indexes where table_name='TEST01'; 'ALTERINDEX'||OWNER||'.'||INDEX_NAME||'REBUILD;' -------------------------------------------------------------------------------- alter index gorka.test_index01 rebuild; alter index gorka.test_index_PK rebuild; alter index gorka.test_index02 rebuild; alter index gorka.test_index03 internal error code rebuild; 4 rows selected. 2.- execute the sentences generated (copy the list and paste in sqlplus and then return) SQL> Index altered. SQL> Index altered. SQL> Index altered. SQL> Index altered. Posted by Gorka Zarate Ormaetxe at 10:54 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ▼ 2015 (11) ► October (1) ▼ September (3) ORA-00600: internal error code, arguments: [kdsgrp... MATRIX: ORACLE DATABASE ROADMAP 2006-2022 MATRIX: ORACLE DATABASE UPGRADE ► April (7) ► 2014 (17) ► July (3) ► June (3) ► May (6) ► April (5) El objetivo de este blog es compartir situaciones reales con soluciones especificas reales. Gorka Zarate Ormaetxe View my complete profile Gorka Zárate Ormaetxe. Picture Window template. Powered by Blogger.
Arvind, The kdsgrp1 function stands for "kernel data scan get row piece" - in other words the function which can extract a row from a buffer. When an ORA-600 happens in this function, then Oracle thinks it must be some sort of a data corruption in buffer cache and dumps the latest redo *that modified this buffer* into a tracefile. That's why the "log file sequential read" wait events show up in a foreground session ... Note that you might not necessarily have a (memory) corruption happening as the ORA-600 error might be raised because of some software bug (I've seen such issues with spatial datatypes ...) -- Tanel Poder New Online Training! - http://blog.tanelpoder.com/seminar The Voicee App - http://voic.ee On Wed, Jan 9, 2013 at 4:22 PM, Kumar, Arvind