Doc ID 461911.1
Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Nov-2011***
After applying patch set 10.2.0.3, the following errors may be reported:
ORA-1461 ENCOUNTERED WHEN GENERATING SERVER ALERT SMG-3500
ORA-01461: can bind a LONG value only for insert into a LONG column
The issue is discussed in the following bug reports:
Bug 5887228: ORA-1461 GENERATED BY SMON WHILE IT IS UPDATING SMON_SCN_TIME
Bug 5982820: ORA-1461 INSERT WRI$_ALERT_HISTORY BY MMON
Bug 6145134: ORA-1461 INSERT WRI$_ALERT_HISTORY BY MMON
All above bug reports were closed as a duplicate of:
Bug 6085625 :ORA-01483: INVALID LENGTH FOR DATE OR NUMBER BIND VARIABLE
NOTE: The fix for Bug 6085625 introduced a regression for unpublished Bug 6452485: STAR:NT:RAC:ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [17182]3 - The problem is solved in:
BUG:5982820 - ORA-1461 INSERT WRI$_ALERT_HISTORY BY MMON
BUG:6085625 - ORA-01483: INVALID LENGTH FOR DATE OR NUMBER BIND VARIABLE
BUG:6145134 - ORA-1461 INSERT WRI$_ALERT_HISTORY BY MMON