ORA-15025: could not open disk"...." ORA-27041: unable to open file Linux-x86_64 Error: 13: Permiss

                               打psu最新补丁过程及遇到ORA-00205:解决过程

 error in identifying control file, check alert log for more info

今天打11.2.0.4rac的db补丁时出错

 ORA-15025: could not open disk "/dev/raw/raw4"

 ORA-27041: unable to open file
 Linux-x86_64 Error: 13: Permission denied

 Additional information: 9

补丁文件是p21948347_112040_Linux-x86-64.zip

11gr2 11.2.0.4 rac 两节点

打补丁的方式是in rolling mode（滚动方式），后来使用all-node patch模式（全关）也出现该问题

步骤1

保持两节点正常，关闭节点一的db

使用OPatch更新检查

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

没有问题。

opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /u02/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u02/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u02/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-03-16_04-47-10AM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.. 

步骤2

opatch  apply 也没有问题

  
  

   
    Patching component oracle.sysman.oms.core, 10.2.0.4.5...

Verifying the update...

Patching in rolling mode.


The node 'rac2' will be patched next.


Please shutdown Oracle instances running out of this ORACLE_HOME on 'rac2'.
(Oracle Home = '/u02/app/oracle/product/11.2.0home_1')

Is the node ready for patching? [y|n] 
  
  

步骤3启动节点一

此时节点一的db是关闭状态

 SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size                  2252824 bytes
Variable Size             452988904 bytes
Database Buffers          788529152 bytes
Redo Buffers                8892416 bytes
ORA-00205: error in identifying control file, check alert log for more info

查看alert

 Wed Mar 16 03:49:24 2016
Starting background process RSMN
Wed Mar 16 03:49:24 2016
RSMN started with pid=31, OS id=6430 
ORACLE_BASE from environment = /u02/app/oracle
Wed Mar 16 03:49:26 2016
ALTER DATABASE   MOUNT
NOTE: Loaded library: System 
ORA-15025: could not open disk "/dev/raw/raw4"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/orcl/controlfile/current.260.906535775'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/controlfile/current.260.906535775
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Wed Mar 16 03:49:33 2016
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.xxx.xxx)(PORT=1521))' SCOPE=MEMORY SID='orcl1';

--------------------------------------------------------------------------------------------------------------------------

解决过程

1）观察alert日志

/dev/raw/raw4 是我asm磁盘组DATA的磁盘，下面提示Linux-x86_64 Error: 13: Permission denied

[root@rac1 ~]# ll /dev/raw/
total 0
crw-rw---- 1 grid asmadmin 162, 1 Mar 16 04:43 raw1
crw-rw---- 1 grid asmadmin 162, 2 Mar 16 04:43 raw2
crw-rw---- 1 grid asmadmin 162, 3 Mar 16 04:43 raw3
crw-rw---- 1 grid asmadmin 162, 4 Mar 16 04:42 raw4
crw-rw---- 1 grid asmadmin 162, 5 Mar 16 04:42 raw5
crw-rw---- 1 root disk     162, 0 Mar 16 04:34 rawctl

raw4的权限没有问题。

2）查看权限，对比发现问题

后面又提示SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted，那应该oracle用户权限不对

查看节点一的权限

ll $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle oinstall 239820050 Mar 16 04:55 /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle

查看节点二的权限

ll $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle asmadmin 239820050 Mar 16 04:55 /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle

3）修改权限

修改节点一的oracle权限

login as asm_owner

我这儿时grid

[grid@rac1 ~]$ $ORACLE_HOME/bin/setasmgidwrap o=/u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle

查看节点二的权限

ll $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle oinstall 239820050 Mar 16 04:55 /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle

4）重新登陆数据库

SQL> shutdown immediate; 
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size                  2252824 bytes
Variable Size             452988904 bytes
Database Buffers          788529152 bytes
Redo Buffers                8892416 bytes
Database mounted.
Database opened.

至此问题解决

下面是步骤4 运行脚本，我就不贴了

@catbundle.sql psu apply