My Oracle Support Banner

ORA-1461 Is Being Reported Many Times In The Alert.log File (Doc ID 456462.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.


Symptoms

This error is being reported several times in the Alert.log file:

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

1461 trace shows the following:

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)

The error stack:

ksedst ksedmp ksddoa ksdpec ksfpec kgesev ksesec0 opiobv opipbr opibvg opiexe opiall0
opikpr opiodr rpidrus skgmstack rpidru rpiswu2 kprball ktf_scn_time ktmmon ktmSmonMain
ksbrdp opirip Cannot Cannot Cannot opidrv sou2o opimai_real main

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.