Bug 3361118: ORA-00600 [7999], [9], [], [], [], [], [], [] ON LOB INSERT

环境:
OS
windows 2003

DB
oracle DB 9.2.0.4

描述
今天去国税,应用程序insert 报错 ORA-00600 [7999], [9]    (由于不让copy所以出错信息这里不全). alert.log 中仅有

ORA-600: internal error code, arguments: [7999], [9], [], [], [], [], [], [] 这一个错误提示.

查metalink后发现跟下面的文档中信息十分相同,后将那个insert的表drop掉重新创建,clob添加的存储信息跟文档中的一样.后再insert操作alert无报错.不知道原因是为什么,应用程序已经跑了三年,一直好好的,莫名的就出了 600错误.

Bug 3361118: ORA-00600 [7999], [9], [], [], [], [], [], [] ON LOB INSERT

Bug Attributes

---

Type	B - Defect	Fixed in Product Version	10.2
Severity	2 - Severe Loss of Service	Product Version	9.2.0.4.0
Status	80 - Development to Q/A	Platform	453 - Oracle Solaris on SPARC (32-bit)
Created	08-Jan-2004	Platform. Version	-
Updated	10-May-2006	Base Bug	-
Database Version	9.2.0.4.0
Affects Platforms	Generic
Product Source	Oracle

Related Products

---

Line	Oracle Database Products	Family	Oracle Database
Area	Oracle Database	Product	5 - Oracle Server - Enterprise Edition

Hdr: 3361118 9.2.0.4.0 RDBMS 9.2.0.4.0 RAM DATA PRODID-5 PORTID-453 ORA-600
Abstract: ORA-600 [7999], [9], [], [], [], [], [], [] ON LOB INSERT

*** 01/08/04 06:59 am ***
TAR:
----
3538898.996

PROBLEM:
--------
When inserting into a LOB, the customer can get the following error:

ERROR at line 1:
ORA-600: internal error code, arguments: [7999], [9], [], [], [], [], [], []
ORA-6512: at "SYS.DBMS_LOB", line 775
ORA-6512: at "SCOTT.APPCLOB", line 26
ORA-6512: at line 1

DIAGNOSTIC ANALYSIS:
--------------------
I found a few BUGS with a similar ORA-600 error, but they all appeared to be 
fixed in previous patchset releases.

WORKAROUND:
-----------
NA

RELATED BUGS:
-------------

REPRODUCIBILITY:
----------------
Consistently.

TEST CASE:
----------
I was able to reproduce this by running the code provided by the customer. 
Strangely enough, I had to run the testcase twice in order to reproduce the
problem. The only difference would be that I tried to drop the table the first 
time, and run the procedure which didn't exist. Other than that, each time I 
run the test case now, I get the ORA-600. Run the following code to reproduce 
the error:

DROP TABLE clobTest;
CREATE TABLE clobTest (i1 INTEGER, c CLOB) INITRANS 40
LOB (c) STORE AS (PCTVERSION  90 );
--CREATE TABLE clobTest (i1 INTEGER, c CLOB) INITRANS 40
--LOB (c) STORE AS (PCTVERSION 90 CHUNK 10000 TABLESPACE clobtest );
INSERT INTO clobTest VALUES (1, empty_clob());
commit;
SET SERVEROUTPUT ON
set transaction isolation level serializable;
execute appClob(300,false)
--execute appClob(300,true)
--execute  appClob(200,false)
--execute appClob(50)
--execute appClob(100)
select length(c) from clobTest where i1=1;
*/
create or replace procedure appClob (
    p_chunks        INTEGER := 30,
    p_useAppend     BOOLEAN := TRUE
)
IS
    lob_loc     CLOB;
    v_dummy     varchar2(30050) := '0123456789';
    v_cnt       INTEGER;
    v_len       INTEGER;
    v_clobLen   INTEGER;
    v_nextPos   INTEGER;
begin
    DBMS_OUTPUT.enable(500000);
    while( length(v_dummy) < 10000 ) loop
        v_dummy := v_dummy || '0123456789';
    end loop;
