当前位置:Oracle研究中心 > 故障案例 >
时间:2016-05-26 22:04 来源:Oracle研究中心 作者:惜分飞 点击: 次
alert日志
Fri Jan 27 22:00:09 2012 GATHER_STATS_JOB encountered errors. Check the trace file. Fri Jan 27 22:00:09 2012 Errors in file /oracle10/admin/ocs/bdump/ocs1_j001_29138.trc: ORA-01476: divisor is equal to zero
trace内容
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /oracle10/app/product/db/10.2.0 System name: HP-UX Node name: ocsdb1 Release: B.11.23 Version: U Machine: ia64 Instance name: ocs1 Redo thread mounted by this instance: 1 Oracle process number: 60 Unix process pid: 29138, image: oracle@ocsdb1 (J001) *** ACTION NAME:(GATHER_STATS_JOB) 2012-01-27 22:00:09.308 *** MODULE NAME:(DBMS_SCHEDULER) 2012-01-27 22:00:09.308 *** SERVICE NAME:(SYS$USERS) 2012-01-27 22:00:09.308 *** SESSION ID:(988.31342) 2012-01-27 22:00:09.307 ORA-01476: divisor is equal to zero *** 2012-01-27 22:00:09.417 GATHER_STATS_JOB: GATHER_TABLE_STATS('"OCS_SM"','"HLP_SMS_SEND"','""', ...) ORA-01476: divisor is equal to zero
错误原因
oracle unpublished Bug 5645718
解决方法
1.Setting event 38041 at level 16
sql> connect / as sysdba sql> alter system set events '38041 trace name context forever, level 16';
2.Patch 6319761
--------------------------------------ORACLE-DBA----------------------------------------
最权威、专业的Oracle案例资源汇总之案例:Oracle数据库报错 alert日志ORA-01476: divisor is equal to zero
本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/233.html
Powered by Oracle研究中心 OraclePlus Inc.
BY DedeCMS 京ICP备14022373号-5
声明:Oracle研究中心部分文章源自互联网,转载均按原文作者要求转载,如有疑问联系QQ:1026002015,协商未果24小时删除。