A ORA-1461 error was found today in an alert file of the 10203 database.

Today10203DatabaseAlertFile FoundORA-1461.

 

 

The error message is as follows:

ORA-1461 encountered when generating server alert SMG-3500

This error code does not exist in the 10g Official Document error manual, so you have to queryMetalinkAnd found thatOracleOneBug.

Cause of this problemSMONThe process is being updated.Smon_scn_timeTableORA-1461Error.

IfEvent:1461 trace name errorstack level 10, From the backgroundSMONThe following information is displayed in the process log:

ORA-01461: can bind a long value only for insert into a long column

Current SQL statement for this session:

Update smon_scn_time set orig_thread = 0, time_mp =: 1, time_dp =: 2, SCN =: 3,

Scn_wrp =: 4, scn_bas =: 5, num_mappings =: 6, tim_scn_map =: 7 where thread = 0 and

SCN = (select Min (SCN) from smon_scn_time where thread = 0)

AccordingMetalinkThe search result on.BugIt may appear on multiple platforms. Currently, it is found that the affected versions are10.2.0.3.

OracleNo solution is provided, and no version of the problem will be corrected. Fortunately, the problem has little impact on the system.

 

Thanks to the reminder of "Blue Ocean ",1About a year,OracleFinally released to solve this problemBugIn the patch set.Patch 6602742MediumFixedThisBug, About thisBugFor more information, seeMetalinkDocumentDoc ID: Note: 461911.1.