备案网站建设书,重庆建设岗位培训系统,新产品推广方式有哪些,工程设计与建设 网站Oracle 10.2.0.3的ORA-1461错误ORA-1461 encountered when generating server alert SMG-3500经研究发现#xff0c;其是Oracle 10g的一个Bug#xff0c;并且目前只有Oracle 10.2.0.3会遇到#xff1a;造成这个错误的原因是由于SMON 进程正在 UPDATE SMON_SCN_TIME表时引发了…Oracle 10.2.0.3的ORA-1461错误ORA-1461 encountered when generating server alert SMG-3500经研究发现其是Oracle 10g的一个Bug并且目前只有Oracle 10.2.0.3会遇到造成这个错误的原因是由于SMON 进程正在 UPDATE SMON_SCN_TIME表时引发了ORA-1461下面是诊断信息DIAGNOSTIC ANALYSIS:--------------------Set the event 1461 and got the smon trace file which shows the error.SQL alter system set EVENT1461 TRACE NAME ERRORSTACK LEVEL 10scopespfile;.ksedmp: internal or fatal errorORA-01461: can bind a LONG value only for insert into a LONG columnCurrent SQL statement for this session:update smon_scn_time set orig_thread0, time_mp:1, time_dp:2, scn:3,scn_wrp:4,scn_bas:5, num_mappings:6, tim_scn_map:7 where thread0 andscn (select min(scn) from smon_scn_time where thread0)----- Call Stack Trace -----ksedmp ksddoa ksdpcg ksdpec ksfpec kgesevksesec0 opiobv opipbr opibvg opiexe opiall0opikpr opiodr rpidrus skgmstack rpidru rpiswu2kprball ktf_scn_time ktmmon ksbrdp opirip opidrvsou2o opimai_real main startORA-1461错误有时也会和ORA-01461: can bind a LONG value only for insert into a LONG column 错误一起出现。SolutionOracle提供 Patch 6602742 补丁下载可以解决问题。不过还好此错误对系统影响不大。--The End--By eygle on 2008-01-07 22:55 |Comments (0) |Case | 2701 |