--    set transaction isolation level serializable;
    select c into lob_loc from clobTest where i1=1 for update;
    v_len := length(v_dummy);
    DBMS_OUTPUT.put_line('dummyLen: ' || v_len );
    v_nextPos := 1;
    FOR v_cnt IN 1 .. p_chunks LOOP
        IF p_useAppend THEN
            DBMS_LOB.writeappend(lob_loc, v_len, v_dummy);
        ELSE
            DBMS_LOB.write(lob_loc, v_len, v_nextPos, v_dummy);
        END IF;
        v_nextPos := v_nextPos + v_len;
        DBMS_OUTPUT.put_line('v_cnt: ' || v_cnt || ' written: ' || 
(v_nextPos-1));
    END LOOP;
    select length(c)
    into v_clobLen
    from clobTest
    where i1=1;
    DBMS_OUTPUT.put_line('clobLen:  ' || v_clobLen);
end;

STACK TRACE:
------------
ksedmp kgeriv kgeasi kdlfkd kdlrsp kdl_write koklcwrite koklwrite kkxlwra 
pevm_icd_call_commo pfrrun peicnt kkxexe opiexe opiall0 kpoal8 opiodr ttcpip 
opitsk opiino opiodr opidrv sou2o main

SUPPORTING INFORMATION:
-----------------------
NA

24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------

DIAL-IN INFORMATION:
--------------------

IMPACT DATE:
------------

*** 01/08/04 07:00 am *** (CHG: Sta->16)
*** 01/08/04 07:50 am *** 
*** 01/08/04 07:50 am ***
*** 01/08/04 11:06 am *** (CHG: Sta->10)
*** 01/08/04 11:06 am ***
*** 01/09/04 01:09 pm *** (CHG: Sta->16 G/P->G Asg->NEW OWNER)
*** 01/09/04 01:09 pm ***
*** 01/09/04 01:50 pm *** 
*** 01/09/04 02:55 pm *** (CHG: Sta->11 Asg->NEW OWNER)
*** 01/09/04 02:55 pm ***
*** 01/09/04 02:59 pm *** 
*** 01/09/04 02:59 pm ***
*** 01/09/04 05:47 pm *** 
*** 01/09/04 05:47 pm ***
*** 01/10/04 12:29 pm *** 
*** 01/10/04 12:29 pm ***
*** 01/12/04 02:44 pm *** 
*** 01/12/04 02:44 pm *** 
*** 01/16/04 01:35 pm ***
*** 01/19/04 10:39 pm ***
*** 01/21/04 09:32 am ***
*** 02/03/04 04:55 pm *** (CHG: Sta->30)
*** 02/03/04 04:55 pm ***
*** 02/10/04 12:39 pm *** (CHG: Sta->11)
*** 02/10/04 12:39 pm ***
*** 02/12/04 08:48 am ***
*** 02/16/04 06:21 pm *** (CHG: Sta->30)
*** 02/16/04 06:21 pm ***
*** 03/24/04 11:38 pm *** 
*** 03/24/04 11:38 pm *** (CHG: Sta->80)
*** 03/24/04 11:38 pm ***
*** 03/29/04 08:17 am ***
*** 04/04/04 06:57 pm ***
*** 04/04/04 07:01 pm ***
*** 04/04/04 07:01 pm ***
*** 04/05/04 05:37 am ***
*** 04/05/04 08:43 am ***
*** 04/11/04 11:33 pm ***
*** 04/13/04 01:22 am ***
*** 04/19/04 01:18 am ***
*** 04/26/04 02:54 pm ***
*** 05/18/04 04:24 pm ***
*** 05/18/04 09:48 pm ***
*** 05/19/04 01:32 am ***
*** 06/03/04 01:59 pm ***
*** 06/20/04 07:04 pm ***
*** 07/07/04 03:08 pm ***
*** 07/07/04 03:12 pm ***

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11780477/viewspace-708968/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11780477/viewspace-708968/