今天发现,双机配置好了,oracle在一台机器上运行正常,在另一台不能运行,看配置文件,都没有问题。
看hacmp的日志,也没有发现异常,两个节点都一样,手工执行一下启动脚本,发现了以下错误 :
# ./startorcl2.sh
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 31-DEC-1969 19:14:10
Copyright (c) 1991, 2007, Oracle. All rights reserved.
TNS-01106: Listener using listener name orcl has already been started
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 31 19:14:10 1969
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> Connected to an idle instance.
SQL> ORA-01513: invalid current time returned by operating system
SQL> Disconnected
#### ##### ## ##### ##### #### ##### #### #
# # # # # # # # # # # # # #
#### # # # # # # # # # # # #
# # ###### ##### # # # ##### # #
# # # # # # # # # # # # # # #
#### # # # # # # #### # # #### ######
再手工,执行数据库启动,也报一样的错误:
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 31 19:15:13 1969
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORA-01513: invalid current time returned by operating system
再次查看,天,日期怎么是 Dec 31 19:15:13 1969 ,修改日期,问题搞定:
# date 0202175615
Mon Feb 2 17:56:43 CST 2015
# date
Mon Feb 2 17:56:44 CST 2015
# su - oracle
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 2 17:56:52 2015
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 2516582400 bytes
Fixed Size 2086136 bytes
Variable Size 536873736 bytes
Database Buffers 1962934272 bytes
Redo Buffers 14688256 bytes