ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01565: error in identifying file '+DATA/rac/dataile/datfile/system'

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

原创 Linux操作系统 作者:tonyzhou_cn 时间:2012-12-24 11:53:23 0 删除 编辑
环境: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]srvctl status asm -n rac1
ASM is running on rac1
oracle@rac1[/home/oracle]srvctl status 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]chmod 6751 /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 1 oracle oinstall 173515925 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]setasmgidwrap o=/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的时候
链接:http://luoping.blog.51cto.com/534596/1019993
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
再次启动数据库:
再次启动正常
[oracle@11rac5 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 9 19:28:34 2012
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area  839282688 bytes
Fixed Size                  2231128 bytes
Variable Size             557843624 bytes
Database Buffers          276824064 bytes
Redo Buffers                2383872 bytes
Database mounted.
Database opened.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27038344/viewspace-751553/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-06-05

  • 博文量
    53
  • 访问量
    165627