重庆思庄Oracle、Redhat认证学习论坛

标题: 奇怪oracle数据库只能在一个节点启动 [打印本页]

作者: 郑全 时间: 2015-2-3 17:59
标题: 奇怪oracle数据库只能在一个节点启动

今天发现，双机配置好了，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

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

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

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

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

作者: 王硕 时间: 2015-3-12 10:18
从来不知道问题出在什么地方  

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)