Rapid oracle archive log generation issue
Article ID: 159515
Updated On:
Products
Issue/Introduction
Resolution
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
Feedback
