linux查看磁盘 lsdsk,ORA-01565: error in identifying file '+DATA/rac/dataile/datf

环境：RHEL 5.1 32位 ，ORACLE 11.2.01在安装11G RAC建库的时候DBCA出现ORA-1503 CREATE CONTROLFILE FAILEDORA-01565 error in

环境：RHEL 5.1  32位 ，Oracle 11.2.01

在安装11G RAC建库的时候DBCA出现

ORA-1503 CREATE CONTROLFILE FAILED

ORA-01565 error in identifying file '+DATA/rac/dataile/datfile/system'

解决办法：

1、首先检查ASM实例起来没有

oracle@rac1[/home/oracle]srvctlstatus asm -n rac1

ASM is running on rac1

oracle@rac1[/home/oracle]srvctlstatus asm -n rac2

ASM is running on rac2

补充案例：

案例1：阵列坏了块硬盘导至ora-01078 ora-01565 ora-17503 ora-15077一例解决

链接：?uid=20260&do=blog&id=24793

步骤：先看在ASMCMD查看磁盘状态(lsdsk),然后重启ASM实例

案例2：因为磁盘DISMOUNTED，出现了问题，导致这样的错误 ORA-01078;ORA-01565;ORA-17503;ORA-15077

SQL> startup;

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'

ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora

ORA-15077: could not locate ASM instance serving a required diskgroup

……

export ORACLE_SID=+ASM1

sqlplus / as sysdba

SQL>shutdown immediate;

……

SQL>startup;

SQL>select name,state from v$asm_diskgroup;

NAME                            STATE

—————————— ———–

RECOVERYDEST          MOUNTED

DG1                            DISMOUNTED

SQL>alter diskgroup DG1 mount;

2、检查权限问题

节点1：

oracle@rac1[/home/oracle]ls-l /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

-r-sr-s--x 1 oracle asmadmin 173515925 Dec 24 03:15 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

oracle@rac1[/home/oracle]chmod6751 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

oracle@rac1[/home/oracle]ls-l /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

-rwsr-x--x 1 oracle asmadmin 173515925 Dec 24 03:15 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

节点2：

[oracle@rac2 ~]# ls -l /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

-rwsr-s--x 1oracle oinstall173515925 Dec 24 03:31 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle  ---问题所在

[root@rac2 ~]# su - grid

grid@rac2[/home/grid]ls-l /oracle/app/crs_home/bin/oracle

-rwsr-s--x 1 grid oinstall 152462748 Dec 24 01:20 /oracle/app/crs_home/bin/oracle

修改权限：

grid@rac2[/oracle/app/crs_home/bin]setasmgidwrapo=/oracle/app/oracle/product/11.2.0/db_1/bin/oracle

grid@rac2[/oracle/app/crs_home/bin]ls-l /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

-r-sr-s--x 1 oracle asmadmin 173515925 Dec 24 03:31 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

到此解决。

其他摘要：

网上也有类似的错误，但出现在升级到RAC的时候

链接：

ORA-01565: error in identifying file '+DATA/spfilerac.ora'

环境：DB:11.2.0.2 RAC  OS:RHEL 5.6

今天在做11GR2下面单机升级到RAC时遇到下面的问题

[oracle@11rac5 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 9 19:06:51 2012

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

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATA/spfilerac.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA/spfilerac.ora

ORA-01034: ORACLE not available

ORA-27123: unable to attach to shared memory segment

Linux-x86_64 Error: 13: Permission denied

Additional information: 3833863

Additional information: 10

查看grid与oracle用户下面的oracle文件的权限

查看grid用户下面的oracle的权限

[root@11rac5 log]# su - grid

[grid@11rac5 ~]$ ls -l $ORACLE_HOME/bin/oracle

-rwxr-x--x 1 grid oinstall 200678430 Oct  9 13:35 /u01/app/11.2.0/grid/bin/oracle

权限不正确，修改。

[grid@11rac5 ~]$ chmod 6751 $ORACLE_HOME/bin/oracle

[grid@11rac5 ~]$ ls -l $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 grid oinstall 200678430 Oct  9 13:35 /u01/app/11.2.0/grid/bin/oracle

查看oracle用户下面的oracle权限

[oracle@11rac5 trace]$ ls -l $ORACLE_HOME/bin/oracle

-rwsr-x--x 1 oracle asmadmin 228886426 Oct  9 15:29 /u01/app/oracle/product/11.2.0/db_2/bin/oracle

在grid用户下面修改

[oracle@11rac5 trace]$ su - grid

Password:

[grid@11rac5 ~]$ cd $ORACLE_HOME/bin/

[grid@11rac5 bin]$ set

set            setasmgid      setasmgidwrap  setfattr      setkeycodes    setmetamode    setsid        setup

setarch        setasmgid0    setfacl        setfont        setleds        setserial      setterm        setxkbmap

[grid@11rac5 bin]$ setasmgidwrap o=/u01/app/oracle/product/11.2.0/db_2/bin/oracle

[grid@11rac5 bin]$ ls -l /u01/app/oracle/product/11.2.0/db_2/bin/oracle

-rwsr-s--x 1 oracle asmadmin 228886426 Oct  9 15:29 /u01/app/oracle/product/11.2.0/db_2/bin/oracle

再次启动数据库：