环境: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'
在安装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、首先检查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实例
链接: 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;
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文件的权限
网上也有类似的错误,但出现在升级到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
再次启动数据库:
[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.
[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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27038344/viewspace-751553/