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

made-in-china

3371人浏览 · 2016-03-16 12:51:09

made-in-china · 2016-03-16 12:51:09 发布

打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权限

我这儿时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

Linux

更多推荐

网卡速率和双工模式的配置

http://linux.chinaitlab.com/system/792187.html1、mii-tool 配置网络设备协商方式的工具； 1.1 mii-tool 介绍； mii-tool - view, manipulate media-independent interface status （mii-tool 是查看，管理介质的网络接口的状态）

Linux

Linux虚拟文件系统之文件系统卸载（sys_umount())

Linux中卸载文件系统由umount系统调用实现，入口函数为sys_umount()。较于文件系统的安装较为简单，下面是具体的实现。1. /*sys_umont系统调用*/2. SYSCALL_DEFINE2(umount, char __user *, name, int, flags)3. {4.struct path path;

Linux

Linux系统下超级终端Minicom的使用方法（例如：连接交换机，路由器等）转http://baike.baidu.com/view/2911642.htm?fr=ala0_1

Linux系统下超级终端Minicom的使用方法 　　Linux下的Minicom的功能与下的超级终端功能相似，适于在通过超级终端对设备的管理以及对嵌入操作系统的升级，现写出Minicom的使用手册： 　　1．启动minicom 　　以root权限登录系统 　　使用命令 　　minicom –s 则minicom启动，屏