ORA-01565: error in identifying file '+DATA/rac/dataile/datfile/system'(一)

2015-02-02 14:42:19 · 作者: · 浏览: 324

解决办法:
?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一例解决
链接:http://www.aixchina.net/home/space.php?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


?到此解决。


?


查看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
再次启动数据库


再次启动正常
[oracle@11rac5 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Produc