An error solution for ORA-600 [13011]

Source: Internet
Author: User
SunOS5.10Oracle10.2.0.2.0 A ORA-600 error is reported for a database in the development environment.

SunOS 5.10 Oracle 10.2.0.2.0 development environment a database has a ORA-600 error.

Sunoperating 5.10
Oracle 10.2.0.2.0
A ORA-600 error occurs in a database in the development environment.

Error message in alert. 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 145
ORA-06512: at line 1


In the/oracle/admin/sun/bdump/sun_j000_29589.trc trace file, you can see that the current SQL statement deletes a record of system. def $ _ aqcall:
Ksedmp: internal or fatal error
ORA-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)
Compare the parameters of MOS ORA-600 [13011] "Problem occurred when trying to delete a row" (Document ID 28184.1;

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 the 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.

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 VALID
SYS_C001407 SYSTEM VALID
DEF $ _ 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 1
SYS_C001407 STEP_NO 2
DEF $ _ tranorder cscn 1
DEF $ _ TRANORDER ENQ_TID 2


Comparison data: full table scan and index data comparison:
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 8.37.2233719
4755684456 3.14.2235620
4755684458 8.2.2231049
4755684460 10.30.2223096
Sure enough, there are four more records on the index than on the table.


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.

Migration from 32-bit to 64-bit for a single Oracle instance

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

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.