一、问题现象&＃xff1a;报表数据没有产生&＃xff0c;查看oracle小时表发现时间点停止在前一天的22:55分。

二、处理步骤&＃xff1a;

1、查看syslog日志&＃xff0c;22:55分前后log日志产生正常&＃xff1b;

2、查看logparser日志&＃xff0c;提示入库失败&＃xff08;log文件产生wrong错误日志&＃xff09;。

日志如下&＃xff1a;

[log_parser_1 msg warn main 12/05/11 23:50:11:660] Failed to commit the records to database. - java.sql.BatchUpdateException: ORA-01
653: unable to extend table WAP_USER.TAB20110512_23 by 128 in tablespace TS20110512
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:8728)
        at cn.com.asb.stat.logparser.DbHandler.commit(DbHandler.java:130)
        at cn.com.asb.stat.logparser.Worker.commitLines(Worker.java:418)
        at cn.com.asb.stat.logparser.Worker.processFile(Worker.java:333)
        at cn.com.asb.stat.logparser.Worker.run(Worker.java:508)
        at cn.com.asb.stat.logparser.LogParser.run(LogParser.java:36)
        at cn.com.asb.stat.logparser.Main.run(Main.java:132)
        at com.nextenso.mgmt.reporter.ReportingHandler.start(ReportingHandler.java:124)
        at cn.com.asb.stat.logparser.Main.main(Main.java:154)

3、查看oracle表空间使用率&＃xff08;表空间已设置为自动扩展&＃xff0c;所以不是该问题&＃xff09;&＃xff0c;

  1   SYSAUX    ONLINE 480.0 446.06 92.93%      2 SYSTEM    ONLINE 480.0 469.30 97.77%      3 TS20110504    OFFLINE 32767.0 32,763.72 99.99%      4 TS20110505    OFFLINE 32767.0 32,763.72 99.99%      5 UNDOTBS1    ONLINE 18445.0 813.42 4.41%      6 USERS    ONLINE 5.0 4.12 82.50%      7 WAP_USER_DATA_TABLESPACE    ONLINE 41848.0 41,843.82 99.99%     

4、查看当时oracle告警日志&＃xff08;文件目录为/bases/oracle/admin/CDMAWAP/bdump/alert_CDMAWAP.log&＃xff09;&＃xff0c;发现单个Datafile不足&＃xff0c;大小超过3G&＃xff0c;导致入库失败&＃xff1a;

Thu May 12 23:05:24 2011
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512
Thu May 12 23:30:04 2011
create tablespace ts20110513 DATAFILE &＃39;/bases/oradata/CDMAWAP/20110513.dbf&＃39; SIZE 3000M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM
 SIZE 1M
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512
ORA-1653: unable to extend table WAP_USER.TAB20110512_23 by 128 in                 tablespace TS20110512

 

三、解决方案&＃xff1a;

&＃xff08;1&＃xff09;通过在表空间增加一个datafile&＃xff0c;临时性解决该问题&＃xff1a;

ALTER tablespace TS20110411 ADD DATAFILE /StatOracle/CDMAWAP/CTWAP/20110411_1.dbf&＃39; SIZE 1024M autoextend on;
&＃xff08;2&＃xff09;修改创建表空间和表的procedure&＃xff0c;确保以后的表空间建立之初就是2个datafile。