ora-01513



AIX小机系统时间初始化，报错ora-01513，导致oracle数据库启动失败的案例

1、检查AIX 版本

#oslevel

5.3.0.0

 

2、报错解析

ORA-01513: invalidcurrent time returned by operating system

Cause: Theoperating system returned a time that was not between 1988 and 2121.

Action: Correct thetime kept by the operating system.

原因解析：

因为该版本的oracle数据库在1988之前年还未被使用，因此oracle不接受比这更早的系统时间。

由此，查看系统当前时间，发现系统初始化到了1970年1月1号。

1. 如何修复：

A、#ps -ef | grep ora_ B、kill掉所有oracle进程。 C、date 0803101015 修改系统时间为当前时间。 D、重新启动oracle，正常。

 

1. 为何系统初始化了系统时间：

使用查看日志工具查看结果： LABEL:          EPOW_SUS_CHRP IDENTIFIER:     BE0A03E5   --错误代码   Date/Time:       Fri Jul 31 15:15:20 BEIST 2015 Sequence Number: 743 Machine Id:      0001FCD1D600 Node Id:         XCKY Class:           H Type:            PERM Resource Name:   sysplanar0 Resource Class:  planar Resource Type:   sysplanar_rspc Location:          Description ENVIRONMENTAL PROBLEM   Probable Causes Power Turned Off Without a Shutdown POWER OR FAN COMPONENT           Recommended Actions         RUN SYSTEM DIAGNOSTICS.         PERFORM PROBLEM DETERMINATION PROCEDURES   Detail Data   # errpt --根据类型和类别查看错误信息初步判断是硬件或者介质故障导致系统断电。 IDENTIFIER TIMESTAMP  T C RESOURCE_NAME  DESCRIPTION 192AC071   0731151515 T O errdemon       ERROR LOGGING TURNED OFF BE0A03E5   0731151515 P H sysplanar0     ENVIRONMENTAL PROBLEM A6DF45AA   0731150615 I O RMCdaemon      The daemon is started. FFDFB692   0731150515 P H sisraid0       BATTERY PACK FAILURE 2BFA76F6   0731150515 T S SYSPROC        SYSTEM SHUTDOWN BY USER 9DBCFDEE   0731150615 T O errdemon       ERROR LOGGING TURNED ON 192AC071   0731150315 T O errdemon       ERROR LOGGING TURNED OFF A6DF45AA   0731145815 I O RMCdaemon      The daemon is started. FFDFB692   0731145715 P H sisraid0       BATTERY PACK FAILURE 2BFA76F6   0731145715 T S SYSPROC        SYSTEM SHUTDOWN BY USER 9DBCFDEE   0731145715 T O errdemon       ERROR LOGGING TURNED ON 192AC071   0731145515 T O errdemon       ERROR LOGGING TURNED OFF A6DF45AA   0731094115 I O RMCdaemon      The daemon is started. FFDFB692   0731094015 P H sisioa0        BATTERY PACK FAILURE A2D4EDC6   0731094015 I O RMCdaemon      The daemon is stopped. 9DBCFDEE   0731094015 T O errdemon       ERROR LOGGING TURNED ON 192AC071   0731093215 T O errdemon       ERROR LOGGING TURNED OFF BE0A03E5   0731093215 P H sysplanar0     ENVIRONMENTAL PROBLEM

#diag--诊断结果   The Service Request Number(s)/Probable Cause(s) (causes are listed in descending order of probability):     2529-8008:Permanent Cache Battery Pack failure.            Error log information:                  Date: Fri Jul 31 09:40:22 BEIST 2015                  Sequence number: 728                  Label: SISIOA_BAT_P     n/a              FRU: n/a                 Cache Battery Pack     U787B.001.DNWFL96-P1

检测到的硬件设备：sisioa0 All Resources       This selection will select all the resources currently displayed. * sysplanar0                           System Planar                  U787B.001.DNWFL96-   ent0             P1-T9              2-Port 10/100/1000 Base-TX PCI-X Adapter                                        (14108902)   ent1             P1-T10             2-Port 10/100/1000 Base-TX PCI-X Adapter                                        (14108902)   usbhc0           P1                  USB Host Controller (33103500)   usbhc1           P1                  USB Host Controller (33103500)  sisioa0          P1                 PCI-X Dual Channel U320 SCSI RAID Adapter   hdisk0           P1-T14-L3-L0        16 Bit LVD SCSI Disk Drive (300000 MB)   hdisk1           P1-T14-L4-L0        16 Bit LVD SCSI Disk Drive (300000 MB)   hdisk2           P1-T14-L5-L0        16 Bit LVD SCSI Disk Drive (300000 MB)   hdisk3           P1-T14-L8-L0        16 Bit LVD SCSI Disk Drive (300000 MB)   ses0             P1-T14-L15-L0       SCSI Enclosure Services Device   cd0              P4-D2               IDE DVD-ROM Drive   L2cache0                             L2 Cache   mem0                                 Memory   oppanel                              Operator panel

结论：初步判断是硬件(sisioa0)或介质故障，导致系统性能下降，进程等待过多导致系统宕机。 主板电池断电，会导致系统的时间初始化，根据以上信息查看得到结论，应该是电池出现问题，导致系统时间初始化。