This error has been displayed in the alarm log for two days:
Ora-00600:internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[]
tueaug1209:20:17cst2014
ERRORSINFILE/U01/APP/ORACLE/ADMIN/ORCL/UDUMP/ORCL_ORA_29974.TRC:
ora-00600:internalerrorcode,arguments:[ Kcblasm_1],[103],[],[],[],[],[],[]
tueaug1209:30:17cst2014
errorsinfile/u01/app/oracle/admin/orcl/ UDUMP/ORCL_ORA_30084.TRC:
ora-00600:internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[]
tueaug1209:40:17cst2014
errorsinfile/u01/app/oracle/admin/orcl/udump/orcl_ora_29919.trc:
ORA-00600: Internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[]
Online Search Solutions:
1: The Temporary Solution
If the execution plan is caused by hashjoin, set the "_hash_join_enable" =false in the session layer, such as: Altersessionset "_hash_join_enabled" =false also;
If the execution plan is caused by hashgroupby, set the "_gby_hash_aggregation_enabled" =false
2: The fundamental solution
2.1. Optimize the SQL statements, avoid encountering bugs;
2.2. Upgrade
(1) Upgrade the database PSU to 10.2.0.5.4 and 11.2 to fix the problem
(2) for 10.2.0.5.0 to 10.2.0.5.3 version, play PATCH7612454 to avoid error (this patch replaces the KCBL.O file in Lib).
Example of a solution to the problem by means of a temporary solution:
Trace the trace file in the alert log to find the SQL statement that caused the error to occur
Ora-00600:internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[]
Currentsqlstatementforthissession:
The formatted SQL statement is as follows:
Selectindentdate, 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 fromelite. Tabcindenta Leftjoinelite. OBJECTIVEB ONA. Relation_id=b.objective_guid Leftjoinelite. Customerc ONA. Customer_guid=c.customer_guid WHERE (IndentdatebeTween:1and:2orb.
MODIFIEDDATEBETWEEN:3AND:4);
To replace a variable: 1,:2,:3,:4 with a specific value execution:
Selectindentdate, 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 fromelite. Tabcindenta Leftjoinelite. OBJECTIVEB ONA. Relation_id=b.objective_guid Leftjoinelite. Customerc ONA. Customer_guid=c.customer_guid WHERE (IndentdatebeTWEEN ' 2012-06-19 ' and ' 2012-08-19 ' ORB.
Modifieddatebetween ' 2012-06-19 ' and ' 2012-08-1 ');
To perform an error:
Solution:
Altersessionset "_hash_join_enabled" =FALSE;
Altersessionset "_gby_hash_aggregation_enabled" =false
-Try one, and if one solves it, there is no need to set another.
Then execute the above query again, no error, quack
Success, (*^__^*) Hee ...
Let the developer add this command to the program.