Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决

    技术2022-05-11  1

    SQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '+RAC_DISK/RACDB/spfileRACDB.ora'ORA-17503: ksfdopn:2 Failed to open file +RAC_DISK/RACDB/spfileRACDB.oraORA-15077: could not locate ASM instance serving a required diskgroup

    --检查ASM实例运行情况

    [oracle@node1 ~]$ srvctl status asm -n node1ASM instance +ASM1 is running on node node1.[oracle@node1 ~]$ srvctl status asm -n node2ASM instance +ASM2 is not running on node node2.[oracle@node1 ~]$  

    能看出,在节点2(也就是出问题的节点)上ASM实例并没有启动 ,明显是asm实列没有startup.数据库的spfile又放在asm区,由于asm实列没有起来,导致数据库找不到磁盘组。

    [oracle@node2 dbs]$ export ORACLE_SID=+ASM2[oracle@node2 dbs]$ sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 17 08:57:56 2009

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.

    Connected to an idle instance.

    SQL> startupASM instance started

    Total System Global Area   92274688 bytesFixed Size                  1217884 bytesVariable Size              65890980 bytesASM Cache                  25165824 bytesASM diskgroups mounted

    [oracle@node2 dbs]$ export ORACLE_SID=RACDB2SQL> startupORACLE instance started.

    Total System Global Area  184549376 bytesFixed Size                  1218412 bytesVariable Size              96471188 bytesDatabase Buffers           83886080 bytesRedo Buffers                2973696 bytesDatabase mounted.Database opened.SQL>


    最新回复(0)