Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决（及ORA-15100和ora-1031）

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

分类： Oracle 学习 2009-03-16 11:32 2789人阅读 评论(0) 收藏 举报

oracle system processing 数据库 file sql

遇到的问题：

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

解决步骤：

--检查ASM实例运行情况

使用srvctl status asm查看ASM实例运行情况

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

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

或者也可以使用crs_stat命令查看（例子摘自他处）

数据库和实例服务无法启动，如下：
[oracle@rac1 ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.....CRM.cs application    ONLINE    OFFLINE   rac1
ora....cl1.srv application    ONLINE    OFFLINE   rac1
ora.orcl.db    application    ONLINE    OFFLINE   rac2
ora....l1.inst application    ONLINE    OFFLINE   rac1
ora....l2.inst application    ONLINE    OFFLINE   rac2
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   application    ONLINE    ONLINE    rac1
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2 

[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> startup                       //查看下文说明1和说明2
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1217884 bytes
Variable Size              65890980 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

[oracle@node2 dbs]$ export ORACLE_SID=RACDB2
SQL> startup
ORACLE instance started.

Total System Global Area  184549376 bytes
Fixed Size                  1218412 bytes
Variable Size              96471188 bytes
Database Buffers           83886080 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
SQL>

=======================================================================================

说明1：

遇到的问题：

启动ASM实例时，可能会遇到ORA-15110错误，若此时，关闭实例，则会提示ORA-15100。具体如下：

[oracle@rac1 bdump]$ export ORACLE_SID=+ASM1
[oracle@rac1 bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 22 17:59:39 2008

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

已连接到空闲实例

SQL> startup;
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1217884 bytes
Variable Size              65890980 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

SQL> shutdown immediate;
ORA-15100: invalid or missing diskgroup name

ASM instance shutdown

解决办法：
1、首先挂载ASM磁盘组
[oracle@rac1 bdump]$ export ORACLE_SID=+ASM1
[oracle@rac1 bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 22 17:59:39 2008

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
RECOVERYDEST                   DISMOUNTED
DG1                            DISMOUNTED

SQL> alter diskgroup RECOVERYDEST mount;

Diskgroup altered.

SQL> alter diskgroup DG1 mount;

Diskgroup altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

==============================================================================================================

说明2：

要启动或者停止一个ASM实例，需要以sysasm的身份角色，否则会提示ora-1031：权限不足。

[grid@enmou1 ~]$ sqlplus "/ as sysdba"  

SQL*Plus: Release 11.2.0.2.0 Production on Thu Mar 17 12:36:55 2011  

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

Connected to an idle instance.  

 

SQL> startup  

ORA-01031: insufficient privileges  

SQL> connect / as sysasm  

Connected to an idle instance.  

SQL> startup  

ASM instance started  

Total System Global Area  283930624 bytes  

Fixed Size                  2225792 bytes  

Variable Size             256539008 bytes  

ASM Cache                  25165824 bytes  

ASM diskgroups mounted  

ASM diskgroups volume enabled