Oracle 10.2.0.x running in Archive log mode begins generating many archive logs without accompanying traffic increase (about one every couple of seconds). Space in the Archive log directory is rapidly consumed.

Issue

Oracle 10.2.0.x running in Archive log mode begins generating many archive logs without accompanying traffic increase (about one every couple of seconds).  Space in the Archive log directory is rapidly consumed.

No overt issues on the Oracle side: alert.log showing hyperactivity of the archive log generation.

Cause

Incident persister has a stuck incident.

Symptom

Massive number of archive logs being generated and presence of "ORA-01461: can bind a LONG value only for insert into a LONG column" in the incident persister log.

INFO   | jvm 1    | 2008/05/01 13:41:01 | * sql statement was 'INSERT INTO MessageComponent (messageComponentID,messageID,name,MIMEType,componentType,component,originalSize,crackedComponent,crackedEncoding,wasCracked,documentFormat,componentMetaInfo,messageComponentSaved,keyAlias) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) '
INFO   | jvm 1    | 2008/05/01 13:41:01 | * Exception message is [ORA-01461: can bind a LONG value only for insert into a LONG column

Quick fix

Deletion of the stuck incident.

Long term remedy

Application of Hotfix: 9219