One ORA-600 [13011], one ora-60013011

Source: Internet
Author: User

One ORA-600 [13011], one ora-60013011
SunOS 5.10 Oracle 10.2.0.2.0 development environment a database has a ora-600 error.
Alert. error message in log: Thu Nov 13 15:11:43 2014 Errors in file/oracle/admin/sun/bdump/sun_j000_29589.trc: ORA-00600: internal error code, arguments: [13011], [298314], [4277430], [0], [4277430], [17], [], [] Thu Nov 13 15:11:45 2014 Errors in file/oracle/admin/sun/bdump/sun_j000_29589.trc: ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] ORA-06512: at "REPADMIN. CEF_PUSH_PURGE ", line 145ORA-06512: at line 1
In the/oracle/admin/sun/bdump/sun_j000_29589.trc trace file, the current SQL statement is used to delete the system. one record of def $ _ aqcall: ksedmp: internal or fatal errorORA-00600: internal error code, arguments: [13011], [298314], [4277430], [0], [4277430], [17], [], [] Current SQL statement for this session: delete from system. def $ _ aqcall where (enq_tid =: 1) based on MOS ORA-600 [13011]"Problem Occurred When Trying To Delete A Row"(DocumentID28184.1)Parameter comparison;

SQL> select object_type, object_name, owner from dba_objects where data_object_id = '20140901 ';
OBJECT_TYPE OBJECT_NAME OWNER -------------------------------------------------------- ------------------------------ table def $ _ AQCALL SYSTEM
For the DEF $ _ AQCALL table, this table is the default team list for Advanced Replication, from ORA-06512: at "REPADMIN. CEF_PUSH_PURGE ", line 145 also shows that there is indeed a problem with Advanced Replication. After the replication is completed in time, the table will be cleared. This ora-600 error is reported because an index is used in the update statement to locate a record and the record does not exist when it is queried in the table. The general solution is to recreate the index. ---- This section is derived from xifenfei (http://www.xifenfei.com/2623.html)
First, analyze the table: SQL> analyze table system. DEF $ _ AQCALL validate structure cascade; analyze table system. DEF $ _ AQCALL validate structure cascade * ERROR at line 1: ORA-01499: table/index cross reference failure-see trace file

SQL> select index_name, owner, status from dba_indexes where table_name = 'def $ _ AQCALL ';
INDEX_NAME owner status ------------------------------ ---------------------------- -------- sys_il00000000004c00025 $ SYSTEM VALIDSYS_C001407 system validdef $ _ TRANORDER SYSTEM VALID
SQL> select index_name, column_name, column_position from dba_ind_columns where table_name = 'def $ _ AQCALL ';
INDEX_NAME COLUMN_NAME COLUMN_POSITION =---------------------------- ----------------- SYS_C001407 ENQ_TID 1SYS_C001407 STEP_NO 2DEF $ _ tranorder cscn 1DEF $ _ TRANORDER ENQ_TID 2
Compare data: compare data during full table scan and indexing: SQL> select/* + index (t DEF $ _ TRANORDER) */CSCN, ENQ_TID from system. DEF $ _ AQCALL where CSCN is not null or ENQ_TID is not null 2 minus 3 select/* + FULL (t1) */CSCN, ENQ_TID from system. DEF $ _ AQCALL 4/
CSCN ENQ_TID ---------- -------------------------- 4755684454 records 3.14.22356204755684458 8.2.2231044755684460 10.30.2223096 sure enough, the index records are four more than the table data.
Rebuilding indexes online: SQL> alter index system. DEF $ _ TRANORDER rebuild onlie;
Index altered.
Compare the index and table data again: SQL> select/* + index (t DEF $ _ TRANORDER) */CSCN, ENQ_TID from system. DEF $ _ AQCALL where CSCN is not null or ENQ_TID is not null 2 minus 3 select/* + FULL (t1) */CSCN, ENQ_TID from system. DEF $ _ AQCALL 4/
No rows selected
No redundant data, through monitoring of alert. log, no subsequent ora-600 [13011] error was found.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.