ORA-01513 错误处理

今天测试部一关系不错的同事找到我（平时帮测试部干了不少活，o(∩_∩)o...，认识后，server方面的问题

 

都来找我了），说一台装了Solaris 10跑oracle 10g 的PC服务器上的oracle启动不起来了，让我帮忙看

 

看。我登陆上去，

 

执行：

su - oracle

sqlplus "/ as sysdba"

startup

ORA-01513: invalid current time returned by operating system

exit

 

sqlplus "/ as sysdba"

startup nomount

ORA-01513: invalid current time returned by operating system

 

google一下，过滤掉N无用信息后，找到如下信息：

 

ORA-01513

ORA-01513:	invalid current time returned by operating system
Cause:	The operating system returned a time that was not between 1988 and 2121.
Action:	Correct the time kept by the operating system.

 

在Solaris上执行date，返回如下：

 

bash-3.00# date
Fri Apr  3 14:46:32 CST 1970

 

我靠，年份竟然变成1970了，问一下他们，说服务器昨天到今天被停电10来个小时！估计是CMOS的电源没电了，BIOS的时间被初始化成Unix的初始时间了。

 

问清楚原委，看是否还有人在上面操作，确认没问题后，在solaris上执行如下：

 

date 040314472008.20

 

稍后

su - oracle

sqlplus "/ as sysdba"

startup

 

熟悉的output出现了

 

ORACLE instance started.

Total System Global Area  452984832 bytes
Fixed Size                  2021472 bytes
Variable Size             176162720 bytes
Database Buffers          268435456 bytes
Redo Buffers                6365184 bytes
Database mounted.
Database opened.

 

搞定！以此记之！