ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], [], ora-00600kcblasm_1
This error has been shown in the alarm log for the past two days:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], []
Tue Aug 12 09:20:17 CST 2014
Errors in file/u01/app/oracle/admin/orcl/udump/orcl_ora_29974.trc:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], []
Tue Aug 12 09:30:17 CST 2014
Errors in file/u01/app/oracle/admin/orcl/udump/orcl_ora_30084.trc:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], []
Tue Aug 12 09:40:17 CST 2014
Errors in file/u01/app/oracle/admin/orcl/udump/orcl_ora_29919.trc:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], []
Solution for online query:
1: temporary solution
If the execution plan is caused by hash join, set "_ hash_join_enable" = false in the session Layer, for example, alter session set "_ hash_join_enabled" = false;
If the execution plan is caused by hash group by, set "_ gby_hash_aggregation_enabled" = false
2: Fundamental Solution
2. 1. Optimize SQL statements to avoid bugs;
2. Upgrade
(1) update the database psu to 10.2.0.5.4 and 11.2 to correct this problem.
(2) For versions 10.2.0.5.0 to 10.2.0.5.3, PATCH 7612454 should be used to avoid errors (this PATCH replaces the kcbl. o file in lib ).
Example of a temporary solution:
Trace the trace file in the alarm log and find the SQL statement that causes this error.
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], []
Current SQL statement for this session:
The formatted SQL statement is as follows:
Select indentdate,
INDENTGROUP,
TRANSDATE,
TRANSBY,
TRANSGROUP,
FEEDBACKBY,
FEEDBACKGROUP,
FINANCEDATE,
FINANCEBY,
FINANCEGROUP,
TOTALCOST,
A. TOTALPAY,
PAY_CASH,
PAY_POINTS,
PAY_ADVANCE1,
PAY_ADVANCE2,
PAY_TYPE,
TRANS_PAY,
DISCOUNT_STAFF,
DISCOUNT_SPECIAL,
GAIN_CASH,
GAIN_POINTS,
GAIN_ADVANCE1,
GAIN_ADVANCE2,
TRANS_CUSTNAME,
TRANS_TEL,
TRANS_PROVINCE,
TRANS_CITY,
TRANS_ADDRESS,
TRANS_ZIPCODE,
TRANS_WEIGHT,
TRANS_COMMENTS,
INDENT_COMMENTS,
INDENT_ID,
A. PARTNER_GUID,
A. PROXY_GUID,
TRANS_TEL2,
CUST_MEDIA_ID,
CUST_PARTNER_GUID,
CUST_PROXY_GUID,
PARTNER_VALUE,
PROXY_VALUE,
CUST_PARTNER_VALUE,
CUST_PROXY_VALUE,
DEALBY,
A. FAILREASON,
ISFOOT,
S_REASONID,
DEALFAILREASON,
A. PRE_FUND,
MEDIA_CALLTYPE,
PRE_ADVANCE,
WEB_FLAG,
NEED_INVOICE,
INVOICE_TITLE,
TRANS_AREA,
ORDERTYPE,
PAY_POINTSPRICE,
A. MEDIA,
USERDEFINEDSTATUS,
CUSTOMERNAME,
CUSTOMERID
From elite. TABCINDENT
Left join elite. OBJECTIVE B
On a. RELATION_ID = B. OBJECTIVE_GUID
Left join elite. CUSTOMER C
On a. CUSTOMER_GUID = C. CUSTOMER_GUID
WHERE (indentdate between: 1 AND: 2 or B. MODIFIEDDATE BETWEEN: 3 AND: 4 );
Replace the variable: 1,: 2,: 3,: 4 with a specific value. Execute:
Select indentdate,
INDENTGROUP,
TRANSDATE,
TRANSBY,
TRANSGROUP,
FEEDBACKBY,
FEEDBACKGROUP,
FINANCEDATE,
FINANCEBY,
FINANCEGROUP,
TOTALCOST,
A. TOTALPAY,
PAY_CASH,
PAY_POINTS,
PAY_ADVANCE1,
PAY_ADVANCE2,
PAY_TYPE,
TRANS_PAY,
DISCOUNT_STAFF,
DISCOUNT_SPECIAL,
GAIN_CASH,
GAIN_POINTS,
GAIN_ADVANCE1,
GAIN_ADVANCE2,
TRANS_CUSTNAME,
TRANS_TEL,
TRANS_PROVINCE,
TRANS_CITY,
TRANS_ADDRESS,
TRANS_ZIPCODE,
TRANS_WEIGHT,
TRANS_COMMENTS,
INDENT_COMMENTS,
INDENT_ID,
A. PARTNER_GUID,
A. PROXY_GUID,
TRANS_TEL2,
CUST_MEDIA_ID,
CUST_PARTNER_GUID,
CUST_PROXY_GUID,
PARTNER_VALUE,
PROXY_VALUE,
CUST_PARTNER_VALUE,
CUST_PROXY_VALUE,
DEALBY,
A. FAILREASON,
ISFOOT,
S_REASONID,
DEALFAILREASON,
A. PRE_FUND,
MEDIA_CALLTYPE,
PRE_ADVANCE,
WEB_FLAG,
NEED_INVOICE,
INVOICE_TITLE,
TRANS_AREA,
ORDERTYPE,
PAY_POINTSPRICE,
A. MEDIA,
USERDEFINEDSTATUS,
CUSTOMERNAME,
CUSTOMERID
From elite. TABCINDENT
Left join elite. OBJECTIVE B
On a. RELATION_ID = B. OBJECTIVE_GUID
Left join elite. CUSTOMER C
On a. CUSTOMER_GUID = C. CUSTOMER_GUID
WHERE (indentdate between '2014-06-19 'AND '2014-08-19' or B. MODIFIEDDATE between' 2012-06-19 'AND '2014-08-1 ');
Execution error:
Solution:
Alter session set "_ hash_join_enabled" = false;
Alter session set "_ gby_hash_aggregation_enabled" = false
-- Try it first. If one solution is used, there is no need to set another one.
Then run the preceding query statement again. No error is reported.
Succeeded. (* ^__ ^ *) Hey ......
Let the developer add this command to the program.
Oracle login error: ORA-00600: internal error code, arguments: [6807], [AUDSES $], [144]
It may be because the basic table of the data dictionary AUDSES $ is damaged, and you cannot log on because you have to access this SESSION Logon Audit table during login.
You can fix this issue by fixing AUDSES $.
Oracle login error: ORA-00600: internal error code, arguments: [6807]
Problem
If you are not sure, contact the professional ORACLE Database repair team of shita software to help you recover it!
Shita software professional database repair team
ORACLE ORA-00600: internal error code, arguments: [qcsfbdnp: 1] How to solve
This bug is related to variable binding. You can workaround und to remove the bound variable, but you need to change the program.
It may also be related to the setting of the cursor_sharing parameter. For details, see alert. log.
If you are not sure, contact the professional ORACLE Database repair team of shita software to help you recover it!
Shita software professional database repair team