环境:
OS
windows 2003
DB
oracle DB 9.2.0.4
描述
今天去国税,应用程序insert 报错 ORA-00600 [7999], [9] (由于不让copy所以出错信息这里不全). alert.log 中仅有
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/