ORA-600 [4882] Hit on ALTER TABLE <table_name> MODIFY LOB (Doc ID 1406283.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 Alter table clause that includes lob data modifiable attributes (ex: compress , encrypt) as well as space layer attributes (ex: RETENTION) may result in ORA-600[4882].

The example below shows how problem can get reproduced:
SQL> connect scott/tiger
Connected.

SQL> alter system set "_enable_spacebg"=FALSE;
System altered.

SQL> drop table t purge;
drop table t purge
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> create table t(id number, c clob) lob(c) store as securefile t_lob
2 (disable storage in row) tablespace sysaux;

Table created.

SQL> begin
for i in 1..100 loop
insert into t values (i, rpad('a',1000));
end loop;
commit;
end;
/ 2 3 4 5 6 7

PL/SQL procedure successfully completed.


SQL> alter table t modify lob(c) (nocompress keep_duplicates encrypt cache reads logging retention max);
alter table t modify lob(c) (nocompress keep_duplicates encrypt cache reads logging retention max)
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 32227
Session ID: 401 Serial number: 64


The entry from alert.log file associated with this failure is:

Errors in file /oracle/diag/rdbms/d1v11201/d1v11201/trace/d1v11201_ora_32227.trc (incident=151453):
ORA-00600: internal error code, arguments: [4882], [0x0943ABEF8], [0x094384618], [0x09AD57178], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/d1v11201/d1v11201/incident/incdir_151453/d1v11201_ora_32227_i151453.trc
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x6AF45CA, kutyxtt_ksd_all_members()+332] [flags: 0x0, count: 1]
Errors in file /oracle/diag/rdbms/d1v11201/d1v11201/trace/d1v11201_ora_32227.trc (incident=151454):
ORA-07445: exception encountered: core dump [kutyxtt_ksd_all_members()+332] [SIGSEGV] [ADDR:0x0] [PC:0x6AF45CA] [Address not mapped to object] []
ORA-00600: internal error code, arguments: [4882], [0x0943ABEF8], [0x094384618], [0x09AD57178], [], [], [], [], [], [], [], []

and the incident trace file shows information similar to:

----- Current SQL Statement for this session (sql_id=c832gzs5h31ak) -----
update "SCOTT"."T" TIEN939fe2a0 set "C"="C"

----- Call Stack Trace -----
kqrCacheHit kqrpre1 kqrpre ktsxs_add ktsla_alloc_extent ktsla_alloc_space
ktsla_cfs_gsp ktsla_cfsgsp_main ktslagsp ktslagsp_main kdliAllocCache kdliAllocBlocks kdliAllocChunks kdliWriteInit kdliWriteV kdli_writev kdlxFlushEnc kdlx_flush kdlxdup_flush kdlwFlushLobInt2 kdlwFlushLobInt kdlwWriteCallbackOl kdlw_write kdld_write kdla_write kdlf_write kdlfCopy2SF kdlf_copy kokliclo koklcre kokleva evaopn2 updolev PGOSF634_upduaw
kdusru kauupd updrow qerupFetch updaul updThreePhaseExe updexe opiexe opiall0 opikpr opiodr PGOSF141_rpidrus skgmstack rpiswu2 kprball kzematce atbmod atbdrv opiexe opiosq0 kpooprx kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real ssthrdmain main libc_start_main start


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms