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)或介质故障，导致系统性能下降，进程等待过多导致系统宕机。

主板电池断电，会导致系统的时间初始化，根据以上信息查看得到结论，应该是电池出现问题，导致系统时间初始化。